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 Removed

   Image Added

3. Modify the report output format, as desired.


Image Removedtip

4. 1. 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 the query is tested, change the output to Excel to get the desired format.

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

 

6.   

 Image Removed
7. Image 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 Removed

2. Select an alternate design mode, as desired.  

   Note

   1. 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 RemovedImage Added

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 Removed Image Added

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 Removed

2. Explore the Theme and Style options to modify items such as font size, font type, alignment, etc. 

     

   Image RemovedImage Added

3. Click Banded to identify a color scheme to apply for banded rows and columns to your output data.  

   Image Removed

4. Click the Header & Footer dropdown to apply Report and/or Page Headers/Footers, as desired.  

   Image Removed   
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 Removed   Image Added

6. Click the Column Totals dropdown to select an option from the

   dropdown

   drop-down, as desired.  

   
   Image Removed

7. Click Row Totals to show row totals, as desired.  

   Image Removed

Related Articles

...

...

...

...