Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

intentionally made the size of the reports small, with 8-point Arial font and narrow cells. Figure 12-10

shows the Design tab for the Average Time to Admission report.

Figure 12-10. Layout tab for Average Referral to Admission report

At this point, we could publish both reports to the reporting services instance and deliver the

reports to users. These two reports combine a level of BI that is perfect for a view within a dashboard or

business portal. To that end, we will take a final view of the second chart-based report in the design

environment and then move on to a fully integrated Microsoft SharePoint deployment, where the

reports can be viewed and managed within SharePoint itself. Figure 12-11 shows the Referral to

Admission Chart report previewed in BIDS.

Figure 12-11. Previewing Referral to Admission Chart in the design environment