RDLC report: How to keep group on same page

ArkananArkanan Member Posts: 28
edited 2015-06-04 in NAV Three Tier
Hi,

Here's my problem: I created a custom report. In the Layout I added a tablix with group.
The purpose of this tablix is to display quote's information:
The table group 1 displays the name of a service and the tablix lines display the differents Service:

Service1
Subservice 1
Subservice 2
Service 2
Subservice 1
Subservice 2

The problem is if there is to much lines in a service, this lines are splits in to pages:

Service1
Subservice 1
Subservice 2
Service 2
Subservice 1
Page break
Subservice 2

I would like the hole service to be display on the second page in such case.

I try to set the "keep together" function of the table to TRUE but nothing change.

Thanks for the help;
Ark@

Comments

  • postsauravpostsaurav Member Posts: 708
    Hi,

    If i am not wrong your group will be on Service, i.e in the below sample you will have two groups Service1 & Service2.

    If i am correct please navigate to Group Properties and Select Page Break From Left Menu of Group Properties.

    Select Between each instance of Group as shown below -



    ** But if there are more lines in SubService the info within group will still appear in Next Page..

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • ArkananArkanan Member Posts: 28
    Hi,

    Thanks for your reply but I can't find the menu "Page break" :s

    I forgot to say I'm using dynamics NAV 2009 R2 with visual studio 2008. Does this menu exist only on later versions?
  • postsauravpostsaurav Member Posts: 708
    Hi,

    In That case refer below screen for page break.


    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • ArkananArkanan Member Posts: 28
    Hi,

    The problem with this option is that the page break will automatically occurs after each service. So even if the 2 first services fit on the first page they will be displayed on 2 pages. And if I have 3 service, they will be displayed on 3 pages even if they would fit on less pages.

    I ould like that page breaks occurs only if subservices don't fit on the sames page :s I don't even now if it's possible but... would be great if so :)

    Ark@
  • postsauravpostsaurav Member Posts: 708
    Hi,

    It seems that you need conditional page break.

    Yes that is possible but you need to check the possibility in your case.

    1. You can count how many lines can appear in a page.
    2. You can have count of subservice lines and Service Line at code level.
    3. Based on the count and max. line you can set a Boolean which can be used to page break.

    ** I am thinking loud and not sure about possibility.

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • bzkrt19bzkrt19 Member Posts: 4
    edited 2017-03-02
    Is there any solution about that? I have the same problem. (for NAV 2013 R2)

    I cannot count the lines, because it is always different within a group.
  • FiddiFiddi Member Posts: 46
    I think you should test the "Keep together" and "Keep with Group"- Properties on the Groupings.
    (be shure to acrivate the "Advanced Mode" in Group designer)
  • bzkrt19bzkrt19 Member Posts: 4
    Thank you for the answer. I am using the Visual Studio Report Designer. So, is it possible to find that mode and the property "Keep with group"?
  • FiddiFiddi Member Posts: 46
    Yes.
    https://saurav-nav.blogspot.de/2013/12/nav-2013-r2-report-repeat-table-header.html activates the "Advanced mode". The Property is located in the Properties of the Groups and Lines in the Grouping Pane
  • bzkrt19bzkrt19 Member Posts: 4
    It does not function :/

    Following data:

    I have 4 rectangles in the tablix:

    Rectangle 1 -> with textboxes
    Rectangle 2 -> with textboxes
    Rectangle 3 -> with textboxes
    Rectangle 4 -> with textboxes

    And there is existing a group with these rectangles.
    The group has the property KeepTogether: True.
    All the rectangles have the property KeepTogether: True.

    In the advanced mode, all static elements have now the property KeepTogether: True and KeepWithGroup: After.

    But it makes a page break after rectangle 3.
  • FiddiFiddi Member Posts: 46
    edited 2017-03-02
    first: if there is not enough space on that page or the group would not fit on a page there will be a page break.
    second: you have to check also properties of the lines before and after the group and your group should not have "KeepTogether: True"
    third: "KeepTogether" in Tablix-Entries works only if all Fields in a Tablix- Row have the same value
  • bzkrt19bzkrt19 Member Posts: 4
    Thanks.

    Lines before and after the group are part of other groups. Changes have no effect.

    Now, I have removed the property "KeepTogether: True" for the group. No changes...

    Maybe an useful information: the group with the four rectangles is a child group of another group.

    The intention is to keep that four rectangles like that:

    Page 1:
    Rectangle 1
    Rectangle 2
    Rectangle 3
    Rectangle 4

    Rectangle 1
    Rectangle 2
    Rectangle 3
    Rectangle 4

    Page 2:
    Rectangle 1
    Rectangle 2
    Rectangle 3
    Rectangle 4

    Rectangle 1
    Rectangle 2
    Rectangle 3
    Rectangle 4

    Rectangle 1
    Rectangle 2
    Rectangle 3
    Rectangle 4

    With no page break between these rectangles.
  • mtlmonkmtlmonk Member Posts: 48
    Did you get this to work?
Sign In or Register to comment.