dynamic grouping

[ceccina]

Hi!
I'm using CR 9. I create a parameter to choose data field for grouping and a formula like this:
if {@group = 'A'}
then {field A}
else {field B}
I placed this formula in report header and suppress it from viewing (as in on-line help).
I grouped my data on this formula, but the result is that data are always order by filed B. I'm sure the parameter is correctly initialized with 'A'.
Can you help me?

 

[IdoMillet]

Your condition:
----------------
if {@group = 'A'}
then {field A}
else {field B}
----------------
is referring to the Group formula instead of the Parameter.

Use:
----------------
if {?group_by_parameter} = 'A'
then {field A}
else {field B}
----------------

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ceccina]

Thanks! The solution is always in front of your eyes!