How to add parent group fields to the left of the child fields in SSRS reporting

Posted on 2014-08-06
Last Modified: 2014-08-21
Hi Experts,
Is it possible to group table/matrix information so that you have the parent information then the child (detail) then grouped again with the parent data?

See picture below. I want to show the linked controls after the risk information. But I then want to show the risk scores after the linked controls but grouped. Otherwise I will end up with repeated Risk Scores for all the linked controls.
Please see attached Grouping-with-Control-in-Middle-of-Risk-.

Is this possible?

Many thanks,
Question by:Papa1NZ
    LVL 37

    Accepted Solution

    I think it should be possible, possibly by nesting a second table inside the main one.  The nested table would be used to display the list of controls.

    If the above is not sufficient to help you figure it out, could you post some sample data which I can use in an example?

    Author Comment

    Hi Valentino, Sorry for the late reply but have been travelling. I have used the nested table before and it works ok but there are some issues which I can't get past which means I can't use it. Hopefully you have a better way?  
    Problem 1:  If you only have one column the report looks fine. However as the above example appears there are two columns. If you nest a table for two columns then the table appears like it is a table within a cell. E.g. table stops when it reaches the last item in the control list.  This is an issue as the vertical line separating the control name and description does not continue to the next risk item group. E.g. When the Risk Description causes the Risk column to grow vertically longer than the combined linked controls then the middle column separator stops at that point as well. Is their a way to make the two control items 'Control name' and 'Control description' line up with each other and the vertical line separating them also continues past the last control row.  
    Problem 2: I also had issues with the word document rendering. The table cells seem have their own column length adjustments. E.g. the vertical lines didn't line up when the Control Name was to long. It pushed all the other control lines out of alignment. Seems to be a MS word rendering issue but still and issue I don't know how to avoid. Any ideas. Do you still require the example. I have sensitive data. So I would need to create a mock up script and report.
    Many thanks for your help!

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    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…
    Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now