Why Don't I See the Number of Resultant Columns or Rows I Expect In My Report?
This documentation is for the legacy Izenda 6 product. Documentation for the new Izenda 7 product can be found at https://www.izenda.com/docs/
Table of Contents
Settings that affect row results:
- AdHocSettings.ChartLimit (default: 500) limits the number of rows which can be used in charts.
- AdHocSettings.PivotFieldLimit (default: 100) limits the number of columns in pivot.
- AdHocSettings.PreviewColumnLimit (default: 100) limits the number of columns for report at all (has no effect for export)
The number of rows not limited by settings, but it can depend on some things:
- Results can be limited for the whole report within the ReportDesigner (Fields tab; "Records" field).
- Results can be limited in ReportDesigner preview tab (by "Results" dropdown in menu)
(
AdHocSettings.DefaultPreviewResultsdefault is 100 for 6.6 and 1000 for lower versions) - Results can be limited in ReportViewer (by "Results" dropdown in Viewer toolbar)
(
AdHocSettings.ReportViewerDefaultPreviewResultsdefault is 100 for 6.6 and 1000 for lower versions)
First in your search you should check the values at the "Results" dropdown in your ReportDesigner/ReportViewer.