PARAMETER GROUPS

[OT2]

Hello, I am using CR9 to modify a report using a single parameter. Currently our users open the report and select every single portfolio they would like to see on their report. I would like to group this paramater so that our users can select a goup of portfolios. For example instead of having to select 10 portfolios indivually they can select 1 group that includes those 10.

Thank you for your help.

 

[synapsevampire]

Try posting technical information.

Database/connectivity
Example data
Expected output

A portfolio isn't very descriptive, is this a field in the database. or some derived grouping, or?

If it equates to a field, then you would probably be better served to create a table on the database that builds out the hierarchy for you.

In Crystal you might use in the Report->Edit Selection Formula->Record:

If {?MyParm} = "HI" then
{Customer.Customer Name}=split("IBM,DELL,AMERICA",",")
else
If {?MyParm} = "BYE" then
{Customer.Customer Name}=split("APPLE,NAZIS",",")

This will pass the SQL to the database as well, so performance should be optimal.

-k