Working with Report Manager - Learning SQL Server Reporting Services 2012 - page 173

• For custom roles you may want to create and include collections of tasks
that is appropriate
First step - deploying reports
In order to work with reports you must irst deploy the reports to the Report Server.
Once it is deployed, the detailed information will be recorded in the Catalog as
shown here. This was obtained by running the query SELECT * FROM dbo.Catalog
(Catalog table in the ReportServer$KAILUA's Northwind database in the Database
Engine). There are lot more rows and lot more columns not shown in the screenshot.
Most of the objects were deployed by SSDT, an example of which was given in
Chapter 2 , SQL Server Reporting Services 2012 Projects with Visual Studio 2012 . Once
the report is deployed to the Report Server, Report Manager takes over to assign
roles to the users cleared by the Report Server's security features. Report Manager
can help in many report related tasks mentioned earlier in this chapter.
The following hands-on exercise in this chapter gives you the lavor of things you
can do in the Report Manager UI. Before moving on to the hands-on exercise, it is
advisable to look at the Report Manager UI.