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
> :)

Repeat charts in every page

hi guys,

In reporting services i have a table and below which i have a chart. The table has lot of values so the report spans multiple pages. I have set page breaks such that the table displays only 10 records. After all the values have been displayed in the last page the chart is displayed. I want the chart to display in each and every page of the report. It is the same chart that i want to display. How do i do this?

plz can anyone give me ideas.

Thanks,

Sai Abhiram Bandhakavi

Include a new upper group in the table object and check the property for "Repeat on every page". Place the chart object in the new area. Done.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am not sure what you mean by upper group and placing the chart in that area. Can you be more clear.

Thanks,

Sai Abhiram Bandhakavi

|||

You should add one new row in table and set the property repeatonnewpage as true, And place the chart in this row.

then same chart will repeat on each page.

To do this follow the follwing steps:

1. Right click the first row of the table and insert a row above the selected row,

2. Press shift key and select all cells of new added row, by right click select merge cells.

3. place the chart in this row (by drag or by cut / copy).

4. increase the height of this row. Preview the report.

Repeat charts in every page

hi guys,

In reporting services i have a table and below which i have a chart. The table has lot of values so the report spans multiple pages. I have set page breaks such that the table displays only 10 records. After all the values have been displayed in the last page the chart is displayed. I want the chart to display in each and every page of the report. It is the same chart that i want to display. How do i do this?

plz can anyone give me ideas.

Thanks,

Sai Abhiram Bandhakavi

Include a new upper group in the table object and check the property for "Repeat on every page". Place the chart object in the new area. Done.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am not sure what you mean by upper group and placing the chart in that area. Can you be more clear.

Thanks,

Sai Abhiram Bandhakavi

|||

You should add one new row in table and set the property repeatonnewpage as true, And place the chart in this row.

then same chart will repeat on each page.

To do this follow the follwing steps:

1. Right click the first row of the table and insert a row above the selected row,

2. Press shift key and select all cells of new added row, by right click select merge cells.

3. place the chart in this row (by drag or by cut / copy).

4. increase the height of this row. Preview the report.