Anatomy of the Report to Grid Window

Some pre-defined reports — generally those that will result in a file to be submitted to a government entity — have the Report to Grid feature that generates a grid that you can use to review and edit the data before creating the export file.

Once you click the Report to Grid or Continue with Previous Editing button, the report data grid opens.

This topic describes report properties, the window's commands, validation errors, display settings, highlighted changes, and the mass update feature.

Report properties

The information at the top tells you when the report was generated and who did it. It also includes the parameters used to generate the report.

Commands in the Report to Grid window

Return to the top

Validation errors

The grid opens with a Validation Errors column in the far left position. If there are errors, you will need to resolve them before generating the export.

You can make sure you see all the validation errors by clicking on the Validation Error(s) column to sort it.

 

Display additional columns & aggregate data

The grid may include columns that aren't displayed by default. You may display them using the Table Display Settings dialog. You can also aggregate data in columns — for example, choosing to display a sum at the bottom of a numerical column.

Return to the top

Highlighted changes

Any fields that have been edited through the Edit Record popup will be highlighted with yellow in the grid for easy viewing.

 

Mass update feature

Use the Mass Update feature to edit multiple records that all require the same change.

  1. Check the boxes for multiple rows, and click the Mass Update button. The Mass Update Record popup opens. Note: The fields available for mass update will vary depending on the report.

  2. Edit the fields as needed, and click Save. The Result window opens displaying & explaining successes & failures.

  3. Click Close when you're done reviewing records. The results of the edits will be highlighted in yellow.

 

Return to the top

Return to Reports Overview