Skip to Content
Former Member
Mar 26, 2010 at 06:49 PM

Dynamic parameters and Report Stored Procedure



I am a SSRS developer and I want to find out how I can achieve the following in Crystal reports

I want to create a picklist which is populated using a stored procedure lets say SP_All_Countries

and then when the user selects any country from the picklist I want to pass the value selected

to a stored procedure SP_Get_Report_Data which will have a parameter called pCountry

this stored procedure will return all the Customers for the selected country

Is this achievable in Crystal Reports , I want to do filtering on the Database server as opposed to pull everything in the report and then filter it on the report, because we can have 100K+ customers in every country

Please advise