Solved

SSRS display groupings as separate tables

Posted on 2013-02-07
1
1,016 Views
Last Modified: 2013-02-07
I have a manual report that I'm trying to automate in SSRS.

In this report, there is a table for each manager in our company. Each table is identical as far as column headers goes, just different data (record for each employee and their job numbers). I've written a query that pulls up all of the information I need for the report and groups by manager.

I was hoping there was a way to do grouping in SSRS where each group was displayed as a separate table with it's own headers. I have one data set with all of the data for each manager in it. The number of managers can/will change over time, so I don't want to get into writing a separate query for each manager.

I know I how to group normally in SSRS within one table and I will end up doing that and making the sections collapsible if there's not a way to dynamically create tables off of groups like I'm asking. I'm just trying to make the report as close as possible to the original for the sake of the people that are used to the report as it is in it's current manual state.

As clarification of what I'm looking for, I want:

Manager1
col1, col2, col3
subtotals

Manager2
col1, col2, col3
subtotals

etc. Each with their own table borders/headers. I just wasn't sure if that is even possible in SSRS.
0
Comment
Question by:Josh_Blade
1 Comment
 
LVL 6

Accepted Solution

by:
liija earned 500 total points
ID: 38864197
You cannot create tables dynamically in SSRS.

But you could add groups to managers without collapsing. If you add two header rows to the group - and remove the borders from the other one - I think the final result would look the way you want - each manager has its own table. Though they are actually share one common table. The first group header would act as the actual header.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

896 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

19 Experts available now in Live!

Get 1:1 Help Now