After upgrading from 2008 to 2008 R2 Globals!TotalPages shows 0 when exported to pdf
Hi All After upgrading our server from SQL 2008 to SQL 2008 R2 all of our reports have page totals now show the current information in the report viewer but show Page 1 of 0 when exported to PDF or printed. The expressing we're using is in the footer and looks like ="Page " & Globals!PageNumber & " of " & Globals!TotalPages If I re-upload the report to the report server from the RDL this problem goes away. We have hundreds of reports and would rather not upload or change all of our reports. Does anyone have any ideas on what would cause this or how we may be able to correct the issue in bulk? Thanks Jon
January 25th, 2011 4:08pm

Hi Jon, Based on your description, I did a test and reproduced this scenario. So, it is my pleasure to help you reflect it to the proper department. Currently, since this issue might be urgent to your business, I would recommend you contact Microsoft Customer Support Services (CSS) via telephone so that a dedicated Support Professional can assist you in a more efficient manner. Please be advised that contacting phone support will be a charged call. However, it will be free if this is a product issue. To obtain the phone numbers for specific technology request please take a look at the web site listed below. http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS If you are outside the US please see http://support.microsoft.com for regional support phone numbers. We appreciate your understanding. Regards, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 26th, 2011 2:20am

I have contacted support and found no help. They researched the issue, duplicated it and are coming back tell me that it’s broke by design. I'm being told by Microsoft Support that they have changed the functionality of Globals!TotalPages with 2008 R2 and that I need to change all of my reports to use Globals!OverallTotalPages. I was told that it was by design that Microsoft broke the Globals!TotalPages functionality on upgrade of the report server and that in order to fix I need to update all my reports. Re-uploading fixes the issue because it adds in some missing section information that Globals!TotalPages now requires. Since uploading and changing hundreds of files would really take some time, I looked and found this cool utility that let me download and re-upload all of the RDL’s in bulk. http://www.sqldbatips.com/showarticle.asp?ID=62 Thank you Jasper Smith! As a fun side note, the new Globals!OverallTotalPages is shown in the Visual Studio Designer as a built-in field but when you try to use it you get the squiggly line and a message about “Uknown Property Name”. Does this mean the Visual Studio will no longer server as a one stop development environment?
February 3rd, 2011 3:59pm

I've been testing SQL2008R2. From what I can tell, this R2 unit is broke by design: 1) Exporting comma delimited files no longer support the old format by using just 1 report. You have to create 1 report for normal viewing in HTML/PDF, and create a 2nd report with updated properties for viewing as a csv. 2) The reporting service Render command is totally broke being that you can't rely on the streamIDs to get an accurate page count when printing PDFs. NO ONE on the internet has found a solution for this(oh there are suggestions, and they don't work for anyone), making this version useless to me. However you know what I do...I manually set the number of pages to 1000...the application will print each page at least, but I have to catch an error for when it reaches a page that does not exist.(IF anyone knows how to get the page count when printing directly to a printer using the Rendor command, please let me know.) 3) And now I learn I have to change Globals!TotalPages to Globals!OverallTotalPages in all the reports? Unreal. This is the worst I've seen.
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 5:15pm

And BTW, Globals!OverallTotalPages does work you when view the report, but it does not work if you want to print the report to the printer directly(such as when you want like 6 reports to print out by clicking on only 1 button in .NET.) The good thing is R2 fixed some rendering issues. Too bad its still useless to me and I assume countless of others unless the direct printing issue is fixed.
April 14th, 2011 5:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics