INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SSRS 2014 - Paging prob - need to include multiple objects and 2 different datasets per page

SSRS 2014 - Paging prob - need to include multiple objects and 2 different datasets per page

SSRS 2014 - Paging prob - need to include multiple objects and 2 different datasets per page

(OP)
Hi Everyone
I have a report that includes a table using dataset1 grouped by facility. The table is set to include column headers, 18 months worth of data and totals.
Directly beneath the table is two side by side pie charts using dataset2 grouped by facility.
Lastly once I get the first two working I will be adding three bar charts using dataset1 grouped by facility.

So each page will be Table, 2 Pies, 3 Bars grouped by facility.
This is set up to fit on one page.

I have the Facility row group for the table set to page between each instance of a group.
I've tried incorporating each object in a single rectangle and setting the page breaks on the rectangle but I keep getting the table on the first page and then the table repeats on the second page followed by two sets of the pie charts. The only thing that appears to be paging correctly is the table.

What am I doing wrong?
Thanks in advance.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close