The Preview button generates a tabular report based on the SQL displayed and the setting in the Report Properties dialog box. After you click the Preview button you see a Report Generating message in the lower left corner of the SQL page. Long reports may be displayed in multiple windows based on the settings in the Report Option dialog. You can access the different pages of a long report by clicking the Next, Previous, First, and Last buttons. These buttons do not appear for reports that can be displayed all in one window.
Wide reports cause a scroll bar to appear at the bottom of the report window.
This lets you scroll horizontally to view the entire width of the report. The width of each column in the report display is determined by the longest of the column headings and the values displayed in each table for the column. You can keep the report window open and move back to the Designer for SQL window in your Web browser to modify your report, run more reports or chart your data. If you close the window, a new one will be created with any subsequent reports. If you do not close the report window, any new report generated from the Preview button is displayed in that same window.