In the Report designer you can change between designing the report and also an example of what the report looks like with data from a Worksheet file. This helps you see how your report will look when applied in Worksheet.
Report designer
There are two view tabs in the Report Designer work area.
Use the Design View to design your report. From here you can add fields and sections, filter or sort data, and add group headers and footers containing subtotals.
Use the Report View to see how the report looks with data extracted from the worksheet. From here you can print or export a report.
Advanced report designer
In the advanced report designer you will open on the design mode of the report. To view what the report looks like with data select the Preview toolbar at the top of the window.
A File Explorer window will open, navigate to and select a Worksheet file and click Open.
The Preview tab will show you the report. All other tabs revert you back to the Designer.