Post reply

Groups on top of Details - Subreport?

  • March 18, 2016 at 4:28 am

    #305744

    Hi All,

    I have yet to use subreports so I want to verify I am selecting the right solution for the challenge 🙂 My requirement is to have the grouping data separate, e.g. on top of, the group members data. This report will display multiple groups. I have attached an image which I hope will help.

    Remembering my lack of experience in this type of report layout , I am thinking that I need to have a main report which would include the Group data and then a sub report that has parameter for the group primary key and a dataset/tablix listing the member detail records?

    If that is the case...

    * Do I need to create a Group details tablix and then embed the subreport inside?

    * Is it possible to actually use Textboxes for the Group details? I ask that because in my head that would provide me with the most flexibility in terms of formatting.

    Thanks

    Steve

  • March 18, 2016 at 7:21 am

    #1866132

    Hi Steve,

    Surely this can be achieved just by using a parent group over the details?

    Right click Details in the row groups and Add Parent Group with a header row. Then set up your group header values there.

    If you want extra headings over the details, add another row with the parent group and enter the column names, they will only be repeated when the group changes.

  • March 18, 2016 at 8:49 am

    #1866157

    Hi Spiff,

    I have never tried putting a group in rows directly above the detail that way before, I might give it a go. Though I had thought, and this might be my ignorance talking, but I am imagining that I would be somewhat limited in layout because everything is stacked in columns. Thinking back I shouldn't have used Excel to create my example.

    I am trying to avoid having to manipulate 'columns/rows' via merging/adding so that the labels and values in the 'Group Header section', e.g. the 4 columns, would not be dictating how the Details data, which might be 10 columns, is laid out. As I have had to do in Excel in the past.

    I will give it a try but I also came to another conclusion that is the 'subreport', Group Details, might be used in multiple reports so it could be useful as a subreport.

    For the life of my though I can't figure out how to create the main report so that the sub-report is displayed for each group.

    Thanks for your time Spiff

    Steve

  • March 18, 2016 at 10:28 am

    #1866179

    No worries, I get what you are saying, the excel example looked like it lined up neatly.

    Have a look at using the List control for what you are after. It's like a tablix but more free-form, I think it will allow you to do what you need.

  • March 18, 2016 at 10:32 am

    #1866181

    I haven't used the List before either, will give it a go.

    Thanks again Spiff, enjoy the weekend!

    Steve

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply