Fields: ParentGroup - (Subgroup) Details - ParentGroup
I'm searching for a way to display some Fields of the Parent Group right of the details of the child goup.
Ordername, Article, Article price, Orderdate, Ordersum
Ordername, Article, Orderdate and ordersum belong together in the parent group and should be displayed only once and aligned in the middle of the group field.
Article and Article belong to the child and could be many detail rows.
June 12th, 2012 8:31am
OK, this can be done easily.
In the table on report body select the Details Row, right click and choose
Insert Row > Outside Group - Above. In this new row above your details row (which will act like header) add the parent fields (Ordername, Article, Orderdate and ordersum). On the details Row add the repeating rows.
Free Windows Admin Tool Kit Click here and download it now
June 12th, 2012 8:36am
Hi There
Please follow the steps
Drop a tablix inside your report add the fields which you would like to display multiple time in the details row.
Right click on the details row and add group and then select parent group please make sure that you have check the add group header option
Now put all your fields
you would like to display once in that group and you are done
If you have any questions please ask.
Many thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
June 12th, 2012 8:41am
Wow you are quick. Both are 99% answers.
On the parent group on the left all values are aligned vertical in the middle (over as many rows as detail has). This alignment isn't possible on the right beacuse there I still have the detail rows with no possibility to merge them with the header.
Free Windows Admin Tool Kit Click here and download it now
June 12th, 2012 9:37am
You can also delete the group columns.
Ex: The column on the left part of the table (which belongs to the parent group), right click and choose Delete Column. It will ask wherever you want to
delete the column only or the group associated with it. You choose to
delete the column only and leave the group.
Now continue to by adding a new row as I explained before. This way you can create a stepped hierarchy (you may also want to set left padding for the details row to something higher than 2pt).
June 12th, 2012 9:43am