Report Parameter not auto-selecting all items in the Array.

[Michael]

I have a report where I define multiple values to be auto-selected in the Report Parameters value Array. All the items in the Array are selected at report run time but one. I can select the one item on the fly, but I cannot figure out why it is not automatically doing it. The string in question is "RA1".  I am adding the report and screenshots.

[Nikolay]

Hello, Michael

I could not reproduce the issue on my part, neither with CSV, nor SQL DataSource.

A possible cause for this issue is that the text from the Values "RA1", does not match the one in the SQL database. Can you make sure that they are identical?  Can you check for any extra spaces or characters with different Unicode values?

Can you look it up and let me know if you were able to resolve the issue, if not can a attach the sample from the database table? 

Regards, Nikolay Progress Telerik

[Michael]

Nikolay,

I am quite sure the work center name is spelled correctly in the database, as you can select the work center from the parameter drop-down at run time and it works. I attached some screenshots from my database. The query is the actual query from the report with the filter added for this instance.

Thanks,

Mike

 

[Nikolay]

Hi, Michael

The probable cause for this issue must be some difference in the field value 'RA1', but it is not visible from the attached screenshots. 

Before continuing the discussion, please contact your sales representative to renew the Telerik Reporting license. After that, you may open a new support ticket, where you may share sample data so that we can test your report locally to see if we can reproduce the issue locally with your dataset.

Looking forward to hearing back from you.