Page 199 - DCAP606_BUSINESS_INTELLIGENCE
P. 199
Business Intelligence
Notes
Figure 14.6: Query Builder with sample data
Source: http://www.codeproject.com/KB/books/Start_SSRS/7.jpg
Based on what query suits your report, create the SQL statement and proceed forward. On next
click, you will be prompted with the report type screen. You can choose as Tabular or matrix. To
make things simpler, use the Tabular format.
Figure 14.7: Chose Report Type
Source: http://www.codeproject.com/KB/books/Start_SSRS/8.jpg
194 LOVELY PROFESSIONAL UNIVERSITY