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:
If you are in the report designer, click Run Report.
Note. This also saves the report.
If you are in the folder tree, right-click the report and
select
Run
Report.
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.