• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1302
  • Last Modified:

Display two charts on the same page with two different datasets by group

I have two charts that I need to display on the same page by the same group.  I placed two tables with separate datasets with charts inside the tables.  The first dataset groups correctly by page.  The issue is the second dataset with the charts appear after the last page of my dataset.  Even though they are both grouped by the same field it will not keep the chart on the same page.  Is there a way to get around this?  Please advise.
0
Gary Harper
Asked:
Gary Harper
  • 2
  • 2
1 Solution
 
Nico BontenbalCommented:
Do you mean you have two different data sets that you want to show side by side and synchronize the two based on one of the fields?
Could you upload your report here, along with the pdf of the output and a detailed description of what you need.

Would it be possible to get all the data for the report in one dataset so you could use one table with two charts?
Another option might be to put the two charts in subreports and use those in the table on the main report.
0
 
Gary HarperAuthor Commented:
I tried to use on stored procedure using a UNION statement however it is excluding some of the results that are necessary in the second chart.  Attached is the rdl and the pdf output.  I would like for the report to appear as the design in the rdl file.  Right now my second dataset charts appear at the end of the report instead of on the same page as the first chart.  They are both grouped by u_lab so I was expecting the same lab info to be displayed for both charts.  That is the behavior I am trying to achieve.
Chemistry-Test-Count.rdl
Chemistry-Test-Count.pdf
0
 
Nico BontenbalCommented:
Your report is rendered from top to bottom. So SSRS first displays the first table (Tablix2) and then the second table (Tablix1).
I think your only options are:
1. Mixing the two datasets into one. But since you already tried this without any luck I think you should go for:
2. Create a main report with a table grouped by lab. Inside this table place two subreports, one for each chart.
For more information about subreports see:
http://msdn.microsoft.com/en-us/library/ms160348(v=sql.100).aspx
http://technet.microsoft.com/en-us/library/dd239314.aspx
0
 
Gary HarperAuthor Commented:
Option #2 worked.  Thank you so much for your recommendation.  It was spot on.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now