Hello,
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
Thanks
Kenny