Use Parameter to Sort All Group Levels

[checkai]

I have a report that has 3 levels of data. I want to allow the user to select a sort order that sorts that summarized field for ALL levels of drill down.

Any Ideas?

Thanks,
DLC

 

[synapsevampire]

I'm not certain what you want, perhaps some example data and expected output will help.

You can create a parm which has the choice of the three fields and use that formula as the sort order, but I doubt that it's that simple.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[stormtrooper]

If you are referring to viewing the reports then you would have to group on all 3 levels in order to enable drill down on them. But like Vampire said, some data or format of output would help.

 

[checkai]

Some Data:

Office ID, 1st Qtr #, 2nd Qtr #, Total (Top Level)

Employee ID, 1st Qtr #, 2nd Qtr #, Total (Second Level)

I want the use to be able to sort on any of the # values.

Thanks,
Dustin

 

[stormtrooper]

Okay. Assuming you could drill down on all 3 levels. Do you want the user to be able to sort the data or to select a certain value?

 

[MColeman]

I have a report where the user can pick between styles and
each style is sorted differently.

I added a parameter for report style. Then I created a forumula called @sortfield. If the reportstyle = R, then I set the @sortfield to the region, else I set it to the Division.

I added a group level based on the @sortfield. If the user chooses the region style, the regional report prints.

Hope this helps.