Grouping by End User Selection

[ksaab2002]

Hi there,

I am using CR10.

I have a group parameter {?GroupBy} with single selections allowed: Break1, Break2, Break3

and a grouping formula {@Group} that uses a select case like below:

Select {?GroupBy}
case "Break1" : {SALEITEM.SORT1}
case "Break2" : {SALEITEM.SORT2}
case "Break3" : {SALEITEM.SORT3}
Default : "None"

The report grouping section is then supressed or displayed based on a selection or "None"

My question is: is it possible to make a formula so that the {?GroupBy} parameter can be a selection of any of the fields present in a given report?

Do all End User grouping selections have to be hard coded as above or are there more graceful ways to grant grouping options that I am not seeing?

Any input/examples appreciated..my goal is to present as many singular grouping options as possible and for a few reports add maybe a secondary grouping as well..

Thanks,

KSaab

 

[lbass]

I think your current approach is the only way.

-LB

 

[synapsevampire]

Unfortunately you've addressed this about as well as it can be.

Crystal doesn't have a macro type of variable which can be a pass through value, nor does it have a collection one might iterate through (from within Crystal).

With CR XI one might cheat this, or by using code to do parameter collection.

-k

 

[ksaab2002]

Thank you both, I thought this was the case, but wanted to make sure no one else had come up with something I wasn't seeing