Solved

SSRS display groupings as separate tables

Posted on 2013-02-07
1
996 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

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 All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
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…

758 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

21 Experts available now in Live!

Get 1:1 Help Now