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

x
?
Solved

SSRS Reports - get rid of blank columns

Posted on 2016-09-09
3
Medium Priority
?
122 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
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

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 …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

886 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