Working with a Report in Run Mode (Report Builder)

When you click the Run Report button, the report is displayed in run mode. In Report Builder run mode, you can do the following:

  • Export a report to a different file type.
  • Print the report.
  • Save the report to the report server or your local computer.
  • Search the contents of your report data.
  • Sort the data.
  • View the data in your report.
  • View clickthrough reports.
  • Zoom in and out of the report page.

Viewing the Report Contents

Using the Run toolbar, you can see how many pages there are in your report, move between the pages of the report, and view the contents of the report.

You can locate specific information within your report by using the Find and Next buttons. For example, suppose you want to locate a specific value, such as a product name, that appears within your report. You can type the value into the Find box and then use the Find and Next buttons to locate all instances of that value within the report.

Depending on the number of rows and columns in your report, you might want to adjust the size of the pages in the current report. In run mode, you can zoom in and out of the contents of the report page. Zoom settings can be set from 25% to 500% of the original page size. You can display an entire page within the run area of the window. Choosing the Whole Page option changes the zoom settings of each page, depending on the quantity of data displayed on that page. You can also display the contents of the report so that the report contents span the entire page. If you set the Zoom settings and then save your report, this does not affect the ability of other individuals to control their zoom settings when they view the report.

Refining the Report

In run mode, you can continue to refine your report by changing the filter, or sorting and grouping your data. For example, after reviewing the contents and appearance of your report, you might decide to apply page breaks to your report to make the data more readable. Or, suppose you decide to apply a filter to your report so that only the data pertaining to the Manufacturing department is displayed. When you update the report, Report Builder automatically refreshes the data so that you can see how the changes affect the data returned. For example, after you apply page breaks, Report Builder automatically runs the report again and returns the report with the page breaks applied.

The format or design of the report cannot be changed in run mode. Instead, switch back to design mode by clicking the Design Report button on the Report Builder toolbar and then you can continue to work with the report layout. Switching back to design mode requires you to work with representations of the data again.

After running your report, you can save the report to the report server or to your computer. For more information about saving a report, see Saving a Report (Report Builder). If you want to save the report with the data included, you can use one of the export options to save your report as a different file type. For more information about saving a report as a different file type, see Exporting a Report as a Different File Type (Report Builder).

After running your report, you might want to print a copy. For more information about printing a report, see Printing a Report (Report Builder).

See Also

Concepts

Running a Report (Report Builder)
Viewing Clickthrough Reports from a Report (Report Builder)
Working with Data (Report Builder)
Grouping and Sorting Data (Report Builder)

Other Resources

Report Builder Window (Run Mode)

Help and Information

Getting SQL Server 2005 Assistance