Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Parameter

Hi All,

I have to create a  parameter in crystal reports where I need to show if user wants to he can choose 1 or all for all id's and if he opts for option2 he has to enter id to display the results.

if ?id = all then id = all id's

else ?id = ?id

Thanks,
Chandu

Tags:
replied

You'd first need to modify the existing command object:

1) Add a prompt in the command window

2) Add it to the where clause so that it looks like this:

Where

({Prompt} = 1 OR

Table1.ID = {Prompt})

3) Create a second command object based on the guidelines from my previous reply. Just replace 'ALL' with 1 as I gues you want the number 1 to be the wildcard

4) Do NOT join this command to the other command object

5) Go to the Field Explorer > Edit the prompt > Set it to Dynamic and under Values choose the field from the second command object that you create in step 3.

-Abhilash

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question