Page Comparison

Format Group 

1. The Format options determine the file format output.   HTML format is selected by default. 
   Image RemovedImage Added

2. Click the dropdown drop-down arrow to display alternate file format output options. 
   Image RemovedImage Added

3. Modify the report output format, as desired.
   Image RemovedImage Added

   Tip
   Leaving the format output as HTML during query development makes the process move a lot quicker. This is due to the formatting that has to take place to display the data in other formats. If you need Excel output, it is recommended to leave the format set to HTML and later, after the report is built and query is tested, change the output to Excel to get the desired format.

   
   

4. File is used to create hold files, and Chart can be used to create a chart from the data in the report. 
    Image RemovedImage Added

Design Group 

1. The Design group determines the design mode that displays when building your report.     Live Preview is the design mode selected by default.   Query can be used to increase response time when adding fields to the report.
   Image Modified

2. Select an alternate design mode, as desired.  

   Note
   Query and Live Preview alter your workspace , while selecting Document places you into a different, more advanced mode where you can place many queries, charts, or reports together.

   
   

3. Click to select  Use Sample Data for quicker development as you design your report.    Data from Source is selected by default.  
   Image Modified
4. As desired, modify the Records selection to set the number of lines of data that display as you design your report.   To modify, click the Records dropdown and select an alternate numeric option. 
   Image Modified 

Filter Group 

1. Use the Filter group to create a new filter , by clicking the Filter option. See the article on For more information, see Filtering a Report for more details.
   Image RemovedImage Added

Report Group

1. Use the Report group to enhance the format of the report in several ways.
   Image Modified
2. Explore the Theme and Style options to modify items such as font size, font type, alignment, etc.    
   Image Modified
3. Click Banded to identify a color scheme to apply for banded rows and columns to your output data.  
   Image Modified
4. Click the Header & Footer dropdown to apply Report and/or Page Headers/Footers, as desired.  
   Image RemovedImage Added   
5. Type Enter the desired text in the Header & Footer dialog box. Use the drop-down on the far right to insert preformatted text content ; for example(e.g., the date).
    Image RemovedImage Added   
6. Click the Column Totals dropdown to select an option from the dropdowndrop-down, as desired.  
   Image RemovedImage Added
7. Click Row Totals to show row totals, as desired.  
   Image RemovedImage Added

Related Articles

...