How to create a cover page
This seems like it should be a very simple task. I need to create a cover page that appearsas the first page of all my reports. It contains a confidentiality statement and I don't want anyother report information on this page. I created the cover page in a separate report to be used as a subreport in anyreport that needs the statement included. However, I have searched all over the Web (including this forum) but cannot find any info on how to actually create a cover page. Is this even possible with RS? Thanks, Jesse
May 15th, 2006 4:14pm

You can just create a report with no datasets, just static textboxes for the confidentiality text, and use it as the subreport. Are there any other specific things you are looking for?
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2006 10:04pm

Well, yes. I planned on using it as a subreport. Its just a matter of how to place the subreport on the other reports. Won't the subreport appear on all the other pages of the report. I guess my actual question is how do I make content appear on first page only and have nothing else on the first page (in effect, a cover page)?
May 16th, 2006 9:38am

You can put the sub-report outside any list,table or matrix - controls at top of the content-pane (maybe the name is "textcontent" in en-version), so it just shows at the beginning of the report. setting "page break at end" for the subreport will take care that only your sub-report cover-page is on the first page..
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2006 9:43am

Yep, that did the trick. Thanks. Jesse
May 16th, 2006 9:49am

Hi all, Can i create a three fixed pages(like cover sheet)? Many thanks, Sunny
Free Windows Admin Tool Kit Click here and download it now
October 8th, 2008 10:06pm

For anyone who has banged their head against the wall trying to get this to work with columns: Create report.Create "cover page" subreport that matches the printable area of the master report (you might want to make the vertical a little bit shorter so you don't inadvertently use more than a page of the master report)Put subreport in the body, right above all other charts/tables/matrices.Set columnspacing property in body to 0 (if you need spacing, leave blank space manuallyVoila, everything will work. Another cool trick you can do if you want to reuse a template for multiple reports (not recreate a new subreport every time) is to set the text for the cover page as parameters in the master report, and create parameters in the subreport to populate text boxes (e.g. title, description). Multi-line textboxes can be achieved by coding them conditionally based on the value of the report title parameter. Hope this helps someone else. This is for SSRS 2005
August 8th, 2012 12:24am

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

Other recent topics Other recent topics