Splitting 1 dataset into 1 or more charts in SSRS

• Jared

  SSC Guru

  Points: 61793

  More actions

  October 15, 2012 at 12:20 pm

  #269516

  So I have a data set that looks like this in SSRS:

  CREATE TABLE #dataset (schoolName VARCHAR(15), yearNum INT, studentPop INT)

  INSERT INTO #dataset

  SELECT 'SchoolName1', 2009, 500

  UNION ALL

  SELECT 'SchoolName1', 2010, 600

  UNION ALL

  SELECT 'SchoolName1', 2011, 800

  UNION ALL

  SELECT 'SchoolName1', 2012, 1100

  UNION ALL

  SELECT 'SchoolName2', 2009, 500

  UNION ALL

  SELECT 'SchoolName2', 2010, 400

  UNION ALL

  SELECT 'SchoolName2', 2011, 450

  UNION ALL

  SELECT 'SchoolName2', 2012, 600

  SELECT SchoolName, yearNum, StudentPop

  FROM #dataset

  So, as you can see, this sample dataset returns 2 different schools with 4 years of student population in each. In SSRS, I want to make a chart for SchoolName1 for the 4 years population, then have a second chart on page 2 with the information for SchoolName2. If the data set had 100 schools, I would want 100 pages. I know we can do this with the matrix, but can it be done with charts?

  Jared
  CE - Microsoft

• Jared

  SSC Guru

  Points: 61793

  More actions

  October 15, 2012 at 12:53 pm

  #1549279

  I figured it out! Drop a List control onto the report, get to its properties and make the dataset the same as the chart, and group by "schoolName" for the list. Set the page break for the grouping. Finally, drop the chart into the list and delete the first column without deleting the group. 🙂

  Jared
  CE - Microsoft