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

2 Answers 36 Views
Report Designer (standalone) Report Parameters
Michael
Top achievements
Rank 1
Iron
Iron
Michael asked on 16 Aug 2023, 02:38 PM
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.

2 Answers, 1 is accepted

Sort by
0
Nikolay
Telerik team
answered on 21 Aug 2023, 09:06 AM

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

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
0
Michael
Top achievements
Rank 1
Iron
Iron
answered on 21 Aug 2023, 03:18 PM | edited on 21 Aug 2023, 03:19 PM

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
Telerik team
commented on 24 Aug 2023, 01:42 PM

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.

Tags
Report Designer (standalone) Report Parameters
Asked by
Michael
Top achievements
Rank 1
Iron
Iron
Answers by
Nikolay
Telerik team
Michael
Top achievements
Rank 1
Iron
Iron
Share this question
or