none
SSRS 2008 Export to Word - Wrong page orientation

    Question

  • SSRS 2088; Office 2007

    I have posted about this issue before but found out some new information. When I export any report (even a new one I have created to test) to Word 2007, the Page Orientation says the report is landscape, which it should be (Interactive and Page size both set to 11 X 8.5). However, when I print, it prints portrait. When I go into the custom margins, the Margin Orientation says portrait. So the page orientation says landscape and the margin orientation says portrait. Any idea on how to fix this? I can change it manually and print, but I don't want to tell 5,000 users they need to change it :).

    Thanks in advance,
    David
    • Edited by DaddyO72 Tuesday, June 16, 2009 11:57 AM
    Tuesday, June 16, 2009 11:56 AM

Answers

  • Thank you for bringing this to our attention.  You are correct that one workaround for now is to change it manually.  I think the XPS print driver would also print as expected.  That said, we plan on releasing a fix for this issue in the RS 2008 Word renderer in an upcoming cumulative update for RS 2008 SP1. It should be available in about a 4-6 week timeframe (i.e. SP1 CU#3).

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by DaddyO72 Monday, June 22, 2009 12:39 PM
    Saturday, June 20, 2009 10:14 PM
  • SP1 CU#3 is now available for download: http://support.microsoft.com/kb/971491
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by DaddyO72 Thursday, August 13, 2009 7:11 PM
    Tuesday, July 21, 2009 3:35 PM
  • You will need to apply SP1 first: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19
    Then try to install SP1 CU#3 again.

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by DaddyO72 Monday, November 02, 2009 9:42 PM
    Thursday, October 29, 2009 9:54 PM
  • Based on your information (above), looks like you need your SSRS 2008 Report Viewer web part that ships with SSRS 2008 Add-in for SharePoint to also be updated with the appropriate CU#3 fix. In order to do so, when you are downloading "SQL_Server_2008_SP1_Cumulative_Update_3" via KB 971491 you need to also select / download filename "SQL_Server_2008_SP1_Cumulative_Update_3_RS_Sharepo". This package should contain the rsSharePoint.msi that includes the updated Reportviewer web part and you need to install it on on your SharePoint WFEs.

    HTH
    Prash
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, December 08, 2009 6:30 PM

All replies

  • Thank you for bringing this to our attention.  You are correct that one workaround for now is to change it manually.  I think the XPS print driver would also print as expected.  That said, we plan on releasing a fix for this issue in the RS 2008 Word renderer in an upcoming cumulative update for RS 2008 SP1. It should be available in about a 4-6 week timeframe (i.e. SP1 CU#3).

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by DaddyO72 Monday, June 22, 2009 12:39 PM
    Saturday, June 20, 2009 10:14 PM
  • SP1 CU#3 is now available for download: http://support.microsoft.com/kb/971491
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by DaddyO72 Thursday, August 13, 2009 7:11 PM
    Tuesday, July 21, 2009 3:35 PM
  • Robert,
     the KB you provided (http://support.microsoft.com/kb/971491 ) is a cumulative update and says that it should not be applied unless issues are present.

    Can you point to a specific KB which addresses Margin/Orientation issue? I don't want to go through the trouble installing something that is not related to my system and was not tested.

    Thanks,
    Ivan

    Thursday, October 15, 2009 4:18 PM
  • Actually, may be you can tell us the roadmap or approx. time frame for SQL Server 2008 SP2 release.
    Thursday, October 15, 2009 4:45 PM
  • Hello jhhhj,

    I verified that the fix was indeed delivered in SP1 CU#3.  The KB article 971491 should have also listed that particular fix as a separate lineitem - however I don't know why it is missing from that list.

    Thanks,
    Robert


    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, October 27, 2009 4:32 PM
  • Thanks for the input. When I try to install CU #3 I get the following error. Any ideas what I need to do?

    The version of SQL Server instance SQLEXPRESS does not match the version expected by the SQL Server update. The installed SQL Server product version is 10.0.1600.22, and the expected SQL Server version is 10.1.2531.0.

    Wednesday, October 28, 2009 12:58 PM
  • You will need to apply SP1 first: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19
    Then try to install SP1 CU#3 again.

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by DaddyO72 Monday, November 02, 2009 9:42 PM
    Thursday, October 29, 2009 9:54 PM
  • Robert,
    we are now exporting the reports through the SharePoint HTML Reporting Services Viewer, and it is reverting back to the same problem with word margin orientation as mentioned above. The report works fine in Word when using the SSRS report viewer. Is this a problem with the SharePoint?
    Thanks,
    David
    Monday, December 07, 2009 1:22 PM
  • Based on your information (above), looks like you need your SSRS 2008 Report Viewer web part that ships with SSRS 2008 Add-in for SharePoint to also be updated with the appropriate CU#3 fix. In order to do so, when you are downloading "SQL_Server_2008_SP1_Cumulative_Update_3" via KB 971491 you need to also select / download filename "SQL_Server_2008_SP1_Cumulative_Update_3_RS_Sharepo". This package should contain the rsSharePoint.msi that includes the updated Reportviewer web part and you need to install it on on your SharePoint WFEs.

    HTH
    Prash
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, December 08, 2009 6:30 PM
  • Robert,

    Back to my second question, do you know when SQL Server 2008 SP2 will be available, at least approx.?

    Thanks,

    Ivan
    Friday, December 18, 2009 6:13 PM
  • No timeframe for SP2 has been announced.  You could monitor the overall SQL Server Release Services blog (http://blogs.msdn.com/sqlreleaseservices/), which will probably among the first to have information when SP2 is being announced.

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, December 22, 2009 11:49 PM
  • So which one should I apply. It says to apply only the part which fixes your problem.
    How am I suppose to know which one fixes my problem?


    <input id="chk389414" type="checkbox" value="on" /> SQL Server 2008 All (Global) x86 sp1 SQL_Server_2008_SP1_Cumulative_Update_3_RS_Sharepo 2008 10.00.2723.00 40307553 7/20/2009 11:35:19 PM
    <input id="chk391490" type="checkbox" value="on" /> SQL Server 2008 All (Global) x86 sp1 SQL_Server_2008_SP1_Cumulative_Update_3_RBClickOnc 2008 10.00.2723.00 122093229 8/10/2009 4:41:05 PM
    <input id="chk398849" type="checkbox" value="on" /> SQL Server 2008 All (Global) x86 sp1 SQL_Server_2008_SP1_CU_Updated_Ref_KB_976761 2008 10.00.2740.00 171574985 11/4/2009 7:05:40 PM
    <input id="chk389411" type="checkbox" value="on" /> SQL Server 2008 All (Global) x86 sp1 SQL_Server_2008_SP1_Cumulative_Update_3_SNAC 2008 10.00.2723.00 3833174 7/20/2009 11:32:06 PM
    <input id="chk389408" type="checkbox" value="on" /> SQL Server 2008 All (Global) x86 sp1 SQL_Server_2008_SP1_Cumulative_Update_3
    Thursday, February 18, 2010 4:35 PM
  • You need to apply this: SQL_Server_2008_SP1_Cumulative_Update_3

    In addition, if your RS server is configured for RS SharePoint mode, you need to apply the following on the SharePoint farm machines: SQL_Server_2008_SP1_Cumulative_Update_3_RS_Sharepo

    HTH,
    Robert


    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Thursday, February 18, 2010 5:04 PM
  • Is this issue also present in SQL2008R2?
    Tuesday, July 05, 2011 9:33 AM