How to make drop down parameter in crystal reports

1
votes

I have certain parameters in the crystal reports which would be passed directly into Stored procedure in sql . Parameter A has 5 values and I want to enable them for users so that when user opens up the report , he is able to select any number of parameters values in the drop down based on which report data would be filtered. Please advise

2
sql-server-2008crystal-reportscrystal-reports-2008
Are the parametes values static or those coming from database – Siva
Have you placed the parameter on the design? – Siva
@Siva Parameters are static , values passed into the parameters would be passed into the Stored procedure . Parameters are Placed on the Crystal Report , when opened ,user should be prompt to select multiple values from the drop down of parameter – Gooks

2 Answers

1
votes

For a parameter to select multiple values you need to enable the option allow multiple values to true.

enter image description here

1
votes

As I know, in designing a report in Crystal Reports you can use a simple SELECT like this:

SELECT CAST(0 AS int) AS Id, CAST(0 AS varchar(0)) As Name

That will give you two fields like Id, Name and you can use them in your report.

Now, you can use that type of SELECT statement instead of running a stored procedure like EXEC SP1 @P1 = P1, @P2 = P2 just inside of your report designer and running that stored procedure when you are filling the Data-Set of your report.