Repeating Footer on every page when printing

Using RS2005, but the same thing happened on RS2000.
This report has 4 matrices and 4 charts which causes the report to print on
3 pages of 11in by 8.5in paper (landscape). I have a Footer that references a
textbox in the body of the report, but when the report is printed, the footer
only appears on the last page. The textbox that the footer is referring to
has an aggregate expression in it such as First(Fields!REVIEW_MONTH.Value,
"Datasetname"). The Footer has the following expression: "= ReportItems!textbox53.value". I have tried everything including vertically
stretching textbox53 across all of the objects in the body. This almost
worked because the footer did appear on pages 1 & 2, but not page 3.
Can someone please help me. Thanks.
--
-RB
:)FYI - I found the solution by contacting MSN support.
The key is to create a hidden report parameter. In the default values
section, use "From Query" and select the dataset and the field that is
desired to be displayed in the footer. Then just reference the Hidden
parameter within a Textbox of the Page Footer. Now, the Page Footer will
repeat on every page of the report regardless of the number of different data
regions. The report parameter is treated like a Global variable in this
scenario.
--
-RB
:)
"capricorn" wrote:
> Using RS2005, but the same thing happened on RS2000.
> This report has 4 matrices and 4 charts which causes the report to print on
> 3 pages of 11in by 8.5in paper (landscape). I have a Footer that references a
> textbox in the body of the report, but when the report is printed, the footer
> only appears on the last page. The textbox that the footer is referring to
> has an aggregate expression in it such as First(Fields!REVIEW_MONTH.Value,
> "Datasetname"). The Footer has the following expression: "=> ReportItems!textbox53.value". I have tried everything including vertically
> stretching textbox53 across all of the objects in the body. This almost
> worked because the footer did appear on pages 1 & 2, but not page 3.
> Can someone please help me. Thanks.
> --
> -RB
> :)

Rendering to Excel, multiple sheets

I am rendering a report from RS that has multiple tables. After each table I
have it setup to have a page break. This causes each table to be written to
a different sheet within the excel workbook. This is fine. What I would
like to know is if there is a way to write the table name to the excel
workbook tab when the report is rendered instead of having the tabs show
sheet1, sheet2, etc. DOes anyone know how or if this can be done?
Thanks for your help,
sOn Oct 11, 10:24 am, Susan R <Sus...@.discussions.microsoft.com> wrote:
> I am rendering a report from RS that has multiple tables. After each table I
> have it setup to have a page break. This causes each table to be written to
> a different sheet within the excel workbook. This is fine. What I would
> like to know is if there is a way to write the table name to the excel
> workbook tab when the report is rendered instead of having the tabs show
> sheet1, sheet2, etc. DOes anyone know how or if this can be done?
> Thanks for your help,
> s
Several people have asked this same question on these forums w/pretty
much the same response: this is not currently possible in SSRS. Sorry
that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi,
I never tried it my myself, but facing the same problem I found
http://www.spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx
Seems to do the job, but is a little tricky to setup and works only for
excel 2003 and newer.
Simon
"Susan R" wrote:
> I am rendering a report from RS that has multiple tables. After each table I
> have it setup to have a page break. This causes each table to be written to
> a different sheet within the excel workbook. This is fine. What I would
> like to know is if there is a way to write the table name to the excel
> workbook tab when the report is rendered instead of having the tabs show
> sheet1, sheet2, etc. DOes anyone know how or if this can be done?
> Thanks for your help,
> s