All values not showing in the parameter in Crystal Report

In order for you to pass parameters into a stored procedure, you need to build the parameters into the procedure as opposed to building them in Crystal Reports.  Furthermore, SQL doesn't allow multiple value parameters.  You have a few options, but it depends on what you need to do:

• Why are you using a stored procedure?Is there something  you're doing in the procedure that would be less efficient in a view, such as heavy data manipulation, creating/dropping temp tables, using cursors, etc..?
   
• If so, a procedure or  a SQL command is probably the right data source.
   
• If your procedure could easily be converted into a view because you're not really using it to do any "heavy lifting", then it's probably the wrong data source.  If you can use a view, you can use the Crystal Reports native multi-value parameter functionality.
   
• What version of Crystal Reports are you using? 
• If you're using Crystal Reports 2008 and need the power of a procedure, I'd recommend converting the SQL to a SQL Command, since Crystal Reports 2008 allows you to use multi-value parameters against SQL Commands (Crystal basically built a front end to allow what is otherwise a SQL limitation) 
• If you're using a prior version and need the power of a procedure, you can still create a multiple value param, but it's more complicated - you'd need to put the procedure into a subreport.  You'd then create the multi-value parameter in the main report, collect the values into a string formula and then pass the result of the string formula to the subreport procedure parameter through the subreport links.  Works well, but is complicated. 

Hello Kurt,
this is my explanation, sorry for the detail, but I'm really confused as to why this is not working.  
Im building the stored procedure, and including the @providerid as a parameter.
Then passing to crystal reports, (Im using XI)
The reason Im using a stored procedure or even a view is because I have a field in one table called service title and another field in another table called locsection.  I need to concatenate these two fields together to bring in as a cascading parameter.  Ill attach some screen prints.  But this is working fine, except it does not see this one service, which has the same criteria as the others that are coming in.

Im using a stored procedure because I am going to be brining in a lot of data.  I eventually want to also using the start and end date in addition to the providerid, in the stored procedure, so that cuts down on even more data coming into the crystal report. Now the stored procedure is displaying just the providerId data that I need.  From the crystal report, once the data has been filter by the Providerid and start and end date, once that is in the crystal report, then I can create cascading parameters and other formula in the Record Selection.  

The view is on the other hand is doing everything I need, except, after I bring in the view, since it doesnt have parameter, Im getting all the providers, which will put a lot of data in the crystal report.  

Im also using a front end application to upload these reports, so I have to pass the providerid.  

Thanks, a


t working..