开发者

Reporting Services format for master detail

开发者 https://www.devze.com 2023-04-01 09:27 出处:网络
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.

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号