Page 197 - DCAP606_BUSINESS_INTELLIGENCE
P. 197
Business Intelligence
Notes
Figure 14.2: Report Wizard Screen
Source: http://www.codeproject.com/KB/books/Start_SSRS/2.jpg
On the next screen, you will need to create a data source for the report. Just click on Edit to
specify the server name and the database then will be used from that server. The connection
string is automatically created.
Figure 14.3: Select Data Source
Source: http://www.codeproject.com/KB/books/Start_SSRS/3.jpg
On click of Next, you will be prompted with the Query Builder screen. Here you can add tables,
select columns as well as execute the SQL statements.
192 LOVELY PROFESSIONAL UNIVERSITY
