July 5, 2024 at 4:27 pm
Hi all, I have an SSRS report issue is when printing to PDF.
i have a subreport that works fine, but when there is ONLY enough space for the header, it will stay at the bottom then the rest of the subreport continues on the next page.
here is a screenshot of the subreport, mainly showing groupings ( SubReport Image 1 )
If i put the header row within a group lower it will appear more than once, only want it to appear once. I have played around with keeptogether setting, but it doesnt really make any difference. Is there anything else i can try.
Thank you in advance
July 5, 2024 at 8:00 pm
Offhand I am not certain, but is it possible in the parent report (the one that will contain the sub-report) to put a page break before the sub-report?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
July 5, 2024 at 9:53 pm
Thank you for your suggestion. That will certainly cause a huge gap (white space) at times
July 5, 2024 at 10:33 pm
True... Could you have the page break in as an expression that depends on how many rows are in the main report? What I mean is if the main report has less than X rows, don't put in anything, but if it exceeds X rows, then put in the page break?
So, lets assume that X is 10 - if you have 10 rows or less, you want the header and the report to show up on page 1. If you have more than 10 rows, you want to put in a page break? Not sure if "10" is the magic number or not, but a bit of trial and error will help as long as people are ALWAYS exporting to PDF with the same settings (portrait vs landscape, paper size being the same, etc).
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 16, 2024 at 10:02 am
This was removed by the editor as SPAM
August 16, 2024 at 10:03 am
This was removed by the editor as SPAM
August 30, 2024 at 11:01 am
This is driving me mental.
Why is it so hard to keep a subReport Head / Report Title with the report, ie on the same page.
I tried rebuilding, played around with all KeepTogether settings, which i'm convinced dont make any difference.
i have created a report parent group to contain the report header with has the Keeptogether = True, ( No difference )
Why is it so hard.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply