This tech note explains how to export a Report Services document to Excel with formatting using the URL API. In order to export a document in excel format using the URL API, the executionMode must be set to 4. If excutionMode is not provided in the URL, by default PDF will be used as executionMode.
The following is the list of parameters that the URL must contain in order to execute correctly.
evt=3069
src=Main.aspx.3069
executionMode=4
documentID=7E1644CA424F482DA811569FCE8127FF
Sample URL for .NET environment:
http://WebServerName/MicroStrategy/asp/Main.aspx?evt=3069&src=Main.aspx.3069&executionMode=4&documentID=7E1644CA424F482DA811569FCE8127FF
