Seek and Ye Shall Find: Search and Find Functions


The Report Manager provides two features to help users find information. The Search function helps the user locate a report within the Report Server folder structure, and the Find function allows the user to jump to a certain piece of information while viewing a report.

Searching for a Report

First, we will look at the Search function. This function allows the user to enter a portion of a word, a complete word, or a phrase. The Report Manager then searches the names and descriptions of items in the Report Server folder structure for occurrences of this text. The Report Manager does not search the contents of a report or supporting files.

For example, searching for “GDS Report” would find “The GDS Report” and “GDS Reporting.” It would not find “Report GDS Income” or “GDS Accounting Report.” This is strictly a search for the text just as it is entered. There is no Boolean logic, proximity searching, or other features that you find in Internet search engines. Also, the search is not case sensitive.

Follow these steps to use the Search function:

  1. Open up the Report Manager in your browser and navigate to the Home folder.

  2. Type report for Search For in the upper-right corner of the screen and then click Go. The Search page will be displayed with the search results.

  3. The Report Manager will find five items, two folders, a text document, and two reports. There is no weighting or relevance assigned to each result. They are simply displayed in alphabetical order. Click the Galactic Delivery Services folder. You will see the contents of that folder.

  4. Click your browser’s Back button to return to the search results.

  5. Click ReportReadMe.txt. You will see the contents of this file.

  6. Click your browser’s Back button.

  7. Click the SubReportTest report to execute this report. (Keep your browser on this report. We will use it in the Find feature.)

Finding Text Within a Report

Next, we will look at the Find function. This function also allows the user to enter a portion of a word, a complete word, or a phrase. The Report Manager then searches the contents of the current report for occurrences of this text. It then highlights the first occurrence and moves it to the top of the view. The user can use the Next button to move to the next occurrence.

As with the Search function, Find will locate text just as it is entered. There is no Boolean logic or proximity searching. Also, Find is not case sensitive.

We will use the SubReportTest report to demonstrate the Find function. This report should be open in your browser. The SubReportTest report lists all the transports used by GDS. They are listed in transport number order. Suppose we want to look at just the Warp Hauler–type transports sprinkled throughout the report. Rather than skimming through the entire report looking for what we are interested in, here is a better way:

  1. Type warp haul in the entry area to the left of the words “Find | Next” in the Report Viewer toolbar.

  2. Click Find. The first Warp Hauler transport (#1303) will be brought to the top of the viewing area and the “Warp Haul” portion of the transport type will be highlighted.

  3. Click Next. (Make sure you do not click Find. Clicking Find simply starts the find operation again from the top of the page.) The next Warp Hauler transport (#1307) will be brought to the top of the viewing area.

  4. Click Next. The report jumps to the next Warp Hauler transport (#1310). Click Next once more and the report jumps to the next Warp Hauler transport (#1311) on page 2 of the report.




Microsoft SQL Server 2000 Reporting Services
Microsoft SQL Server 2000 Reporting Services Step by Step (Pro-Step by Step Developer)
ISBN: 0735621063
EAN: 2147483647
Year: 2003
Pages: 109

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net