Crystal Parameters do not show all values from query
Posted on 2014-03-31
Report written in Crystal XI using a SQL command as the datasource. When the command is run in SSMS against the data, it returns all records. I have created a parameter to prompt the user dynamically to select a range of values from a field in the query (user name). However, the parameter list does not show all of the available user names. Without the parameter and the condition on the parameter, all values for all user names are shown. The minute a parameter is used, the report only offers a subset of user names.
Also, creating a parameter from the Command window does nothing, clicking Create creates the parameter but the minute you exit from the command window, the parameter disappears.