Multiple choice technology platforms and products

Which Crystal Reports Page Server setting should you use to prevent users from running on-demand reports containing queries that return excessively large record sets?

  1. SQL_MAX_ROWS

  2. Limit SQL Cursor Fetch Size

  3. Preview Sample Data

  4. Database Records to Read When Previewing or Refreshing a Report

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The 'Database Records to Read When Previewing or Refreshing a Report' setting in Crystal Reports Page Server specifically limits the number of records returned during preview or refresh operations. This prevents users from accidentally running reports that return excessively large datasets, which could impact system performance and resources. The other options listed serve different purposes - SQL_MAX_ROWS is not a standard setting, Limit SQL Cursor Fetch Size affects batch fetching, and Preview Sample Data is a different feature.