Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group based on parameter

Status
Not open for further replies.

kutoose

Technical User
Sep 11, 2002
169
US
Crystal Version : Crystal Reports Version 10

I have a report in which the parameter value is passed from front end.
One of the parameter is a check box. There are four check boxes.
The user has to select at least one check box to run the report.
The format in which this value is passed to the report is 1,2,3,4.
ie., if the first check box is selected then the parameter passed is 1
if first and second are selected, then 1,2 ; if all are selected, then 1,2,3,4.

I need to group the data in the report based on these parameter values.
For example if 1,2 are selected, then the data should be grouped by '1' and
then by '2'. Else if the parameter is 1,2,3,4 then the groups should be 1 , 2 , 3 and 4

How can this be achieved ?


kutoose@yahoo.com
 
Data isn't grouped on parameter values, it's grouped on fields. Parameters aren't data, they're used to filter data.

Just group by whatever field these values are applied against, then in the record selection formula apply the parameter criteria, as in:

{table.field} = {?MyParameter}

Hope this resolves, if not, please post relevant information about how these parameters are used, and the tables they're being used against.

-k
 
You are right synapsevampire.
I did not think twice before posting.

kutoose@yahoo.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top