Thanks for your reply.
I'm not trying to pass multiple values to a single SP parameter, just get Crystal to provide a list of possible values for the user to select (just one) and pass that to the SP.
I have considered using a view... it won't work. I tried it and I couldn't get it to work...
I am developing a report in Crystal Reports XI using a stored procedure from a SQL Server 2005 database. The sp has a parameter. I want to limit the values a user can use for this prompt. I have edited the auto-generated parameter field to specify this list of values.
The problem is: when I run...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.