SAP Crystal Reports Dynamic Grouping with multiple group by's parameters

[former_member1000583]

I would like to build a report that provides up to 3 levels of grouping, based on parameters passed to the report from Charles River application, but I want the output stop at the lowest grouping level that the user defines.

For example, the report can be grouped by CLIENT#, STORE# and ITEM#. If the user wants to see sales by client, then they would only group the report by CLIENT# and see sales data per CLIENT#. If the user wants to see item sales by store then they would group by STORE# and then ITEM# and the report would display the STORE# and then list each ITEM# and sales on the following rows.

I've created 3 groups, parameters and formulas to manage this, but I'm not sure how to design the report to only display to the grouping level passed from Charles River ... I always see the 3 grouping levels appear on the report.

Is there a way to report only to the lowest grouping level defined by the user?

As a beginner, can you provide specific details on how to accomplish this?

Thanks in advance!

[DellSC]

The way that Crystal works, if you have three separate parameters defined, all three will always appear when you run the report - even if you allow null values for the parameters so that they don't have to have values. There is no way around this short of writing your own application to set the parameters and run the report.

-Dell

[abhilash_kumar]

Hi David,

Could you post a screenshot of how the parameters are defined?

Are there 3 separate parameters - one for each grouping level?

-Abhilash