PrintRendererServer/RenderReportChangingSlicersAsLiveExcel

Enterprise Edition Only

This WebService method creates an Excel workbook, suitable for those with the FluenceXL Excel Edition. Allows slicer values to be changed before rendering.

Parameters

Parameter	Description
string reportPath	the report to render. Should be given relative to the Repository folder.
int areaToRenderType	specifies whether to render the entire workbook or a single sheet: 0 Workbook 1 Worksheet Specifying ranges is unsupported for Excel workbooks.
string areaToRender	used if areaToRenderType == Worksheet; the name of the worksheet.
string locale	the culture code for the locale that the report should be rendered in (for dates, number formatting, etc.), e.g. en-US.
string[] roleNames	the Analysis Services role names to use to render the report. Note that the user running the report should have access to the roles listed. Use null or an empty array to use the default roles for the user.
string[] parameterNames	a list of web parameter names to pass to the report.
string[] parameterValues	a list of web parameter values, matching parameter names. See Remarks below.
string mustBeTrueParamName	internal use only.
string emailAddressesParamName	internal use only.
Guid[] slicerGuids	a list of slicer guids to modify in the report.
string[][] slicerSelections	a list of selections to set on the slicers listed in slicerGuids.
out string reportName	returns the published name of the report.
out string reportExtension	returns the file extension (typically .xls or .xlsx).
out string[] emailAddresses	internal use only.

Remarks

• From v8.1, the RenderReportChangingSlicersAsLiveExcel2 method is preferred. This method uses all the same parameters except for the parameterValues parameter, which is an object[][]. This supports multiple values to be passed in for the parameter.