Apply Row Limits

In Reports V2 Sprinkle offers functionality to Apply Row Limits.

There are different limits for the reports, which are explained below

Row Limit

The main aim of the Row Limit is to give users control over the number of records fetched. There are times when you would want to quickly see a few records and not the complete records. In such cases, the Row Limit feature comes in handy.

Row limit is the limit applied at the run time of the report. It is added to the query generated for the report. The row limit can be any positive value less than the Save limit.

You can add a Row Limit by following the below steps:

• Open the Row Limit section in the Build panel.

• Click on the Text box in this section and enter the limit.

• Click on the Check button and run the report.

Save Limit

Save limit is the limit of the number of records that are saved on the storage, which can be downloaded from the report. The default Save limit is set to 5 million.

You can configure the Save limit from report-tab level settings available in more options. This limit can be configured to any value between 5000 to 50 million.

Column Limit

Column limit is the limit of the number of columns visible on the Sprinkle UI for the report. The default Column limit is set to 50.

You can configure the Column limit from the menu in the Report output pane. This limit can be configured to any value between 1 to 100.

UI Fetch Limit

UI Fetch limit is the limit of the number of rows visible on the Sprinkle UI for the report. The UI Fetch limit is set to 5000 and is not configurable for better performance.

If the report which you have created has less than 5000 rows, you will see the complete report If no Row Limits are applied. If the report has more than 5000 rows, you can Download the saved report to see all the rows.

➡️With these limits in place, Sprinkle provides you with messages in order to guide you through and provide you with contextual options to enhance your reporting experience.