Verifying the data returned by a data set
After creating a data set, always use Preview Results to verify that the data set returns the expected data. Figure 2‑4 shows an example of a result set returned by a JDBC data set. By default, Preview Results shows up to 500 data rows. If you expect the data set to return more than 500 data rows and you want to see all the rows, increase the number of rows that Preview Results displays. Doing so, however, can increase the amount of time it takes to display the results.
Figure 2‑4 Previewing the results of a data set
How to change the number of rows that appear in Preview Results
1 Choose WindowPreferences.
2 In Preferences, click the plus sign (+) beside Report Design to expand the item.
3 Choose Data Set Editor.
4 In Number of rows to display, type the maximum number of rows to display, then choose OK.