I have created a stored procuedure with the paramter social code. And created the Crystal report .
I want to allow user to select mulitple social code. I modified the stored procedure input paramter to multiselect. but when I preview the report it is passing null value to stored procedure.

Actually, this is a SQL limitation, not a Crystal Reports limitation. SQL doesn't allow multiple value input parameters. That being said, I have a technique for getting around the limitation. The basic steps are:

1) Create an empty crystal report with a multiple-value string parameter
2) Create a formula that joins all of the selected values into a single string array
3) Build a subreport that uses either a parameterized SQL Command or Stored Procedure as its data source
4) Link the main report to the subreport on the formula in the main report to the parameter in the Command or Proc

The benefit to this approach is that you get the Crystal Reports multi-parameter functionality and can still pass it into the SQL for efficient processing. Here's a sample report:

1) You need to make sure the datatype for your formula are the same as the data type for your parameter field in your proc.
2) Since your formula is creating an array of values that's formatted like this 'A','B','C' you'll need to make sure your proc accounts for an array like this table.field in (@parameter)
3) When you link the main report to the subreport, crystal will automatically create a parameter starting with ?pm- . You do NOT want to link based on this field. Instead, drill down into the possible parameter values and select the actual parameter that exists inside the proc.

My sample report does not have an on demand subreport. The question is whether or not your report has an on demand subreport. If you have to click it to see the results then yes, it's an on demand subreport.

I hate sub reports and always consider them the last resort in any reporting solution. The negative effect on performance and maintainability is just not worth the easy ride they give the report writer. Nine times out of ten reporting requirements…

Hello everyone,
Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8.
We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…

This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…

In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…