ARM Frequently Asked Questions: Reports
A report set identifies one or more ARM reports to print as a group. Reports in the current report set are listed in the Report Set box on the Print Reports dialog. Define a report set by selecting from the list of available reports which reports to include in the report set.
If you wish to print only one report, you must still place that report name into the report set before ARM will print the report.
Report sets and options for reports in the set can be saved on disk for later use. Report sets are saved in the current study definitions directory. You should save a report set if you will print the same report again later, and wish to use the current Global Settings each time the report is printed. Load a saved report set to display reports in the report set list, and to reset options for reports in the set to the option settings that were active when the report set was saved.
A saved report set contains the name of each report, current option settings for each report, and settings on the Global Settings dialog box. When a saved report set contains a user-defined report, the option settings for any imbedded ARM report is also saved with the report set, plus the current page orientation, font size and name, and margin settings.
When saving, ARM prompts for a file description line to save in the report set file. ARM uses this file description to identify files on the File Open dialog. See File Descriptions for details.
Note: When defining a report set to print labels, we recommend that you only include labels reports in that report set. This allows you to load the correct label sheets in your printer before printing labels. ARM does not pause printing to allow changing between paper and label sheets if you include labels with other reports in a single report set.
See Creating an ARM Report Set for a tutorial video, covering the basics of using ARM report sets.
Most reports include options that control what information appears on the report. Some reports include a setting to define which data entry fields, such as treatment columns, appear on the report. Treatment fields are the typical fields that are "missing" on a printed report. For example, the Treatments report includes an option to display or hide treatment fields.
- Select File, then Print Reports from the ARM menu bar.
- Next, click on the Treatments name in the Available Reports window.
- When the report name is selected, click the right mouse button and choose Report Options, or click the Edit Report Options button at lower right corner of the Print Reports dialog.
- Click the Treatment Fields button.
- Put a check mark in the Visible column for each treatment field to print on the report.
- Select the OK button to save the settings and return to the Treatment report options window.
- Select the OK button to exit this window and save changes.
Print ARM reports directly to a word processor or spreadsheet program by first selecting one or more available reports in the Print Reports dialog (select File, then Print Reports). Select the "Next" button on Print Reports dialog to display the Print dialog.
A. Word processor:
On the Print dialog, select “Print to Word” button to create a .rtf (rich text format) document in the Print directory defined in File options. ARM then opens that document in the associated word processor program (typically Microsoft® Word) so you may view the report. The “Print to Word” button is disabled if there is not a Windows file association for RTF files.
When the report Global Settings is set to print borders, then bordered tables in ARM reports are printed as bordered tables in the rich text document. With this technique, the report appearance in the word processor document is very similar to the report appearance when printed on paper from ARM. Clear the report Global Setting to print borders if ARM report tables should be printed to .RTF files as tab separated columns.
B. Microsoft® Excel spreadsheet:
On the Print dialog, select the Excel tab options, and select the desired print formatting of All, Quick, or None, and then select the Print to Excel button. ARM then opens Excel and directly builds one worksheet for each report in the report set. A new workbook is created if Excel is not open; otherwise ARM prompts to add the ARM report to a workbook that is currently open.
The formatting choice All includes all ARM formatting, including borders and font colors. It can be fairly slow to create an ARM report in Excel with All formatting, so Quick (merge cells) is the default option.
Please note that ARM does not save the Excel workbook, so you need to save the report from Excel.
Use the Global Report Settings - Border tab to control the spacing between tabular columns on reports, and determine whether borders are printed around report sections. To view Global report settings, select File, then Print Reports from the ARM menu bar. Next click the Global Report Settings button located directly below the Report Set window, and select the Global - Borders tab.
Selecting the Print Borders option allow boxes and lines to be drawn around various report sections. There are two customizable line widths: Primary and Secondary.
- Primary Lines are used to divide major sections.
- Secondary Lines are used to divide sub-sections within major sections.
When the borders option is disabled, the vertical spacing options are used to separate columns in columnar information, such as treatment fields and assessment data columns.
Please refer to ARM help by pressing the Help button on the Global Report Settings dialog for details in using these options.
What are the Rate/Rate Unit and Other Rate/Other Rate Unit fields in the ARM Treatment editor used for?
The ARM Rate/Unit treatment fields are also known as “standard” rate/unit fields. These two fields must be filled in before ARM can print a Spray/Seeding Plan report. Other key treatment fields that influence calculations on a spray/seeding plan report are the Form Conc and Form Type fields. The Other Rate/Unit fields are not required to produce either report.
The Other Rate/Unit treatment fields are also known as “alternative” rate/unit fields. These two fields were introduced in standard study definitions in ARM 6. Special programming is included to calculate the Other (alternative) Rate when the Rate (standard), Unit, and Other Rate Unit fields contain an entry. The Plot Signs report also includes an option to print signs with the Other Rate/Unit information, in case these contain product rates that are more useful to print on plot signs for a field tour.
The following shows an ARM treatment editor from an example study.
This example study illustrates how a researcher may enter Rates (standard) based on metric treatment units but also express the Other Rates in US treatment units. The rate units used by ARM (US or Metric) are determined by the setting on the Treatment tab of the Settings window (Window, Settings, Treatment).
The first treatment entered in the example study illustrates a treatment entered with the “standard” Rate/Unit as 3.5 KG A /HA. The “alternative” Other Rate Unit is defined as PT/A (US). ARM calculates the 6 Other Rate shown in the example study after the following have been entered:
- Form Conc
- Conc Unit
- Form Type
- Rate Unit
- Other Rate Unit
Press the F5 user help key in the treatment editor fields above to obtain more information on Rate/Unit and Other Rate/Unit treatment fields.
ARM can calculate a product amount for an unknown formulation if the rate unit does not reference active ingredient. For example, for a rate of 1 liter product per hectare, ARM only needs to know that the product is a liquid formulation in order to calculate the product amount on a spray/seeding plan report.
Another example is if the formulation is 3800 PPM, then the formulation concentration is 0.38% (10000 PPM is 1%). ARM can use a percentage formulation if the formulation concentration unit field is visible, and a formulation concentration unit that begins with % is entered. The density field must also be available, and if density of the active ingredient is not known a density estimate of 1 is used.
If the formulation concentration unit and density fields are not visible in the treatment editor for a particular study, select Window, Settings to display the Settings window. Next, select the Treatment tab, and then scroll the list of treatment fields (columns) to see defined field lengths and the Visible setting for each treatment field. Use this window to select which treatment fields are visible in the editor and also select the field length from a defined range. Any length set to zero "0" hides the field even if a check mark is present in the "Visible" checkbox.
Tip: Define Report Sets for frequently printed reports to store report settings.
Tip: Insert a report between two reports already defined in a report set by first selecting the report name in the Available Reports window. Next, move the cursor to the Report Set window and select the report below where you want to insert. Press the Insert key on the keyboard.