Creating Reports  
Previous  Top  Next

reports  

Description  
 
Generate a new Report.  

document Keys  

LHS    Left Hand Side  
RHS   Right Hand Side  

tableeditor


Table Editor  
reports
 
 
Reports  
new doc


Create New Report  
save
 
 
Save Icon  
 

Method  

LHS column click on Database, Table Editor, Select the file you want to report on. The properties of the file will be displayed. Click on Reports. Click on Create New Report.  

dev_rep_list  

Enter the new report name and click OK.  

dev_rep_newid  

The new report will appear in the list with the other reports. RHS Properties for the report needs to be filled in.  

Some Of the fields are defaulted for reports like Access Verb as SELECT, Report Type as P - Print.  

Report Properties  

dev_rep_propeties  

For a selection of fields available click on the ...  

A Inspector Items box is displayed. Double Click on the field names required and they will moved to the upper box.  

There are options to move and remove all for quick selection.  
 
Once all fields have been selected, click on ok and they will appear in the Properties Field list.  

Inspector Items - (Field List)  

common_field_list_empty common_field_list_full  

SortByList has the same options as the Filed list  

Inspector Items - (Sort By List)  

common_field_list_single  

When finished click on the save button (or Control S)  

To run the report now click on the Execute Item Icon and the Report Wizard screen opens up.  
 
Here you can click on the field and you have the option to Break on the filed. Unclick the tick box's to not display the filed in the report.  

The Report Wizard  

report_fields  

Press return pass the Sorted By and enter the data for the Selection Criteria and click on Finish. You get A Progress box appear.  

report_sortedby  

report_selecting_data  

The 'Send To' options.  

report_what  

Grid Preview Screen  

grid_preview  

With the grid you can manipulate the data by clicking on the down arrow on the field headers  

grid_filter_list
·(All)    To display all the data  
·(Custom...)    Allows you to filter information with a Custom Auto Filter.  
·(Blanks)   To display all the Blank data on the Field.  
·(Non Blanks)   To display all Non Blank data on the Field  
·Data      To display one line of data  
 

 

The Custom Auto filter Screen  

grid_filter_list_custom  

When Satisfied with the report click on the Open With and choose an option  

document Example  

Send to Excel  

grid_export_excel  

The report can be run many times by clicking on the Finish Button. To close the report Click on Cancel, then Click on Yes in Closing Report Wizard...  

report_close