SSRS bar chart with multiple categories

0
votes

I have built some quite ssrs charts, but is it possible to create below bar chart n SSRS.

![click on the link below to show the bar chart][1]

but when am creating this in ssrs , am getting report as below.

I am getting the report in ssrs as below, but not like the above one:

![][2]

1
reporting-servicesssrs-2012
Yes it is possible - Manoj
Thank you for your comment, Can you please brief me how to achieve this, i was trying but this is coming like as below. - user3851739
post your result then i can able to help you out - Manoj
Added the report, find the link in above - user3851739
Suggest me how the data should be like to get report like this in SSRS - user3851739

1 Answers

0
votes

If you want to include the heading as they are in your first image, you will need to be clever with your dataset.

Personally I would probably take the approach of including dummy chart values to get your Category heading without a corresponding bar in the chart, such as:

Group          Order  Category       Value
31 to 60 Days  1      31 to 60 Days  0
31 to 60 Days  2      Today          14
31 to 60 Days  3      1 Month Ago    12
31 to 60 Days  4      2 Month Ago    44
Up to 30 Days  1      Up to 30 Days  0
Up to 30 Days  2      Today          11
Up to 30 Days  3      1 Month Ago    8
Up to 30 Days  4      2 Month Ago    21

From which you can:

  • Group your Categories using the Group value
  • Display each Category in its correct order by sorting on the Order column
  • Actually display your chart values using the Value column, which will show nothing for your group headings

How you get your data into that format will depend on your data source, but should be fairly trivial if you are using a SQL source.