Grouping based on parameter

[Jyme]

How do I use a parameter to determine the grouping order?..I want to have it so that theres 2 choices, one selection will group the recordset by payertype, payer, costcenter and the other by payertype, costcenter, payer.

thanks

 

[Turkbear]

Hi,
Create 2 Formulas and
Use If tests to set their value:

It appears that you want
payertype to be the Top group in all cases so just use a standard Insert Group to set it.

Then have 1 formula for Group2
and 1 for Group3 -
Like
@Group2
If parameter = 'CtrFirst'
then
{costcenter} else
{payer}

@Group3
If parameter = 'CtrFirst'
then
{payer} Else
{costcenter}

Insert these formulas instead of the actual fields as the 2 inserted groups.

One caveat: The fields must all be the same datatype..