SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 ssrs 2008 Globals!RenderFormat.Name=EXCEL
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

321 Posts

Posted - 12/04/2013 :  12:45:17  Show Profile  Reply with Quote
In an existing 2008 r2 report, I have a concern about reports being exported to excel. I have this concern since the result is related to the visibility of tablixes, columns, and rows based upon the export option chosen by the user. When I am exporting the ssrs 2008 r2 from my visual studio 2008 r2 ide in an excel format, the value for
Globals!RenderFormat.Name=EXCEL. However when I export the ssrs 2008 r2 report fronm the test report server in an excel formnat, the value for Globals!RenderFormat.Name=EXCELOPENXML.

Thus I have the following questions which includes the following:
1. Can you tell me why the values between my visual studio ide and the test report server are different?
If so, is there anything I can do to either environmnet to make the values the same? If so, what can I do to make the values the same?
2. I am concerned about deploying the rdl to the production report server. How would I know if the value from Globals!RenderFormat.Name would be either "EXCEL", "EXCELOPENXML", or something you tell me to expect? Is there some option(setting) in ssrs I can set and/or on the report server? If so, what would the option be?
3. If there is no way to tell what would occur on the production report server, should I just deploy the report to production and see what I get? Would I just place a "temporary" textbox on the report server and place the expression =Globals!RenderFormat.Name in that textbox? What do you recommend?

Edited by - jassie on 12/04/2013 12:45:51
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000