Reporting Services format for master detail
How do I display Master Detail records on the report. I am trying to display in the following format.Could you please let me know how to do this? I appreciate any help.
My query returns in the following format.
Parent_id Parent_name Parent_value Child_Column
----------------------------------------------------------
1 test 20 child row1
1 test 20 child row2
1 test 20 child row3
2 test2 88 child row4
2 test2 88 child row5
My report format should look like.
Record1: test 20
Child Rows: Child Row1
Child Row2
--------------------------------------------------
Record2: test2 88
Child Rows: Child Ro开发者_Go百科w1
Child Row2
You'll want to create a group on Parent_Name and Parent_Value in the designer. You can then add the group header to display your desired output. From there you'll want to add the necessary fields in the details section. I know this sounds vague, but it's hard to explain without the IDE. Hopefully you understand enough about SRS and SQL to get started with this suggestion.
精彩评论