Crystal Reports Parameters

[Former Member]

Hello SAP Users:

                    I am having some problem with Crystal Reports and Parameters. I want to put only those values in the parameter field to be selected by user that are selected by some query by the parameter itself. For example if I have a GroupCode field, I will like to retrieve only those values in the parameter field which are less than 101 from the database from which user will be select values according to his needs.

Regards.

[Former Member · Accepted solution]

Hi Salman

First, create a parameter with name XXXX@select * from OWHS

XXXX is the parameter in SAP user input, then @, then query

then filter data only the parameter value by click select expert

The above method can be used for 8.8,

cheer

Gary

[Former Member]

Thanks a lot to both of you guys. I stand grateful.

[Former Member]

Would you please mark as correct or help if the respond was correct or helpful??

[abhilash_kumar]

Hi Salman,

You would need to write a separate SQL Query and add it as a 'Command Object' in the report.

You don't need to link the fields in this query to the other tables of the report. This query would be used as source for the parameter.

-Abhilash