Can I change the Order of my Groups 2

[mulema]

Hi all,
I would like to know how to do this, with a parameter (i.e if its possible at all)
I have a report with two groups GH1, and GH2. I would like to know how, using a parameter, I can have the report change its grouping order to GH2, then GH1. I do not want to suppress any of the groups. Just a way to flip the order of my groupings back and forth.

Thanks.

 

[synapsevampire]

This would depend upon what data types you're grouping by.

Create 2 formulas to use as the group fields instead of the table fields directly:

@Group 1
If {?GRPparm} = "City" then
{table.city}
else
{table.zip}

@Group 2
If {?PrimaryGRPparm} = "City" then
{table.zip}
else
{table.city}

-k

 

[markajem]

You may want to try reading a thread that I posted for something like this. It helped me.

http://www.tek-tips.com/viewthread.cfm?SQID=798208&SPID=149&newpid=149&page=1

Mark

 

[Ngolem]

to expand a little on SV's post

You must match data type in the conditional formulas

the easiest way is to convert all values to strings

for example let us say you want to group by DATE/STORE or STORE/DATE

then the formula for Group 1 would be

//@Group1 (NOTE: This is a case where WhilePrintingRecords is NOT used)

if {?Parm} = "Date" then
totext{{Table.datefield},"yyyy") // we assume yearly here
else if {?Parm} = "Store" then
{Table.StoreName}
else
//Always have a default for bad parameter entry
totext{{Table.datefield},"yyyy");

For Group 2

//@Group2

if {?Parm} = "Date" then
{Table.StoreName}
else if {?Parm} = "Store" then
totext{{Table.datefield},"yyyy")
else
{Table.StoreName};

hope this helps


Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!