Dynamic Parameters Display- Based on User Inputs

[Nansat]

Here is the problem scenario

Report has to display product sales and each of these prodcuts belongs to specific classes.

ex: class prod
1 12
1 18
1 109
2 5
2 11
3 10
3 98
3 101

Report is generated by grouping first on 'Class' and then by 'product'

Requirement>> I want to give an option to user like..
'whether you want report at classlevel or product level?'

1))If user says 'class level'
Then display all the classes available in ther paraments
He should be able to say 'All' or make selection of the specific classes

2))If user says 'prod level'
Then display all the products available. He should be able to say 'All' or make selection of the specific products.

Can we have handle parameters Dynamically like above?? If so can somebody give me some hints please??

Thanks in advance

 

[paulmarr]

Firstly you haven't mentioned the version of Crystal you are using - Dynamic Parameters are only available with Crystal XI - it is not possible within Crystal Reports in previous versions.

Cheers
paulmarr

 

[satinsilhouette]

I would build a manual parameter, the values would be class level or prod level. Then I would create a formula based of the parameter:

if {?parameter} = "Class Level" then field1


else if {?parameter} = "Prod Level" then field2

Third, I would change my first group to to pick up this formula as the group. This would drive the report by the group, not select criteria.

Try that.

 

[Nansat]

I am using Crystal Reports XI.