Inserting Database (DB) Fields

In order to start a report, you have to place specific fields and tables into the Working Set. You can insert these fields by clicking on Insert/DB Fields.  To insert DB fields from the Catalog Browser, click here.



There are three tabs in the Insert DB Field. 

• The first tab is DBFields.  This contains the tables and fields you selected in the Data tab and placed in the Working Set.  You will notice that some of the field icons have overlapping red arrows.  This indicates that these fields are active and being used in your report.  To insert a new field, select any field and click on the Insert button.
  
  
• The second tab is Formulas.  For more explanation on what a formula is click here.  
  • To insert a formula, select any formula that is available and click on the Insert button. 
  • To edit the formula, select the formula and click on Modify.  The Formula Editor window will appear.  Click here for more explanation on the Formula Editor. 
  • To create a new formula, click on the New button.   A menu will prompt you to key in a name.  Click OK button to take you to the Formula Editor.
    
    
• The third tab is the Parameters.  For more information on what a parameter is click here.
  • To insert a parameter, select a parameter from the directory and click on the Insert button.
  • To edit the parameter, select the desired parameter and click the Modify button.
  • To create a new parameter, click on the New button.