A user may want to use URL API to export a prompted report, answering the element prompts first, then exporting to Excel with formatting without showing the export options page in Strategy Web 9.4.1 and above.
In order to select the export option, the following parameters need to be used:
evt = 3067
src=Main.aspx.3067
&group = export
&fastExport = true
&showOptionsPage = false
&defaultRunMode =
In order to get the available export formats for the &defaultRunMode parameter, the following MSDL article shows that the appropriate values can be obtained from the exportFormats.xml.
https://www2.microstrategy.com/producthelp/Current/WebSDK/Content/topics/urlapi/Exporting_a_Report_to_a_Specified_Format.htm This file located at:
C:\Program Files\Strategy\Web ASPx\WEB-INF\xml\config
According to this file, the value for 'Excel with Formatting' is the following:
<export-format name="excelFormattingGridsIServer" desc="Excel with formatting"
The following is the overview of the parameters required:
URL - http://localhost/MicroStrategy/asp/Main.aspx?
Server - &Server=localhost
Project - &Project=Strategy+Tutorial
Port - &Port=0
Export event - &evt=3067
Export source - &src=Main.aspx.3067
Disabled export option page parameters - &group=export&fastExport=true&showOptionsPage=false
Report parameters - &reportID=CBDA975F407261B83843519859786890&reportViewMode=1
Excel with Formatting - &defaultRunMode=excelFormattingGridsIServer
One Element prompt prompt answer - &elementsPromptAnswers=8D679D3711D3E4981000E787EC6DE8A4;8D679D3711D3E4981000E787EC6DE8A4:1
A sample URL would look as follows:
http://localhost/MicroStrategy/asp/Main.aspx?Server=localhost&Project=Strategy+Tutorial&Port=0&evt=3067&src=Main.aspx.3067&group=export&fastExport=true&reportID=CBDA975F407261B83843519859786890&reportViewMode=1&showOptionsPage=false&defaultRunMode=excelFormattingGridsIServer&elementsPromptAnswers=8D679D3711D3E4981000E787EC6DE8A4;8D679D3711D3E4981000E787EC6DE8A4:1
CUSTOMIZATION WARNING:
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. In the event of a code change in future builds, Strategy may not be able to provide additional code on this matter even though this customization is provided at this time for this specific build. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.
