Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSRS Reports - get rid of blank columns

Posted on 2016-09-09
3
Medium Priority
?
116 Views
Last Modified: 2016-09-15
I have been creating reports in SSRS.  I have created a report, using the wizard, to set the grouping (one field) and the rest are in the detail section.  Works great.  Here's my question:  the grouping field has a single row.  the rest of the grouped records are on rows below the grouping row.  The column for the grouping field is empty, which wastes space on the report.  How can I move all the other columns left so that they line up below the grouping field?
0
Comment
Question by:dhenderson12
[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
  • 2
3 Comments
 
LVL 16

Expert Comment

by:Megan Brooks
ID: 41792079
I'm assuming that you are using a reasonably recent version of RS (2008 or later), and that you created a parent group, and that you now have a column for that group in addition to the detail group. If that is the case, you can delete the parent group column without deleting the parent group itself (it should prompt you for what to do), and you can then add a row above the detail row "outside group" (that is, outside the detail group). That row will belong to the parent group. You can merge its cells if that helps with the formatting.

I can possibly provide more information, if you provide more details. I'll take a moment and run the wizard just to see what it does with nested groups. I've almost never used it in 16+ years of working with SSRS, because it almost never comes up with something close to what I want.
0
 
LVL 16

Accepted Solution

by:
Megan Brooks earned 2000 total points
ID: 41792134
If you use the "stepped" option of the wizard then it gives you the parent group in the first column and the child group in the second column (assuming just two levels). You can cut the parent group textbox from the first column and paste it into the second. Then you can delete the first column. But this is why I don't use the wizard. With a little practice, it's easier to drop a table data region onto the blank design surface and define the cells and groups you want with a few clicks.

I also tried "blocked," by the way, but that looked worse.

If you have a number of reports that have a similar style, you can create an RDL file containing the common elements to serve as a template. Copy and rename it into the project directory and add it to the project as an existing report. You can create the template RDL file using the wizard or from scratch.

Instead of copy/paste/rename, you can add template RDL files to Report Designer, but I don't know of a way to do that that works well with teams of developers and I've never used it for that reason. It might be useful for a single person.
0
 

Author Closing Comment

by:dhenderson12
ID: 41799965
sorry for the delay in responding.  thanks for your help.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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…
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.   …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

715 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