Showing posts with label rs2000. Show all posts
Showing posts with label rs2000. Show all posts

Tuesday, March 20, 2012

Repeating table headers overwriting data

I'm using RS2000 SP2 and am getting an issue when exporting to PDF. If I have a table that spans more than one page and I set the RepeatHeaderOnNewPage to True, then on occasion the table header will be displayed on top of the first few rows of data. It does not happen on all the pages or all the time and I can not find any information on this issue. Has anyone come across this before and solved it?

Hi,

Did you ever solve this problem? The same things is happening to me and I can't figure it out....

Barbara|||

Hi Barbara,

Unfortunately I was never able to solve this issue using RS 2000. In the end I turned off the repeating headers. I came to the conclusion that it was a bug in Microsofts PDF rendering engine.

I did run the same report using RS 2005 and it worked fine, but I'm not sure that will be of any help to you.

Regards,

Jeff.

Repeating table headers overwriting data

I'm using RS2000 SP2 and am getting an issue when exporting to PDF. If I have a table that spans more than one page and I set the RepeatHeaderOnNewPage to True, then on occasion the table header will be displayed on top of the first few rows of data. It does not happen on all the pages or all the time and I can not find any information on this issue. Has anyone come across this before and solved it?

Hi,

Did you ever solve this problem? The same things is happening to me and I can't figure it out....

Barbara|||

Hi Barbara,

Unfortunately I was never able to solve this issue using RS 2000. In the end I turned off the repeating headers. I came to the conclusion that it was a bug in Microsofts PDF rendering engine.

I did run the same report using RS 2005 and it worked fine, but I'm not sure that will be of any help to you.

Regards,

Jeff.

Monday, March 12, 2012

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