PrxExportData PrxMetaReportExport(string mon, PrxExportDataPattern tArg)
mon. Moniker of opened regular report instance.
tArg. Regular report export options.
The PrxMetaReportExport operation exports regular report to external file.
To execute the operation, in the mon field specify regular report instance moniker, and in the tArg field specify export options.
The moniker can be obtained on executing the OpenPrxMeta operation.
The operation results in the information about obtained file.
Below is the example for regular report export to Microsoft Excel (XLSX) file. The request contains moniker of opened regular report instance and export options. The output file is saved on BI server. The response contains moniker to access the obtained file.
{
"PrxMetaReportExport" :
{
"mon" : "S1!M!S!P1",
"tArg" :
{
"storeResult" : "true",
"format" : "xlsx",
"palette" : "true",
"autoHeight" : "true",
"objectAsBitmap" : "false",
"cellImages" : "true",
"fixEmfLines" : "true",
"showWarnings" : "false",
"reportTitle" : "true",
"sheetTitles" : "true",
"chartsAsImages" : "false",
"emptyPages" : "false",
"breakIntoLayouts" : "true",
"headlines" : "true",
"sheetAccess" : "false",
"flashsAsImages" : "false",
"hiddenSheets" : "false",
"formulas" : "true"
}
}
}
{
"PrxMetaReportExportResult" :
{
"format" : "xlsx",
"storeId" :
{
"id" : "S1!M!S!P1!Bin!0"
}
}
}
public static PrxExportData ExportPrxReport(string moniker)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tExp = new PrxMetaReportExport()
{
tArg = new PrxExportDataPattern()
{
format = "xlsx",
reportTitle = true,
sheetTitles = true,
storeResult = true
},
mon = moniker
};
//Export report
var result = somClient.PrxMetaReportExport(tExp);
return result;
}
See also: