Crystal Report - SQL SP Parameter Dynamic Values
Posted: Thu Jan 30, 2020 1:40 pm
I created a Crystal Report that runs based off a SQL stored procedure. One of the parameters in my SQL stored procedure is Client. Crystal reports automatically created a parameter @Client that maps to the SQL parameter. I am trying to set that @Client parameter in Crystal to show a prepopulated drop down of values where the user can choose one and that will be passed into the stored procedure. I tried to do this by using the PARAMETER_VALUES parameter, but for some reason it is not working and is causing an error.
Can I use the PARAMETER_VALUES parameter to create a prepopulated drop down of values for a parameter that was created from a SQL Stored Procedure or does that only work for parameters manually created in Crystal?
Can I use the PARAMETER_VALUES parameter to create a prepopulated drop down of values for a parameter that was created from a SQL Stored Procedure or does that only work for parameters manually created in Crystal?