Strategy ONE
Exporting a Report to a Specified Format Using the URL API
The table below shows the URL parameters used to export a report to a specified format using the URL API.
| Argument | Description |
|---|---|
|
evt |
3067 - fastExport Allows users to export reports in a specified format (Excel with plain text, Excel formatted, CSV, HTML, or plain text) |
|
src |
The page component that should handle the action and the event |
|
reportID |
Specifies the GUID of the report to export as HTML |
|
group |
Specifies the preferences group to display if the Export Options page is to be displayed. Must always be “export”. |
|
fastExport |
Specifies that the report has not been ran before exporting. Must always be “true”. |
|
showOptionsPage |
Specifies whether or not to display the Options page |
|
defaultRunMode |
Specifies the export format (The appropriate value can be obtained from exportFormats.xml.) |
|
execFlags* |
Flags to be used while executing a report |
|
messageID* |
Specifies the ID of an in-memory report. If present, the report is fetched from memory rather than executed |
* optional parameters
The sample URL shown below illustrates how to export the "Electronics Revenue vs. Forecast" report, which is part of the MicroStrategy Tutorial project, as HTML.
By setting theshowOptionsPage parameter to "false", you prevent the Options page— on which you normally specify the export format— from being displayed. The value of thedefaultRunMode parameter (which can be gotten from exportFormats.xml) determines the format to which the report is exported.
J2EE environment:
http://webserver/MicroStrategy/servlet/mstrWeb?
Server=localhost
&Project=MicroStrategy+Tutorial
&Port=0
&uid=Administrator
&pwd=
&src=mstrWeb.3067
&evt=3067
&group=export
&fastExport=true
&reportViewMode=1
&reportID=EB3CD5D14F4C8C77782AC0882C986B8D
&showOptionsPage=false
&defaultRunMode=htmlGrids
.NET environment:
http://webserver/MicroStrategy/asp/Main.aspx?
Server=localhost
&Project=MicroStrategy+Tutorial
&Port=0
&uid=Administrator
&pwd=
&src=Main.aspx.3067
&evt=3067
&group=export
&fastExport=true
&reportViewMode=1
&reportID=EB3CD5D14F4C8C77782AC0882C986B8D
&showOptionsPage=false
&defaultRunMode=htmlGrids
See also:
