Number of rows displayed on a report
The number of rows displayed on a report is limited to 100000, by default. To change the number of rows displayed on a report, you can truncate the report using the XML and then configure the number of rows to be displayed in the report.
This figure displays the default setting:
defaultvalue in Role Violations.xml
Based on your requirement, define this setting as:
| Xml file name and path | [Install path]\ProcessModules\Reports\ReportParameters\SRSAuthorizations Insight for ION Applications - Violations_IONApplication Role Violations.xml |
|---|---|
| Tag |
<parameter>
|
| Node |
<parameter name="TruncateAt" required="false"
displayName="##TruncateAt_DN##" spParamName="@TruncateAt" visible="false"
inSeperateRow="false" defaultvalue="100000" />
|
| Configuration setting | To change the truncation limit, keep the default value as
1 in the Role Violation Details.xml and then
change the default value in this xml to any required numeric value.
|
| Default Value | By default, 100000 rows are populated in a report. |