The HTML Viewer is a special toolbar that displays when you view a report . You can use the HTML Viewer to navigate through the pages of your report, change the zoom factor of the page, search text in the report, export the report to another format, refresh the report, or print the report . You explore the HTML Viewer in more detail in Chapter 13, “Accessing Reports Online .”
Open a report in a SharePoint shared document library
In this procedure, you search for a specifi c string in your report .
Search for a string in a report
1. In the Find text box, located to the right of the Zoom drop-down list, type racing, and then click Find .
Note The steps to search for a string in a report are exactly the same whether you are viewing a report on a native-mode report server or a SharePoint integrated-mode report server .
The fi rst instance of the string displays as shown here . Notice that the search is not case-sensitive .
2. Click Next twice to continue the search, and click OK in the message box .
Each time you click Next, the search continues to the next instance until you reach the end of the report .
By completing the procedures in this chapter, you have toured all three phases of the report life cycle: development, administration, and access . This tour introduced you to several key features, but there’s much more to learn . Each of the remaining chapters of this book covers these features in greater detail to help you master Reporting Services .
Search for a string in a report
Chapter 3 Quick Reference
To Do This
Open Report Builder 2 .0 Click Start, select All Programs and Microsoft SQL Server 2008 Report Builder 2 .0, and select Report Builder 2 .0 .
Add a data source In the Report Data pane, click New, select Data Source, type a name for the data source, select a connection type, and type a connection string, or use the Build button to access the Connection Properties dialog box to build a connection string by using a GUI .
Add a dataset In the Report Data pane, click New, select Dataset, type a name for the dataset, and type a query string or click Import to import a query stored in an SQL script file .
Add a report title to the page header section
Click inside the text box containing the text Click To Add Title, and type a text string .
Add a table to a report by using the Insert Table command
On the Insert tab of the Ribbon, in the Data Regions group, click Table, select Insert Table, click a location on the report design surface to position the upper-left corner of the table, and drag fields from the Report Data pane to cells in the table . Add a parent row group In the data region, right-click a field, select Add Group, select
Parent Group in the Row Group section, select a field for grouping in the Group By expression drop-down list, and optionally select the Add Group Header and Add Group Footer check boxes;
or
In the Row Group section of the Grouping pane, right-click an existing group, select Add Group, select Parent Group, select a field for grouping in the Group By expression drop-down list, and optionally select the Add Group Header and Add Group Footer check boxes .
Add a page break between each instance of a group
In the Grouping pane, right-click a group, select Group Properties, click Page Breaks, and select the Between Each Instance Of A Group check box .
Open the Properties pane On the View tab, in the Show/Hide group, and select the Properties check box .
Set format properties Select a text box, row, or column, and click a style button on the Home tab of the Ribbon or set a property value in the Properties pane .
Preview a report On the Home tab, click Run, or click the Run button at the bottom of the Report Builder 2 .0 window .
To Do This
Publish a report Click Report Builder, click Save As, type the report server URL, navigate to the target folder, and type a name for the report . For a native-mode report server, use the following default URL:
http://<servername>/reportserver
For a SharePoint integrated-mode server, use the following default URL: http://<servername>/sites/<sitename>; and the following default folder: http://<servername>/sites/<sitename>
/ReportsLibrary .
Manage report properties For a native-mode report server, open Report Manager at http://<servername>/Reports, click Show Details, click the Properties icon, click the applicable link in the left frame to access properties, set the property value, and click Apply . For a SharePoint integrated-mode server, open the shared document library at http://<servername>/sites/<sitename>
/ReportsLibrary, point to the report, click the drop-down arrow, and click the applicable command, such as Manage Processing Options .
View a report For a native-mode report server, open Report Manager at http://<servername>/Reports, and click the report link . For a SharePoint integrated-mode server, open the shared document library at http://<servername>/sites/<sitename>
/ReportsLibrary, and click the report link .
101