Solved

SSRS display groupings as separate tables

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

707 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