Through this blog series, you have been introduced to the new reporting tools and learned a little bit about how to work with fields in a report. At this point, you may want to know how you can leverage the reporting tools to improve your reporting workflows. In ArcGIS 10, you don’t have to start from scratch every time you create a report. You can design a report template, often referred to as a report layout file, that you can use with different datasets.
When you create a report, it’s important to think about how you want to use the report. Is the report part of a repetitive task where analysis results are presented to decision makers? Are you designing a template that should be used for any report created by your department? Let’s examine what you could do if the answer to these questions is yes.
Running Reports Based on Dataset Options
On the first page of the Report Wizard, there is a Dataset Options button that allows you to decide how to filter your input data for the report. The default option is to use all records from the chosen layer. You can also choose to base the report on the selected records of the layer or define a specific query to filter your data. Here is an example workflow:
Create a report, using only the selected set from the layer
Once you’ve finished designing the report layout, save the .rtf (you have to do this in the Report Designer)
Now you can use that.rlf to re-run the report
You can easily run a report at any time interval. If you have a monthly meeting or are creating a map series, you can reuse the .rlf to quickly regenerate a report. However, in the above example, you will always need a selection set to have data in your report. This is great because you can run a model or perform some analysis, at the end of which you are left with a selected set of features, and you’ll be able to use the .rlf to create a report based on your results.
Using a Report Template with Different Datasets
One important feature of report layout files is that they are bound to the dataset that was used to originally create the report. This means you can rerun a report as long as the original dataset is in the map document (it does not need to be in the active data frame). You can also run or load a report if the original dataset is not in the map document. If you try to do this, you will be prompted to pick your dataset. You can choose from any layer or table that is already in the map document, or you can browse to the location of the data you want to use.
If you want to create a new report using a different dataset with an .rlf template, follow these steps:
- Click Load Report from the View menu > Reports pull-right menu
- choose the .rlf template that you want to use
- Select the data that you want to use for your report
- On the Report Source Data dialog box, map the fields in the order you want them to be displayed. Note:You can only map fields to the same type of field. If you don’t want to map a certain field, you can remove the field from the report.
- Click OK, and the report will load in the Report Designer.