Post reply

SSRS Randomly Splitting Last Row onto New Page

  • August 29, 2019 at 8:43 pm

    #3675555

    I have a basic report with a Tablix, 1 Group (2 Group Header, Details (2), 3 Group Footers).

    If I run this report for random Transactions (in my case Purchase Orders), some will print properly ie rows go to the bottom then continue on the next page, followed by the group footers (depending on line notes and text wrapping some print 30 items on page 1, some 24 etc.

    I run the exact same report for another PO and it'll go 17 items, then #18 on second page followed by group footers, another PO will go 23 items then item #24 on page 2 followed by group footers.

    I've checked the data and there is nothing different between rows of data that split and those that do not.  It seems completely random.

    I am at a complete loss as running these types of reports in Crystal from the same data has zero issues.  I have nothing in the properties for page breaks, max records etc.

    Attachments:
    You must be logged in to view attached files.

  • August 30, 2019 at 1:16 am

    #3675591

    It appears that some line items are too large for a single line in the report - and that line grows causing that page to display less line items.

    You can restrict the field by setting the 'Can Grow' property of the text box to false, but that would then cause the additional data to no longer be displayed.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • August 30, 2019 at 1:16 pm

    #3675716

    I've changed the Can Grow on the Description field to false and it still prints the same way.  This one PO (new screenshots) have very short descriptions as well.

    Attachments:
    You must be logged in to view attached files.

  • August 30, 2019 at 2:34 pm

    #3675755

    When I only have 1 footer, all POs print properly.  As soon as I add 3, that's when some POs have their last item split onto page 2.

    If I only have 1 group footer, it prints properly.  If I have 2-3, FOR SOME POs ONLY, it looks like it's trying to keep all 3 group footers plus the last item together but on other POs it doesn't.

    If I have 3 Group Footers, how do I ensure each one "stays together" but not all 3 together ie I don't want Group Footer 1 to split pages but Group Footer 1 can be on Page 1 and Group Footer 2 on the next page.

  • August 30, 2019 at 4:02 pm

    #3675777

    Hallelujah I found the issue.  With Advanced Mode turned on for the groups, I selected each footer and changed "Keep with Group" to None.

Viewing 5 posts - 1 through 4 (of 4 total)

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