Groups | Blog | Home
all groups > sql server reporting services > february 2005 >

sql server reporting services : SQL Reporting Service(Page Header and Footer)


Amol
2/14/2005 10:31:02 PM
Hi,
I want to add page header and footer in the report, which will have text
boxes pointing to fileds in the database. Also, there will be only 19 lines
in detail section per page. How do I do it?

Jeff A. Stucker
2/15/2005 12:13:04 PM
You could simulate page headers and footers by using a combination of page
breaks and table groups, and the page headers and footers would actually be
group headers and footers.

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
[quoted text, click to view]

Amol
2/15/2005 9:27:02 PM
Thanks for your reply. I have done the same as you suggested. I have added a
page break after 19 lines in a detail section. But group footer is not
getting printed. Group footer will be printed only when all records in the
detail section are printed.
I want the group header and footer to appear on each page irrespective of
number of records in the detail section.
Thanks again for your feedback.

[quoted text, click to view]
Jeff A. Stucker
2/16/2005 2:35:16 PM
I've not done this before, but I imagine you could create a group for every
19 rows using a calculation, and have the page break as part of the group
header or footer. You could also show/hide the page break based on whether
it's the first or last, depending on whether it's a before or after break.

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
[quoted text, click to view]

AddThis Social Bookmark Button