Tabular Reports

When you're more interested in raw values than trends, use a Tabular Report. You can create a standalone Tabular Report with the menu option File>New>OM Report>Tabular Report. As with Chart Reports, you can integrate your report into a Workspace on the Reports Tab.

You can save standalone reports to your XML library and open them with a double-click just as you do a Workspace. Whether you create a new report or open a saved report you will first be prompted to define the report source and then the report screen will appear. When you open a database report, dsClient will inspect all OM values to sum the number of errors counted, and depending on the condition of the database it may perform other operations to prepare the database. In either of these scenarios you'll see a progress bar at the bottom of the application window. If any of these operations must complete before you can interact with the report screen, the wait cursor will be displayed.

In the Tabular Report shown above, test results are analyzed to determine the cause of a failing test. The measurements displayed were added to the report by selecting summary OMs from the OM tree and by selecting error OMs from the Active Error Measurements dialog. If you haven't already familiarized yourself with those options, this would be a good time to review the Reporting Overview topic for information about the measurement tree, adding and removing measurements from a report, and viewing error measurements.

As you add measurements to the report, new rows are added at the bottom of the report. Error measurements are depicted using a red font, including the values, and you can choose between several options for column headers. Use the navigation controls to scroll through the results or jump to an area of interest as described below.

Clicking on a row selects that measurement, and when a measurement is selected you can drag it to the desired position or press F3 to locate the associated tree node in the measurement tree.

You can save standalone Tabular Reports to your library using the Save As... and Save buttons, and you can export some or all of the report content using the To CSV... button.

In the remainder of the topic we'll explore the various options in the report toolbar and the navigation controls.

The Report Toolbar

The options in a Tabular Report's toolbar allow you to customize your column headers and report values, and to manage the OMs included in your report.

Manage...: Opens the Manage Report Settings dialog. Here you can define Custom Measurements, set a Report Title if desired, and configure the column headers. You can choose that columns be identified by the report interval ID, the sequential integer values dsTest uses to identify report intervals, or by time - either time of day or time elapsed from the first report interval as shown in the example above.

Report Mode: This option, which defaults to Native Values, allows you to choose how measurement values are calculated for that chart. You can learn more about the available Report Modes here. You can set the default report mode in your Preferences.

Time Zone: This setting defaults to your PC's time zone. You can shift the report to a different time zone in order to align report interval times with the time stamps in a log or packet capture.

Remove OMs: No matter which method you choose to add measurements to your report you can remove the selected OM by clicking the delete icon () or pressing the Delete key, and you can remove all OMs by clicking the delete all icon ().

Database Information: When a report is generated from OM database(s) the name(s) of the file(s) are displayed along with the total number of report intervals.

Error Counter: Displays the total number of errors counted in a database report or the number of errors reported by dsTest in a live report. If errors are present you can click the View... button to open the Active Error Measurements dialog. Refer to Reporting Overview to learn more about adding those measurements to your report.

Navigation Controls

You can use the "forward" and "reverse" buttons to advance () or reverse () by a single column, to go to the next () or previous () page, or to go to the first () or last/most recent () report interval. When the most recent interval is visible in a live report, the report will automatically scroll to new intervals as they are received.

Click Go to... to open the Go To Interval dialog where you can specify a time frame.

In this dialog you can either enter an Interval ID or drag the slider to the desired report interval. Using either method will cause Interval Time, which displays the interval time stamp, to be updated. When you're satisfied with the selection, click OK and that interval will become the first column in your report view.