title: SSRS 2008 R2 Globals!RenderFormat.Name=EXCELOPENXML
body: <p>In an existing 2008R2 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.</p>
  
  <p>When I am exporting the SSRS 2008R2 from my visual studio 2008R2 IDE in an Excel format, the value for <code>Globals!RenderFormat.Name</code> = <strong>EXCEL</strong>. However when I export the SSRS 2008R2 report from the test report server in an Excel format, the value for <code>Globals!RenderFormat.Name</code> = <strong>EXCELOPENXML</strong>. </p>
  
  <p>Thus I have the following questions which includes the following:</p>
  
  <ol>
  <li>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?</li>
  <li>I am concerned about deploying the RDL to the production report server. How would I know if the value from <code>Globals!RenderFormat.Name</code> 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?</li>
  <li>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 <code>=Globals!RenderFormat.Name</code> in that textbox? What do you recommend?</li>
  </ol>