Database Reference
In-Depth Information
Figure 13-28.
Displaying the results of the stored procedure in Reporting Services
We will delve deeper into both of these scenarios in the chapters on Excel reporting and reporting services.
Moving On
You will need quite a bit of practice to become an expert at writing report queries. Report stored procedures often
included hundreds of lines of code. These stored procedures take many days to write and test correctly. When
stored procedures become this large, it is very easy to make mistakes that can cost a lot of time and money. The
methodology of incrementally building and reviewing your results, using consistent formatting and abstraction
layers, make reporting queries easier to maintain and cost effective.
Learn By doing
in this “Learn by Doing” exercise, you create several SQL queries using the northwind database. We included
an outline of the steps to perform and an example of how the authors handled them in two Word documents.
These documents are found in the folder
C:\_BISolutionsBookFiles\_LearnByDoing\Chapter13Files
. Please see the
ReadMe.doc
file for detailed
instructions.
