Report Viewer

When you run an Advanced Report, Express Report, or Crosstab Report, the output is shown in a paged, interactive format called the report viewer. The viewer shows you the report populated by all of its data. You can page through the data and search for specific items. You can also make some additional adjustments to the report, such as styling cells or changing column sorts.

To run a report in the report viewer:

The report viewer opens in a new tab, indicated by the viewer  icon. This tab represents an instance of the report output as you have just run it. If you go back and edit the report, you need to run the report again to see the changes. This will open another viewer tab, then you can go back and close the old one.

Page through the report by using the navigation icons    . Search through the report output by entering text in the Find field.

If you want to save the output, you can export from the report viewer to a PDF, RTF, CSV, or Excel file.

Interacting with reports

In the report viewer, you can make some changes to the style, formatting, and data. These changes can be saved to the original report, to a new copy of the report, or as a user report.

Caution. You must save your changes before closing the report viewer tab, or you will lose them.

What is a user report?

A user report is a customized version of a report that is specific to you. User report changes are saved separately from the report design, and will only show when you run the report yourself. These can be useful if you want to make changes to a locked  report. Changing report sorts and filters will cause the report to refresh.

Note about cookies. User reports may be stored as browser cookies. Ask your administrator whether this is the case. If so, then user report changes will only be applicable to your current computer and web browser. Clearing your browser cookies will remove any user report customizations that you have made.

Basic styling

Right-click a cell to open the style menu. Using this menu, you can change font, size, foreground and background color, bold, italic, underline, and alignment options. Right-click a chart to open the chart options menu. Using this menu you can swap to a different type of chart or make some basic formatting changes.

Column controls

Each column on the report has a light grey control box at the top of the page. Change the width of the columns by dragging the control left or right. Sort by a column by clicking the control. To hide a column, right-click the control and select  Hide Column from the list.

Sidebar

You can open a sidebar by clicking the splitter  icon on the right of the report. This sidebar shows the report columns, sorts, and filters, and allows you to show or hide columns, swap sort direction, and add filter values.

Some report fields may have the ability to specify custom filters values. To filter a field on a value, in the sidebar, click the Filters  icon, and select the data field. Then choose the values for the filter from the list. 

Troubleshooting

Why do I have so many tabs with the same name?

Each time you run a report, it opens a new instance of the report viewer. It is safe to close the tabs you are not using.

I do not see any Run button

If you do not see the Run buttons then this report cannot be run in the report viewer. One or both of the following are the cause:

My report does not show the right data

Critical errors cause a report to fail to execute. If this occurs, an error message will show: "An error has occurred that is preventing completion of this request. Please contact your administrator." Check the report for the following errors:

Cell errors do not cause a report to fail. However, they cause error messages to appear in the cells. Such errors may include:

No Data Qualified for this Report

This report has no data. This could be caused by over-reductive filtering, or the data fields may simply have no data. Try to narrow down the cause by removing filters and checking individual data fields.