sql server reporting services: Page Borders -- sql server reporting services

You're in the

sql server reporting services

group:

Page Borders

Chris Walls
6/9/2006 3:24:49 PM

sql server reporting services:

We're creating a text report (i.e. not tabular, etc.) that will run several
pages. We would like to have a border around each page, including the page
header and page footer. We've set a body border, but that doesn't draw
horizontal lines at the top an bottom of each page.

We've tried putting our controls in a rectange and expanding the rectange to
be encompass a page both vertically and horizontally, but the page header is
excluded from this border (plus we suspect we'll have additional problems if
our individual controls causes a page break). Also, though we have the
rectange control's height set to 9 inches, it shrinks such that it ends
after the last control in the region.

Any suggestions for defining a border on each page, the first page excluded
(it's a cover page)?

We're using MS Reporting Services 2005.

Thanks,
Chris

Re: Page Borders

Eva Pierce Monsen
6/9/2006 4:36:48 PM

Not sure if this does exactly what you're looking for, but in addition
to the body border, have you tried putting horizontal lines in the page
header & page footer?

Eva Pierce Monsen

Re: Page Borders

stcheng NO[at]SPAM online.microsoft.com
6/12/2006 4:53:56 AM

Thanks for Eva's informative inputs,

Hi Chris.

As Eva has mentioned, you can explicitly customize the SSRS report's header
and footer sections in the VS 2005's report designer. Just right click on
the report designer's empty area and you'll find the "Page Header" and
"Page Footer" option in the context menu, select either one to edit the
template.

#Adding a Page Header and Footer to a Report
http://msdn2.microsoft.com/en-us/library/ms159677.aspx

BTW, as for the body's border setting, based on my local test, it also
works (display both horizental and vertical lines). I simply set the border
width and border style (solid) and the runtime report displays both
horizental and vertical border lines for the report body. I think the
problem you met is possibly specific to report body's size.

Hope this helps.

Regards,

Steven Cheng
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Re: Page Borders

Chris Walls
6/12/2006 11:41:46 AM

Steven,

The horizonal body borders appear when we first render the report. However,
when we export the report to PDF, the horizontal lines at the top & bottom
of the body do not appear. Also, the border does not encompass the header
and footer, so even if the horizontal lines did appear, it isn't quite what
we're looking for. The prototype I'm working off of is a MS Word document
that has a page border that does encompass the header & footer.

Any other suggestions?

Thanks,
Chris

[quoted text, click to view]

Re: Page Borders

stcheng NO[at]SPAM online.microsoft.com
6/13/2006 12:00:00 AM

Hi Chris,

Thanks for your response.

Yes, the body border solution has its natural limitation since it does not
include the Header and Footer sections. Have you tried Eva's suggestion on
customizing the UI through the Header and Footer template in the report
designer? As I've also mentioned in the previous message, you can right
click on the report designer's empty area and you'll find the "Page Header"
and "Page Footer" option in the context menu, select either one to edit the
template. Thus, you can put some report item(such as Line ) into the header
or footer section to simulate a border line. How do you think of this?

Regards,

Steven Cheng
Microsoft MSDN Online Support Lead

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Re: Page Borders

stcheng NO[at]SPAM online.microsoft.com
6/15/2006 12:00:00 AM

Hey Chris,

How are you doing on this issue, does the further suggestion help you some?
If there is still anything we can help, please feel free to post here.

Regards,

Steven Cheng
Microsoft MSDN Online Support Lead

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn