Post reply

Report design Approach for 3 level of Grouping in the List report.

  • February 29, 2012 at 7:42 pm

    #265370

    HI,

    I’m trying to design a SQL Reporting for below mentioned scenario.

    The scenarios is,there are 3 level of groping, the detail part will repeating kind of section (It’s like List report).

    So I start with list report, and then applied 3 groups.

    But my final report output looks below format.

    Group1 Group2 Group3

    First Name:ABC LastName:XYZ DOB:2/22/1979

    City:NMK State:KA

    Zip:23222

    First Name:ABAC LastName:XAYZ DOB:12/22/1979

    City:NMK State:KL

    Zip:23272

    But I need to get below format of the report

    Group1

    Group2

    Group3

    First Name:ABC LastName:XYZ DOB:2/22/1979

    City:NMK State:KA

    Zip:23222

    First Name:ABAC LastName:XAYZ DOB:12/22/1979

    City:NMK State:KL

    Zip:23272

    Can you suggests me how do design in order to get above structure of report output.

    Thanks.

  • March 1, 2012 at 2:19 pm

    #1453880

    When doing row groups I usually build the detail section of the report. Next I right click on the left edge (Gray area) of the row and say add Group >> Parent Group and include at least a Header, and tell the group what data to group on.

    Then to add the next group, you do pretty much the same thing but instead of right clicking on the detail row, you right click on the header row of the group you already added, and then do that one more time for your 3rd grouping.

Viewing 2 posts - 1 through 1 (of 1 total)

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