1. Feedback
  2. Report Platform
  3. 9759

Welcome to the Report Platform feedback portal. We’re happy you’re here! If you have feedback on how to improve the Report Platform, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

0
Votes

Report Designer Component - Parameters with "Allow Multiple Values" does not work

Report dataset with @parameter defined in the report and the parameter is a Query value from another SQL dataset.  However, it does not seem to support "Allow Multiple Values" on the parameter.

When "Allow Multiple Values" is checked, the values in the parameter drop-down have checkboxes so that multiple values can be chose, but the report encounters the following error:

Data cannot be retrieved for 'DataSet1' dataset, Error Detail: 'Message: Incorrect syntax near ','. Error Number: 102 LineNumber: 2 Source: Core .Net SqlClient Data Provider Procedure: '


----------------------------------------------------------------------------------------------------------

Yes, we have tried changing = to "IN" in the SQL, this still throws an error because the values for the parameter at strings, so they must be wrapped in quotes to be used with "IN".

We also tried changing the select for the query values so that the string parameters would have single quotes around them.  Something like this:

SELECT '''' + CompanyName + '''' from dbo.Company

Using this approach with "IN" eliminates the error message, but does not return any data at all when a parameter, or multiple parameters are selected.