Sorting not based on a Group in the report

[ssudha]

Hi all,

I have a report that is grouped on a certain field. There is a field in the page header. I want the records to be sorted based on the field in the page header, but not based on the group (should be original order as in the database).

Any idea and formula will be highly appreciated.
Thanks in advance.

 

[lbass]

You could try this:

Add a group based on the page header field. Then go to the change group expert, select the new group and move it so that it is now Group 1, and your original group is Group 2. Then select Group 2, go to Options, and change the order to "original order."

-LB

 

[ssudha]

Hi,
That's exactly what I did and could get the result. But the groups have about 30 fields. It took some time. But it solved the purpose.

Thanks.