Group by one field and sort by another field

[krishna]

Hi

I am reporting against a recordset. I have 2 columns in the recordset colA and ColB. I have ordered the recordset using colB. In Crystal Report I have gropued the report using ColA. Now I would like to show the report as the same order as recordset data that is sorted by ColB. I would like to remove the default sorting order created by crystal based on the group. Is this possible?

Regards
Krishna Kumar

 

[kenhamady]

I think you are lookig for the grouping option called "original order". Go into the change group expert and set the group field to ColA, but change "Ascending" to "Original Order". Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[krishna]

Dear Ken

Thank you. Thats exactly what I was looking for.

Regards
Krishna Kumar