crystal report logic to filter values

building reports crystal reports
1

I have this in the report.

ID—NAME----PRODUCT

X1------ABCHEM----A
----------------------B
-----------------------C
X2------HAJAC------D
----------------------G
----------------------E
X3----RAJSN-------F
---------------------A
---------------------H

The report is grouped by ID and Name.
Issue: I need to have a prompt for product where if I enter a product, I should get all the details where that product is available. In this case if I have a prompt for product and select product A , I need to display the following results in report.

ID—NAME----PRODUCT
X1------ABCHEM----A
----------------------B
-----------------------C
X3----RAJSN--------F
----------------------A
----------------------H

Crystal XI
SQl Server.

matthew (BOB member since 2005-04-08)

2

To create a prompt go to Parameter Field in Field explorer located right side of the screen. Define the parameter name then choose Dynamic as List of Value. Under Value choose the product field name then click OK.

After you create the Parameter, go to Report then Select Expert then choose Record. Find the Product field name then choose the Parameter Field name as equivalent value. Click OK when your done.

This way you will filter the report by product you selected.

nahtanoj :philippines: (BOB member since 2009-07-08)

3

I already tried the approach. It returns.
ID—NAME----PRODUCT
X1------ABCHEM----A
X3----RAJSN--------A

But the requirement is to give all the details where A is present. So it should return

ID—NAME----PRODUCT
X1------ABCHEM----A
----------------------B
-----------------------C
X3----RAJSN--------F
----------------------A
----------------------H

matthew (BOB member since 2005-04-08)