Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS display groupings as separate tables

Posted on 2013-02-07
1
Medium Priority
?
1,152 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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serveā€¦
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installatiā€¦
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Screencast - Getting to Know the Pipeline
Suggested Courses

885 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