Troubleshooting Report Problems

Use this topic to troubleshoot problems that you encounter when viewing published reports.

Export to Web archive uses cached data

If you export a report to Web archive (MHTML) in Microsoft Internet Explorer, and you select a different parameter value between export operations, the exported report will contain the report values associated with the previous selection. This occurs because Internet Explorer loads the report from its cache rather than the up-to-date version provided by the report server. To work around this issue, you can either clear the browser cache or click Refresh on the report toolbar before re-exporting the report.

For information about other browser-related issues, see Browser Support in Reporting Services.

Export fails if you are missing a client component

Some export formats require a client component. If a required client component is not installed, the export does not occur. For example, if you want to open a report in PDF format, you must have Adobe Acrobat Reader installed on your computer. You can download Acrobat Reader from the Adobe Web site.

Interactive report features do not work in an exported report

If you save a report that has interactive features, those features are not reflected in a report that you save as a static file. Examples of these types of reports are matrix reports and reports that include hyperlinks. If you save a report in an interactive format (specifically, HTML with Office Web Components) onto your computer, the resulting file will contain errors and missing images. The HTML with Office Web Components format is not intended for static files.

Toggle items do not work

If a report generates without errors, but toggle items do not work (for example, you click an expand icon (+) and nothing happens), check the name of the computer hosting the report server. If the computer name includes an underscore, toggle items do not work. This is a known issue. There is no workaround. If you want to support toggle items, you must use a computer that does not include underscore characters in its name.

See Also

Concepts

Reporting Services Log Files

Other Resources

Troubleshooting Reporting Services
Reporting Services Errors and Events

Help and Information

Getting SQL Server 2005 Assistance