Solved

SSRS display groupings as separate tables

Posted on 2013-02-07
1
1,084 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS Parameters 10 43
Updating statistics with error notification email in SQL server 4 126
SSRS String Manipulation 6 56
SSRS 2013 - Creating a summarized report 19 68
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

732 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