Number of rows displayed on a report
By default, the number of rows displayed on the above reports is limited to 10,000. To change the number of rows displayed on a report, you truncate the report using the XML and then configure the number of rows to be displayed on a report.
Report Type.xml-Truncate report to chnage number of dispalyed rows
Configure the XML as :
| XML file name and path | [InstallPath]\ProcessModules\Reports\ReportParameters\ SRSAuthorizations Insight for Oracle E-Business Suite – General.xml |
|---|---|
| Tag | <parameter> |
| Node | <parameter name="TruncateAt" required="false"
displayName="##TruncateAt_DN##" spParamName="@TruncateAt" visible="false"
inSeperateRow="false" defaultvalue="10000" />
|
| Configuration setting | To change the truncation limit, keep the default value of the attribute "ReportType" as 1 and then change the default value of attribute "TruncateAt" to any desired numeric value. |
| Default value | By default, 10000 rows are displayed on a report. |