Dynamic Grouping In Crystal Reports 8.5

[JackDev]

How do I programatically change the group based on what the user selects in the parameter dialog box?

 

[chris6user]

you need to use AddGroup method.

 

[JackDev]

Do you have an example? I am new to crystal reports.

Thanks

 

[IdoMillet]

Jack,

Email me (ixm7@psu.edu) and I'll send you a report (using the sample database that comes with Crystal) that demonstrates the technique.

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

http://www.MilletSoftware.com

 

[Ngolem]

Let us say you have a Parameter with 3 options

"1", "2", "3"

you create a formula using this form

@Grouping1

if ?Param = "1" then
{table.field1}
else if ?Param = "2" then
{table.field2}
else if ?Param = "3" then
{table.field3}
else
{table.field??} ; // a default option for improper input

MAKE SURE ALL VALUES ARE OF THE SAME TYPE!!! I usually use strings and convert numbers to strings. Using strings also allows you the option of not having a group at all....all you do here is make the "else" value a constant.

Jim Broadbent