Pro SQL Server 2012 Reporting Services

(sharon) #1

CHAPTER 6  BUILDING REPORTS


Figure 6-12. Interactive sort properties for the visit count

When you view the report with the new interactive sorting expressions in place, you can see the
automatic addition of a selectable sort icon in the Patient Count and Visit Count header fields, as shown
in Figure 6-13. When a user clicks this icon in the browser, the report will automatically re-sort to show
either the greatest or least number of patients per diagnosis or the greatest or least number of visits per
diagnosis. Figure 6-13 shows the diagnosis with the most number of visits, which is Physical Therapy
NEC with 1,579 visits and 76 unique patients diagnosed with this illness. The user could also choose to
sort the report in ascending or descending order by the number of patients.
Free download pdf