Using parameter to change grouping

[purtman]

I am writing a report in Crystal Reports 10. I want to add a parameter to give the users the ability to group and/or sort by a parameter. How do I use a parameter to give the user this functionality? Thanks.

 

[synapsevampire]

There's some trciks to doing so based on different data types:

So fill the parameter with the names of the fields they might group by.

Now create a formula like:

if {?GroupParm} = "Zip" then
{table.zip}
else
if {?GroupParm} = "State" then
{table.state}
etc...

If the data types are different you'll need to adjust for them.

I should probably write up a FAQ on this as numerics and dates present interesting challenges.

-k

 

[purtman]

Thanks! I'll give it a shot here in a bit.

 

[synapsevampire]

Basically the numerics would use something like:

picture(totext({table.integer},2,""),"000000000000")

Dates would be:

totext(currentdate,"yyyyMMdd")

-k