The Mysterious Disappearing Body
I have a report that prints just fine until I add a placeholder expression to the header. For example, I create a text box to display the date selected by the user using the date parameter. As soon as I do the body of the report disappears
when printing (or print preview). The header is there in all of it's glory but the body is gone. As soon as I remove the text box from the header containing the expression the body returns.
This is ONLY when printing. The report runs fine in Design or Production. But the complete requirements require printing.
Any thoughts on this?
Thank you!
July 13th, 2011 12:11am
Hi HygginsSQL,
According your description, you would like to add a Textbox to report header, then use it to show the Date Parameter
selected by User. But the result is that after you adding report header to you report your report body is missing. I suspect one reason maybe that the rest space in your report is not fit for your report data, which force your report body leaving away.
I suggest you add a customize
Page break to your tablix to limit the data count showing on each page.
How to set the customize
Page break, Please refer to the steps below:
1.
Right-click the Details Row, select
Add Group->Parent Group.
Set Group by =Ceiling((RowNumber(Nothing)) / <count size>),
then Click ok.(count size to limit the data count showing on each page).
2.
Right-click the new added group in Row Groups panel, choose
Group Properties.
3.
Select
Sorting item and delete all the sorting rules in the sorting options.
4.
Select
Page Break, check Between each instance of a group option.
5.
Click Ok.
After you complete all steps above, Please click the
print setup to have a print preview trial.
For more information about How to add a Page Break (Reporting Services), please refer to the article below:
How to: Add a Page Break (Reporting Services)http://support.microsoft.com/kb/938943
I hope this can help you, if you have anything unclear, please feel free to let me know.
Thanks,
Bill Lu
Free Windows Admin Tool Kit Click here and download it now
July 15th, 2011 1:30am