Recursive Grouping - Page Break RRS feed

  • Question

  • Hi,

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


    subordinate 1 (no reportees)

    subordinate 2



    subordinate 3

    subordinate 4



    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.



    Monday, December 10, 2012 8:18 PM


  • 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

    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