Page 196 - DCAP606_BUSINESS_INTELLIGENCE
P. 196
Unit 14: Reporting Tools
14.2.1 Architecture Notes
After using SSRS, the architecture is just like a small operating system. The Report Manager is
the central person who acts as a manager to decide when the reports will be scheduled to run
along with maintaining the user profiles on the report server.
On Report Server all the reports reside. All other activities pertaining to SSRS is done at report
server.
Did u know? Report Designer is a graphical tool that is hosted within the Microsoft Visual
Studio IDE. It provides tabbed windows for Data, Layout, and Preview that allow you to
design a report interactively.
14.2.2 Working with SQL Server Reporting Services
After installing SQL server reporting services on your system, start the Visual studio IDE. Go to
File -> New Project, and you will be shown a prompt with ‘New project’. Select Business
Intelligence Projects from the Project Types. As this is our first project, use Report Project Wizard.
Figure 14.1: New Project Window
Source: http://www.codeproject.com/KB/books/Start_SSRS/1.jpg
Specify the name of the project as well as the location where the project will be placed. On click
of OK, you will be prompted with a report wizard screen as shown in Figure 14.2. Click on Next
to follow up to the next screen.
LOVELY PROFESSIONAL UNIVERSITY 191
