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

[John]

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?

[Neli]

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