x

SSRS chart grouping

Hi, I'm trying to convert a Crystal Report report to SSRS. In CR I've added a chart to a group, and in the output the chart is repeated once per group.

For example if I have sales figures for a number of regions I would group by region name and display product vs sales in the chart. The result would be a chart of product vs sales for each region.

How is this done in SSRS? I can use 2008 or 2008r2...

Dave.

more ▼

asked Mar 17, 2010 at 09:22 AM in Default

avatar image

dave 4
104 2 4 7

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

  1. You have to create a table on the report
  2. In the table you define groups of your needs
  3. In the detail of the table you put Rectangle
  4. Put chart inside the Rectangle

In this way you will have one chart per a group.

more ▼

answered Mar 17, 2010 at 09:56 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

(comments are locked)
10|1200 characters needed characters left

The way it worked for me (impossible without Pavel's excellent contribution):

  1. Add a Tablix to your report (this example assumes it’s a matrix);
  2. Drag the field you want to have in your chart category onto the first row area
  3. Right click the same cell and add a row group for the same field - be sure to tick the "add group header" box.
  4. Add the field you want in your chart data field to the matrix data area
  5. Add a rectangle to the group header cell (second along, second down)
  6. Drag a chart object to the new rectangle
  7. Drag the category field to the category drop zone for the chart
  8. Drag the data field to the data field drop zone for the chart and choose the appropriate aggregation
  9. Delete, or render invisible the matrix cells you don't want
  10. Preview :-)

more ▼

answered Mar 24, 2010 at 06:07 AM

avatar image

dave 4
104 2 4 7

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x679

asked: Mar 17, 2010 at 09:22 AM

Seen: 9800 times

Last Updated: Mar 17, 2010 at 09:22 AM

Copyright 2016 Redgate Software. Privacy Policy