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

Posted on 2012-09-12
Last Modified: 2012-09-18
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.
Question by:Gary Harper
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    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.

    Author Comment

    by:Gary Harper
    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.
    LVL 22

    Accepted Solution

    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:

    Author Comment

    by:Gary Harper
    Option #2 worked.  Thank you so much for your recommendation.  It was spot on.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
    This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
    This video discusses moving either the default database or any database to a new volume.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now