Grouping by prompt values

[KeertanaCR]

Hi,

I have a report, which i need to group it by based on user selection.

Ex: @groupprompt has four values: A, B, C, D.
Multiple values are allowed.

When the user selects A, i need to group the data by A.
similarly for B, C and D.

If the User selects A, B then i need to group the data by A
and then by B.

the same way, if the user selects A, B, C, D
i need to group the data by A then by B then by C then by D.

I am using Crystal Xi. Any thoughts are really helpful.

Thank you

 

[lbass]

So A,B,C,D are string labels for different fields to group by? If so, you could create four formulas like, e.g.,:

//{@GrpA}:
if {?parm} = "A" then {table.number}

//{@GrpB}:
if {?parm} = "B" then {table.date}

//{@GrpC}:
if {?parm} = "C" then {table.string}

//etc.

Insert a group on each formula. If the the parm value is not selected the grouping will have no impact.

-LB

 

[KeertanaCR]

Thank you