Thursday, May 21, 2009

Navigations in Reporting Services

We can make three types navigations in SQL Server Reporting Services

  1. Navigating in same report(Book Marking)

  2. Navigating to another Report(Jump to Report)

  3. Navigation Website(Jum to URL)

Any text box or image item can be used for intrareport or interreport navigation,
for navigation to external resources like web pages and documents, and also to send
e-mail. All of these features are enabled by using navigation properties that can
be specified in the Textbox Properties or Image Properties dialog.

1.Navigating in same report(Book Marking)

This can be achieve with Book Marking in Reports.

Abookmark is a text box or image in a report that can be used as a navigational
link. If you want to allow the user to click an item and navigate to another item,
assign a bookmark value to each of the target items.

First, open the Textbox Properties dialog by right-clicking the text box and selecting
Properties from the pop-out menu. In the Textbox Properties dialog, then switch
to the Navigation tab.

To enable navigation to a bookmark, set the Jump to bookmark property to the target

Using bookmarks to navigate within a report is very easy to do. Each report item
has a BookMark property that may be assigned a unique value.

After adding bookmarks to any target items, use the Jump to Bookmark Selection list
to select the target bookmark in the Properties for the Source item. This allows
the user to navigate to items within the same report.

2.Navigating to another Report(Jump to Report)

This powerful feature enables a text box or image to be used as a link
to another report by passing parameter values to the target report. The target report
can consist of a specific record or multiple records, depending on the parameters
passed to the target report.

The following example uses a Products by Category report.That means the Products
report shows the list of all Products and the Category Report shows the information
about perticular Product. Name text box is used to link to a report that will display
the details of a single product record. The Product Details report is very simple.
This report accepts a ProductID parameter to filter the records and narrow down
to the record requested.

First, open the Textbox Properties dialog by right-clicking the text box and selecting
Properties from the pop-out menu. In the Textbox Properties dialog, then switch
to the Navigation tab.

Then select the Jump to report radio button, and select the target report from the
drop-down list.

Any parameters you need to pass to the target report can be configured using the
Parameters button. In the Parameters dialog, parameters for the target report are
selected in the Parameter Name column. Values supplied from the current report are
provided in the Parameter Value column, If you need to give a cue to the user that
the item is a link, you may want to display text with an underline.

When a product name is clicked on the main report, the viewer redirects to the detailed
report for the specific product by passing the ProductID parameter value.

3.Navigation Website(Jum to URL)

The Jump to URL option can be used to navigate to practically any report
or document content on your report server, and files, folders, and applications
in your intranet environment or on the World Wide Web. It can also be set to an
expression that uses links stored in a database, custom code, or any other values.
It’s more accurate to say that any URI (Uniform Resource Identifier) can be used
since a web request is not limited
only to a web page or document. With some creative programming, queries, and expressions,
your reports could be designed to navigate to a web page, document, e-mail address,
Web service request, or a custom web application, directed by data or custom expressions.

No comments:

About Me

My photo
I am a Postgraduate in Mathematics from Sri Venkateswara University. I made this blog to share and gain knowledge and basically to express myself. The purpose of making this site was also to make my work available at a single point on Internet. I started programming with dBase and FoxPro, then C and C++. I am a developer working with Software Company.