Gareth Horton
August 5th, 2002, 04:12 PM
Q: Some fields in one column of my table are blank - Why?
A: Monarch will show in the table only those fields that match the "Type" of the sample selected/highlighted in the report view.
If the data elsewhere in the report does not match the "Type" chosen as the sample, those fields will appear in the table as blank.
For example: If you highlight four numbers as the sample from the report view and elsewhere in the report the field now contains some alpha characters as well as numbers then these fields are likely to come into the table as blank--a numeric field simply does not contain alpha characters.
To correct this:
Change the data "Type" in the table view. Double-click anywhere in the column. This will bring up the "Field Properties" dialog. If the column is now set to "Numeric" try setting it to "Character".
If you still are having problems try using the "Display Source Of Record" function under the “Edit" menu in the table view. Display Source Of Record will take you to the detail level of the record containing your field.
Make sure that the area in the record is not meant to be blank. It might also be that your trap is not working correctly, and again, "Display Source Of Record" may help you discover this.
A: Monarch will show in the table only those fields that match the "Type" of the sample selected/highlighted in the report view.
If the data elsewhere in the report does not match the "Type" chosen as the sample, those fields will appear in the table as blank.
For example: If you highlight four numbers as the sample from the report view and elsewhere in the report the field now contains some alpha characters as well as numbers then these fields are likely to come into the table as blank--a numeric field simply does not contain alpha characters.
To correct this:
Change the data "Type" in the table view. Double-click anywhere in the column. This will bring up the "Field Properties" dialog. If the column is now set to "Numeric" try setting it to "Character".
If you still are having problems try using the "Display Source Of Record" function under the “Edit" menu in the table view. Display Source Of Record will take you to the detail level of the record containing your field.
Make sure that the area in the record is not meant to be blank. It might also be that your trap is not working correctly, and again, "Display Source Of Record" may help you discover this.