Running Reports or Exporting Reports to CSVand Other Formats from Different Containers
The procedure for running a report, exporting a report to a raw, unformatted CSV file, or exporting to other formats is the same, no matter what container the report is in. The Report Details view provides a breadcrumb trail to make it easy to navigate back through report categories and containers.
Click Export to CSV. For more information, see
Setting CSV File Export Options .
Provide a name and location for the file, and click
Save.
Click
Yes to open the file or click
No to return to your report.
Click Export to... For more information, see
Exporting a Report to Other Formats .
Select a format for the resulting file.
Click
Export Options, set the appropriate options, and click
OK.
Provide a name and location for the file, and click
Save.
Entering Parameter Values
When you run a report, parameter cards are used to filter the data and make your reports more meaningful. These parameter cards are added by the report author, who can be identified on the General tab of the Report Properties. For more information, see Types of Parameters . All parameters must have a green check mark icon beside them, satisfying the parameter requirements, before you can view the report.
Some parameters are required; you must enter values in these in order to run the report. The parameter type is indicated in the top right corner of the parameter card. Required parameters that you have not yet filled in are indicated by a red X icon. Once you have entered an acceptable value, a green check mark is displayed.
The action you take to enter a parameter value depends on both the type of operator and the type of field you are working with. For example, a field that contains numbers, combined with the Between operator, requires you to enter two values, one higher than the other. A field that contains a date and the Not in the last operator requires you to either type in or use the spin control to enter a number of days.
You can import parameter values from a file with one entry per line. You can merge the imported values with existing values or over-write the existing values. For more information, see Importing Parameter Values .
You can also save your favorite parameter values in the System | Configuration tab with the Report Parameter Favorites option. When running or scheduling reports, you can then load the favorite parameter values you have configured.
You can choose whether to enter values in an optional parameter. Optional parameters have a green check mark icon regardless of whether a value is provided.
Once you have entered parameter values, they can be edited, deleted, or sorted. The height of the parameter window can also be expanded to make it easier to view and manage parameter values.
Searching for Parameter Values
In order to properly define your report, you must choose the values to include in your report. Enterprise Reporter helps with this task by providing a list of currently available values, based on the data that has been collected in your environment. By selecting from a list instead of typing in a value, you can be sure that data exists, and that you have entered the value correctly.
Because there can be large amounts of collected data available, you can search the collected database for the parameter value for any string field. You can enter search phrase, or use the * wildcard character to help narrow down the results. Only the first 500 results are returned; in this case, you need to provide a more refined search term.
When searching for parameter values, parameters will contain the option to display search results filtered by previous parameters when possible. For example, if you have already selected a domain for a report, then subsequent parameters will have the option to display only the results from that domain.
When a parameter is specific to selecting groups or users to be included in the report, when possible, the search results page will contain the option to Show only Groups or to Show only Users. Selecting either option will filter out all other objects thus making specific Groups or Users easier to find.
If you have used the Filtered Search icon, the search results will be filtered based on the contents of previous parameters.
Importing Parameter Values
You can create a text file of parameter values that you can later import into reports when running them. This option can be especially helpful when there are many parameter values to select every time you run a report or when there is a specific group of parameter values that is the same for every report you run.
The plain text file must have a file extension of .TXT and each parameter value must be on a separate line within the file. The following examples outline how you can import account names, computer names, and file or folder paths when running various reports.
When running a Domain Accounts report, you can import a file with account names. Each account name must be on a separate line and must be fully qualified as in the following examples.
HAL-TEST\Abby
HAL-TEST\Grace
HAL-TEST\Nevaeh
HAL-TEST\Brayden
HAL-TEST\PJ
HAL-TEST\Angela
When running a Computer Information report, you can import a file with the computer names for the computer parameter. Each computer name must be on a separate line and must be fully qualified as in the following examples.
HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT
HAL-TEST-SQL.HAL-TEST.DEV.HAL.CA.QSFT
HAL-TEST-DC.HAL-TEST.DEV.HAL.CA.QSFT
HAL-TEST-ITSS.HAL-TEST.DEV.HAL.CA.QSFT
HAL-TEST-EXCHG.HAL-TEST.DEV.HAL.CA.QSFT
HAL-TEST-NODE0.HAL-TEST.DEV.HAL.CA.QSFT
When running a Folder Permissions report, you can import a file with the specific paths for the path parameter. Each path must be on a separate line.
\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\Financials Report.rtf
\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\HR\AMER\Payroll.rtf
\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\HR\EMEA\Employee List.rtf
\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\Sales\Financials Report.rtf
\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\Sales\Q3 Sales.rtf
\\HAL-TEST-SRV.HAL-TEST.DEV.HAL.CA.QSFT\Financials\Sales\Sales Graph.bmp