- You have set the page size correctly.
- You have set the .CanGrow property of table fields to false
- You have set ConsumeContainerWhiteSpace at the report to true.
- Margins are correct and still some random page are printed blank, try removing the right margin. Set it to zero. Hope it helps as it helped me!
Month: March 2019
SSRS Matrix – Sum fields in a row group but avoid duplicates
If you want to avoid the duplicates for a row group field for the grand total of a row group. Use builtin MAX or MIN aggregate functions for the field that will be used in the sum function.
Wrong implementation
= SUM(Fields!Amount.Value)
Correct Implementation
= SUM(MAX(Fields!Amount.Value, “NameOfRowGroup”))