CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0Figure 13-61. Report Builder 3.0 drill through report
After you preview the report, return to the designer and save the report out to the Pro_SSRS folder,
as we have throughout this chapter. Saving the report in this path will allow us to drill through to this
report when we have our Map report created. With the report saved to the Report Server, click on the
Ribbon button and click New. As stated previously, our next report is going to contain aggregated visit
and estimated cost for each state that a patient is from as well as which state the patient was actually
seen at. Figure 13-62 shows an example of the report while in design mode.
Note Again, we have been using sample data that has been changed to provide result sets that represent real
world scenarios. With our fictitious patients coming from around the country, it is not very likely that they would
travel from states like California, to be seen in Ohio. Nonetheless, the example in the following section could be
used for many applications that have a requirement to provide maps along with quantifiable data.