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: