SSRS: Multiple detail lines generates blank page

ssi
Member Posts: 39
A report I created consists of 1 detail group with many detail lines. It reads records from a temp table, populated in code in previous dataitem. For each record, each detail line is dynamically hidden or printed. If the report gets to the bottom of a page in the middle of the detail lines, a blank page with just the header is printed before continuing on with the detail lines on the subsequent page. I have already set the KeepTogether property to true on the group and all Tablix members. The KeepWithGroup property is set to None as there is only one group. Any idea on how to prevent the blank page? Partial snap of RDL is attached.
0
Comments
-
You should check the flat table that the report is generating to see if it gives you blank lines so that you could see a pattern to correct it.
If you don't know how:
Run the report, on the request page press the blue down arrow on top, Help, and About this page.
Run the report on preview.
Then again press the blue down arrow on top, Help, and About this report.
If it helps you can send this flat table o excel to help you out.0 -
Thanks for the suggestion, Tony. I looked at About this Report. There are no blank lines, just the lines I expect to see. ](*,)0
-
I see from the picture that you use no group, could it be that?
Also can recomend you to "paint" the cells in the body with diferent colors so you can check by "visual debug" if something in particular might be causing you problems.
You only need to paint in the first column it will be enough.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions