Export (0) Print
Expand All

HTML Viewer

SQL Server 2000

Reports that are hosted by Microsoft® SQL Server™ Reporting Services can be viewed over a Web connection or in a Web-oriented format through HTML Viewer. HTML Viewer provides a framework for viewing reports in HTML. It includes a report toolbar, a parameter section, and a document map.

The report toolbar in HTML Viewer includes features you can use to work with your report, including export options so that you can view your report in formats other than HTML. The parameter section and document map appear only when you open reports that are configured to use parameters and a document map control.

The report toolbar is similar to the one shown in the following illustration. The report toolbar that you see may differ from the illustration based on report features or the rendering options that are available.

The following table describes commonly used features of the report toolbar. Each feature is identified by the control that you use to access it. Advanced features are discussed later in this topic.

Use this icon or control To
Page navigation controls Open the first or last page of a report, scroll through a report page by page, and open a specific page in a report. To view a specific page, type the page number and press ENTER.
Page display controls Enlarge or reduce the size of the report page. In addition to percentage-based changes, you can choose Page Width to fit the horizontal length of a report page in the browser window, or Whole Page to fit the vertical length of a report in the browser window. A Zoom option is supported by Microsoft® Internet Explorer 5.5 and later.
Search field Search for content in the report by typing a word or phrase that you want to find (the maximum value length is 256 characters). The search is case-insensitive and begins at the page or section that is currently selected. Only visible content is included in a search operation. To search for subsequent occurrences of the same value, click Next.
Export formats Open a new browser window and render the report in the selected format. The formats that are available are determined by the rendering extensions that are installed on the report server. TIFF is recommended for printing.
Click Export to view the report in the selected format.
Document map icon Show or hide the document map pane in a report that includes a document map. A document map is a report navigation control similar to the navigation pane on a Web site. You can click on items in the document map to navigate directly to a specific group, page, or subreport.
Show and hide icons Show or hide parameter value fields and the View Report button in a report that includes parameters.
Report refresh icon Refresh the report. Data for live reports will be refreshed. Cached reports will be reloaded from where they are stored.
HTML Viewer Help icon Open Help.

About Export Formats

From the report toolbar, you can choose to view your report in a variety of formats. The formats that are available are determined by the rendering extensions that are installed on the report server. When you choose another format, a second browser window is used to display the report, using a viewer associated with the export format you selected. If a viewer is not available for the format you select, you can choose a different format.

The following export formats are included in a default report server installation. The list of export formats available to you may vary from those listed here.

Export format Description
Acrobat (PDF) file View a report using a client-side PDF viewer. You must have Adobe Acrobat Reader to use this format.
HTML with Office Web Components View the report using client-side Office Web Components to support charts or controls embedded in the report. You must have Office Web Components to use this format.
Excel View the report in Microsoft Excel.
Web archive View the report in an MIME-encoded HTML format that keeps images and linked content together with a report.
TIFF file View the report in the default TIFF viewer. For some Microsoft Windows clients, this is the Windows Picture and Fax Viewer.
Choose this format to a view a report in a page-oriented layout. The TIFF format is the recommended format for printing reports.

Advanced Report Features

Depending on how your report is designed, it may include input fields that you can use to choose parameter values, log on to a data source, or filter report content.

Parameter Fields

Parameters are values that are used to select specific data (specifically, they are used to complete a query that selects the data for your report, or to filter the result set). Parameters that are commonly used in reports include dates, names, and IDs. When you specify a value for a parameter, the report contains only the data that matches the value; for example, employee data based on an Employee ID parameter. Parameters correspond to fields on the report. After you specify a parameter, click View Report to get the data.

The report author defines the parameter values that are valid for each report. A report administrator can also set parameter values. To find out which parameter values are valid for your report, ask your report designer or administrator.

Credential Fields

Credentials are user name and password values that grant access to a data source. After you specify your credentials, click View Report to get the data. If a report requires you to log on, the data that you are authorized to see might differ from the data that another user sees. Consequently, two users can run the same report and get different results. In addition, some reports contain hidden areas that are revealed based on user logon credentials or selections made in the report itself. Hidden areas in the report are excluded from search operations, producing different search results than when all parts of the report are visible.

See Also

Running Reports

Viewing Reports With Report Manager

Viewing Reports With a Browser

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft