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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics