Is there a way to change the order of the grouping for a report.

For instance, I have a report file that I am trying to use to replace two existing report files.  To get this to work, I need to group one report by Width, then by Length.  The other report needs to group by Length, then by Width.

This grouping is the only reason that we have multiple report files...

If there are any tricks or methods to do this, I would love to know, thank you in advanced for your help.




Edited by Anubisascends - 28 Apr 2009 at 7:11am

The problem is that I need to group by the width and length (or vice versa)

I have the width and length displaying properly, I just need to change the order of the grouping.

Here is the default order of the groups:

Group 1 = Parts.Width
Group 2 = Parts.Length

I want to make a formula that I can change it to this:

Group 1 = Parts.Length
Group 2 = Parts.Width

I need to do this because there can be thousands upon thousands of records in the database.  Using this grouping (and a few others) I can give a count of the all the parts that are the same:

Name,
Size,
Material

Which will, in turn, shorten the printed report greatly.

That is awesome...I never even thought of doing that....

thank you so much, this will drop my number of reports that I need significantly....