Your report can include database fields, variables, calculated values, and calculated fields. When you created the report, the form contains the output fields selected. However, if there are too many fields for the width of the report, you may have to add them manually. Also, if you edit the report and add another field, you may have to add it manually as well.
To add a field to the report form manually:
1. Select Report / Report Queries and select the type of report.
2. Select the query used for the report and click Report.
3. Click Run Report.
4. Click Browse Results. Write down the names of the fields in the spreadsheet view. You will need to know the names of the fields if they are not already in the form.
5. Close the spreadsheet view.
6. Click Edit Form.
7. Typically, you’ll add the field to the Detail band area. Resize this band, if needed, to make room for the new field.
8. Select Report / Insert Control / Field.
9. Enter the name of the field to add in the Expression field and click OK.
10. The field is created in the upper left corner of the form. Click on the field and drag to the correct location. You can also resize the field by dragging the lower right corner of the field out or in.
11. Repeat the steps above to add more fields.