Thanks alot for your quick reply.
Yah, I am new to this Crystal Reports.
I am using crystal 8.5 version
database used is sql server 2000. Basically I am not using any front end.
I want out put like this
Category 1:
text a value
text b value
Category 2:
text c value
Category 3 value
Category 4 value
I have created static fields for category 1, category 2. and based on condition I suppressed them.
texta , textb, textc, category 3... are from database.
I have to move category 3, 4 otherwise it will be part of category 2.
Hope the question is clear. Please let me know otherwise.
Thank you before hand.
chennuri