reporting services - SSRS Multi-series Chart -


i have requirement below. need show number of clients in chart based on income , age group.

x-axis -> <10k <20k <50k <100k <200k+

y-axis -> age group(20-30, 31-40, 41-50, 51+

the chart should show count of clients falls on income , age range. example, there 20 clients in age group 20-30 income < 10k , 30 clients income less 100k. have show 20 on bar chart under 20-30 age group , <10k range.

is achievable in chart in ssrs?

yes - possible.

in chart group by, need use expression achieve income , age groups.

=iif(fields!age.value < 20 "<20",   iif(fields!age.value < 30 "20-30",   iif(fields!age.value < 41 "31-40",   iif(fields!age.value < 51 "41-50",   "51+")))) 

and similar 1 income axis:

=iif(fields!income.value < 10000 "<10k",   iif(fields!income.value < 20000 "<20k",   iif(fields!income.value < 50000 "<50k",   iif(fields!income.value < 100000 "<100k",   "<200k")))) 

now @ it, last range 100,000k+

what kind of chart making? y axis contain count of clients each group.

update: bar chart, use series create separate bar each age group in income group this: enter image description here imagine double-precision category income group , type category (atom, athlon, xeon) age.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -