View source for PrintRendererServer/RenderReportChangingSlicersAsStaticExcel

{{EnterpriseOnly}}

This WebService method creates an Excel workbook with all FluenceXL functionality removed, suitable for viewing by users without the FluenceXL Excel Edition. Allows slicer values to be changed before rendering.

==Parameters==
{| class="wikitable"
! Parameter
! Description
|-
| {{Code|string reportPath}}
| the report to render. Should be given relative to the Repository folder.
|-
| {{Code|int areaToRenderType}}
| specifies whether to render the entire workbook or a single sheet:
{|
| 0 || Workbook
|-
| 1 || Worksheet
|}
Specifying ranges is unsupported for Excel workbooks.
|-
| {{Code|string areaToRender}}
| used if areaToRenderType == Worksheet; the name of the worksheet.
|-
| {{Code|string locale}}
| the culture code for the locale that the report should be rendered in (for dates, number formatting, etc.), e.g. en-US.
|-
| {{Code|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.
|-
| {{Code|string[] parameterNames}}
| a list of web parameter names to pass to the report.
|-
| {{Code|string[] parameterValues}}
| a list of web parameter values, matching parameter names. See [[#Remarks|Remarks]] below.
|-
| {{Code|string mustBeTrueParamName}}
| internal use only.
|-
| {{Code|string emailAddressesParamName}}
| internal use only.
|-
| {{Code|Guid[] slicerGuids}}
| a list of slicer guids to modify in the report.
|-
| {{Code|string[][] slicerSelections}}
| a list of selections to set on the slicers listed in slicerGuids.
|-
| {{Code|out string reportName}}
| returns the published name of the report.
|-
| {{Code|out string reportExtension}}
| returns the file extension (typically .xls or .xlsx).
|-
| {{Code|out string[] emailAddresses}}
| internal use only.
|}

==Remarks==
* From v8.1, the {{Code|RenderReportChangingSlicersAsStaticExcel2}} method is preferred. This method uses all the same parameters except for the {{Code|parameterValues}} parameter, which is an {{Code|object[][]}}. This supports multiple values to be passed in for the parameter.

[[Category:Development]]