Crystal Reports Group By and MySQL mediumtext field

[SShanker]

Hello Friends,

I have connected Crystal Reports to MySQL database 4.x.
Now I want to run a query using the group by option on a mediumtext data type field. But as Crystal Reports does not allow to do a Group by on a mediumtext field is there any way i can convert the field to String and then do a group by ?

Thanks for your help in advance.
Shanker.

 

[synapsevampire]

Sure, create a SQL Expression to convert it, as in:

SUBSTRING(table.field,1,100)

I think that's the MySQL means to do so.

Then group on the SQL Expression field.

This is Crystal version dependent, and since you're a programmer, you already understand that not posting such basic information means that people have to guess because you didn't want to take the time to post basic information, so please always post your software version with any post in any forum, as solutions vary.

-k

 

[SShanker]

Hello synapsevampire ,
Thank you so much for your help. It just took me a while to understand as I started working on Crystal reports just to solve my problem, with no prior experience but it worked flawlessly.
Shanker.

 

[SShanker]

Hello synapsevampire,
Sorry for the delay in reply.
Shanker.