SSRS - create a report that is not dynamic in size
I want to create a report that is completely static in size and shape. I am trying to emulate a hand-posted report that someone in my organization has been building from the word doc for years.
The critical part seems to be capturing the number of rows created in the various table grids that populate the page. I would like them to always contain a given number of lines, whether the data is present or not. It would seem that if I can just fix the size of my tables, then all other items won't be forced to move due to the stretching of the repeater partitions.
All my lattices are supported by stored procedures, so I am also open to SQL tricks.
a source to share
Sorry I missed this question.
If you know how many rows you need to return (say 20), perhaps you could add some dummy information to your records returned from the stored procedure. You might be able to count the records your query returned before sending them back, and if you have less than 20 add some dummy items to the recordset, put something like "NonDisp" or something in them.
Then in the report, put the iif statement in cells that validate this dummy information, if found, change the cell to display nothing, otherwise display valid values
a source to share
Add parent group to tablix with expression = Ceiling ((RowNumber (Nothing)) / 10000). (10000 or any other number of lines)
In the group page break properties, check the box to break between groups, leave the bottom margins unchecked.
Optionally, we can select true for the hidden property for text fields added due to the new parent group.
In the properties of the tablix, check the "Keep together on one page" checkbox.
a source to share