locked
Recursive Grouping - Page Break RRS feed

  • Question

  • Hi,

    I've an organization hierarchy report to do. This way:

    Manager1

    subordinate 1 (no reportees)

    subordinate 2

             subordinate21

             subordinate22

    subordinate 3

    subordinate 4

             subordinate41

             subordinate42

    I would need to apply page break when a new- sub hierarchy starts.. In the above example, for Subordinate 2 and 4..

    How do i achieve it. Please assist.

    Thanks!

    Serena

    Monday, December 10, 2012 8:18 PM

Answers

  • Hi Serena,
    Based on your description, I create a similar report with recurisive hierarchy group in my test environment. The report data is group by “TimeId” and resursive parent group is “TimeParentId”. In the Group section, I specify the pagebreak loaction with “Between” and the value expression of Disable  propertity as follows.
    = IIF(Fields!TimeParentId.Value= previous(Fields!TimeParentId.Value),True,IIF(Fields!TimeLevelName.Value="month",False,True))
    The following screent shot shows the design strueture of the report and preview, please take as reference.

    If I have any misunderstanding, you can post both the report and the dataset with sample data to us by the following E-mail address?  It is benefit for us to do further analysis.
    E-mail: sqltnsp@microsoft.com


    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    • Proposed as answer by Fanny Liu Friday, December 21, 2012 2:08 AM
    • Marked as answer by Fanny Liu Monday, December 24, 2012 1:21 AM
    Tuesday, December 18, 2012 5:04 AM