CODEWITHSUNDEEP
sql-serverreporting-servicesreportbuilder
nav100
nav100

Reputation: 61

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 Row1
                   Child Row2

Upvotes: 1

Views: 1655

Answers (1)

Matt Thomas
Matt Thomas

Reputation: 463

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.

Upvotes: 2

Related Questions