Crystal Report 7.0: Group on data type:memo/blob field

[MsPepperMintUSA]

Crystal Report 7.0
Sybase 6.0

I have a report which has 4 subreports. All the groupings are perfect except for 1 subreport. Within that one subreport, it is necessary to group on a memo field. (The field is long, but the text is duplicated through-out the report, i.e. same description but varies by date.) The built-in grouping functionality does allow groupings using a memo or blob data type field.

I need suggestions on how to handle this in a "back-door" manner.

Is it possible to incorporate my own sql statement into the grouping based on the memo data type field?
If it is possible, where do I import or write the sql statement so it is recognized by the report and actually sorts according to my sql statement.

 

[MsPepperMintUSA]

I have found a workaround for grouping fields which are memo. I found the solution at

http://support.crystaldecisions.net

article ID C2007285.

It is tedious and time consuming, but a solution until CR supports the memo field.

The short explanation: (1) varchar and (2) field lengths greater than 255 are converted to memo fields. The workaround: In the database environment - parse out the field into smaller parts use char to define the field. Import the smaller fields into Crystal Report. Once inside CR concatenate fields and use formulas as you like.


It worked for me..... Hope it works for you..

 

[Guest_imported]

Hi, I tried to do the same..to split the string from the DB and concatenate it on Crystal Reports..but it show me an error that even I concatenate it on a formula I can not print it beccause is larger than 255.

 

[lyanch]

Don't concatinate them. Put them one after another inside a text field. It will put them back together for you automatically.