Prev: How do I exclude data using the IIF statement in report builder
Next: Removing empty cells in column groups
From: Michael on 14 Dec 2009 07:26 Hi! My colleague Andy and I are trying to create a proper report cover page? (use as title) We're using Report Builder 2 and SQL Server 2008 with Advanced Services Express Version, and having real trouble creating a report cover page. We're not sure why. I can create a lovely looking cover page and added my tablix report under it (with 'page break before' selected on the tablix). However this produces when printed, dependent on the number or columns in the report, multiple blank pages between the cover page and the tablix report. I have a feeling it might be due to the big canvas the whole report is in. Is there a why to stop the blank pages from being rendered? Anyone have any thoughts? I know from experience for example in Crystal Reports there is an object called a 'Report Header', that prints only once per report. This you can form to therefore be a cover page. I would have hoped this would have been as easy to do in Report Builder but apparently not? Anyone have any thoughts? Many thanks for any help.
From: Scho on 17 Dec 2009 04:33
Have you tried placing a rectangle in the report after your header page and making it add a page break after this? If that causes issues, place all the header information into the rectangle to effectively group it and see if that works. HTH, Scho |