Change parameter values dynamically at runtime based on textbox values/content

1 Answer 34 Views
Binding DataSource SQL DataSources Expressions Grouping Report Designer (standalone) Report Parameters
John
Top achievements
Rank 1
John asked on 09 Aug 2021, 07:36 AM | edited on 09 Aug 2021, 09:47 AM

Hey all, so I have this report which is basically to show how many staff members (count) are working inside a company on different characteristics like gender, city and education level.

For example:

                   ------  School 1  ------                 ------  School 2    ------                  ------  School3  ------  

                Male       ------        Female         Male       ------        Female           Male       ------        Female

City 1       box                          box                 box                             box             box                         box

City 2      box                          box                 box                             box             box                         box

City 3       box                          box                 box                             box             box                         box

So as seen above, I have 3 parameters (school, gender, city) which I'm feeding my oracle sql query with, and 1 data field (count) which I get as a result of the feed.

My fast and easy approach/plan was to put the field (count) in all of the boxes and change the parameters dynamically with multivalues etc. based on the boxes column/row values to automatically populate parameters, but there are no documentation on how to do that, or can it even be done?

How can I do that, or is there any other possible approach?

1 Answer, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 12 Aug 2021, 08:40 AM

Hi John,

You may test using a crosstab. I attached a sample report. Below, you can see how the crosstab was built.

Regards,
Neli
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
Binding DataSource SQL DataSources Expressions Grouping Report Designer (standalone) Report Parameters
Asked by
John
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or