Incorrect page count on reports that use drill-down or have hidden

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott B. - 09 Oct 2006 16:22 GMT

I am getting an incorrect page count on reports that use drill-down or where
report items are hidden. The Globals!TotalPages returns 1 on a report that
clearly has more than one page. On these reports, the Globals!TotalPages
returns the correct page count for the print preview. I get the same results
whether this function is in the header or footer. My goal is to display the
current page and total pages on each page.

If I remove the expression from the Hidden property I get the correct page
count.

I am using SQL 2005 and Reporting Services 2005.

Reply to this Message

Wei Lu [MSFT] - 10 Oct 2006 04:03 GMT

Hello mrScott,

Based on my test, the TotalPages will return correct result in my side when
never I use the hidden report item or drill down report.

Would you please send the report to me so that I can try to reproduce it on
my side? You could create a simple report based on the Sample database in
SQL 2005.

To reach me, please remove the ONLINE in my email address.

Sincerely,

Wei Lu

Microsoft Online Community Support

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

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

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

Reply to this Message

Wei Lu [MSFT] - 17 Oct 2006 10:39 GMT

Hello Scott,

I have tested on my side.

I think that you misunderstood this problem.

The pagecount you see in the preview is page count for the HTML layout.
When you click the Print Layout, since it will re pagenate the report
according to the page setting, you will get another page count.

If you zoom in the print preview in the Print Layout, you could see the
Pagecount in the up-right is 9.

This is the correct behavior.

Sincerely,

Wei Lu
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.

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

Signature

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

Reply to this Message

Wei Lu [MSFT] - 19 Oct 2006 11:29 GMT

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
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.

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

Signature

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

Reply to this Message

Scott B. - 25 Oct 2006 14:22 GMT

Wei Lu,

If I understand you correctly, Globals!TotalPages returns one value for the
HTML layout and can return a different value for the Print Layout? Even
though the InteractiveSize and the PageSize are the same?

Is it possible to display Globals!TotalPages only for the Print Layout? Is
there a property or global variable that indicates whether the report is in
HTML or Print Layout? I don't need to display the page count for the HTML
layout but would like to display it when the report is printed.

Thanks again for you assistance.

> Hi ,
>
[quoted text clipped - 13 lines]
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

Wei Lu [MSFT] - 26 Oct 2006 08:26 GMT

Hello Scott,

When you print the report, the Globals!TotalPages will return the value for
the print layout.

You could ignore it when you get the HTML layout.

Sincerely,

Wei Lu

Microsoft Online Community Support

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

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

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

Reply to this Message

Scott B. - 26 Oct 2006 14:59 GMT

Wei Lu,

You were right in your second response to me, I misunderstood the problem.
The sections "Controlling Report Pagination" and " Understanding Report
Layout and Rendering" in " SQL Server 2005 Books Online" drove it home.

Since I can't get the page count to match in both layouts, ignoring it in
the HTML layout is the solution. I set the InteractiveSize Height to zero so
that the page count will always be one when the report is in the HTML layout
and greater than one in print layout. I can then hide the textbox containing
the page count in the HTML layout and show it in the print layout. If you
have a better idea for ignoring the page count in the HTML layout please let
me know.

Thanks again.

> Hello Scott,
>
[quoted text clipped - 30 lines]
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)

Reply to this Message

Wei Lu [MSFT] - 27 Oct 2006 11:08 GMT

Hello Scott,

For now I think ignorint the page count in the HTML layout is the only
thing you could do.

You could send your feedback to the product team if you have any concern.

http://connect.microsoft.com/sqlserver

Hope this will be helpful.

Sincerely,

Wei Lu
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.

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

Signature

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

Reply to this Message

Wei Lu [MSFT] - 31 Oct 2006 10:51 GMT

Signature

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

Reply to this Message

Wei Lu [MSFT] - 17 Oct 2006 10:39 GMT

Signature

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

Reply to this Message