Skip to Content
0
Former Member
Sep 23, 2008 at 10:28 PM

grouping but dynamic sorting

15 Views

I am grouping my records based on one field, say TestID, but I want the report can be sorted according to a prompt parameter, say TestID,TestName or TestLocation, assuming both at the same grouping level.

The output is like this

TestID1 | TestName1 | TestLocation1
-------------------------------------------------------------
                                    UserID | UserName
                                    UserID | UserName

TestID2 | TestName2 | TestLocation2
-------------------------------------------------------------
                                   UserID | UserName
                                   UserID | UserName

I am using XI R1. Thanks for any advice.

Edited by: Peter Wang on Sep 24, 2008 12:28 AM