Report Builder 2.0 - Server Status and Tools Page - 2

Page 2 of 2

Author: Packt Publishing Published on: 5th Jun 2009

Report Builder 2.0 - Server Status and Tools

Now expand the Security node of Reporting Services and you will see that the My Reports role is present in the list of roles as shown. This is also added to the ReportServer database.

Ads

The description of everything that a user with the assignment My Reports role can do is as follows:

"May publish reports and linked reports, manage folders, reports, and resources in a users My Reports folder." As discussed in Chapter 5, this role may be assigned to a user in Report Manager.

Now bring up Report Builder 2.0 by clicking Start | All Programs | Microsoft SQL Server 2008 Report Builder | Report Builder 2.0. Report Builder 2.0 is displayed.

Click on Office Button | Open.
The Open Report dialogue appears as shown. When the report Server is offline, the default location is My Documents, like Microsoft products Excel and MS Access.
.

Choose the Recent sites and Servers.
The Report server that is active should get displayed here as shown:

12. Highlight the Server URL and click Open.

All the folders and files on the server become accessible as shown:

13. Open the Report Manager by providing its URL address.

Verify that a My Reports folder is created for the user (current user). For other users you need to go into Report Manager and assign the role as discussed in Chapter 5.

Ads

There could be slight differences in the look of the interface depending on whether you are using the RTM or the final version of SQL Server 2008 Enterprise edition.

1 2

This tutorial is part of a SQL Server Reporting Services tutorial series. Read it from the beginning and learn yourself.

SQL Server Reporting Services