Crystal Reports and Unseen Fields

[fuzzie bear]

I'm trying to create a formula in Crystal Reports. I'm using the table Catalog_section.

I want to create a formula on the field section_text. However when I go into the formula editor that field isn't available for selection and there are also a lot of other fields that aren't available for selection.

Any ideas ?

[Jan]

You can use memo fields in formula in crystal reports, you need to define a view in access that selects only the first 255 characters and then you can access the data through that view.

Regards,

[fuzzie bear]

Thing is, I need the last part of the description and if I format to 255 I lose this. I've tried using Instr functions etc to get what data I want, but access just isn't letting me do any querying on that field !

Even when I format to 255, I still can't see the field in crystal reports...

[Jan]

I can't quite work out what you are doing, suggest you contact Duncan Rounding for some paid for consultancy.

Regards,

[sally01]

Hi All,

I have the same problem with trying to use a Memo field within an SQL statement. I've tried to create a view within Access but it throws an error of
'Syntax error in CREATE TABLE statement'

Below is the view i'm trying to create so that I can see sValue. Any ideas please.

CREATE VIEW UserDefinedPropertiesView
AS SELECT nID, nVariableID, nUseParentSetting, sValue, sContentID, nContentLevel, sStatus
FROM UserDefinedProperties

[Jan]

Create a new query :

SELECT nID, nVariableID, nUseParentSetting, sValue, sContentID, nContentLevel, sStatus
FROM UserDefinedProperties

then save it as UserDefinedPropertiesView

Access doesn't accept the create VIEW statement.

Regards.

[agilbo]

Crystal Reports sourcing

I'm trying to amend and create reports for a customer but am having trouble finding a copy of Crystal reports 8.5 Standard. Looks like all the normal supply channels go back to version 9 only.

Can anyone point me in the right direction please?

Andrew Gilbert
Dominion

[Jan]

You can often buy a copy of ebay, if you can't find one, you can contact business objects sales team, they should be able to sell you a copy of the latest version and then downgrade it to 8.5 for you.

Regards,

[agilbo]

Thanks, Jan I will contact BO sales