CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0For this example, leave the default selections, as these will give you features such as automatic
aggregations for any numbers and dates and also create date variations so that for every Date Time data
type in the data source view, you will have Day, Month, and Year created. You can click Next and choose to
update statistics before generating, as shown in Figure 13-15. This is important if any data have changed
significantly in the source tables.
Figure 13-15. Update Statistics page
On the next page in the wizard, name your model Patient Census and select Run to begin the rules
to generate the model. Figure 13-16 shows the output after clicking Run, and the process has completed
successfully. You can see the details at each rule level of exactly what the rule did based on the data in
the data source view. Notice that for Create Date Variations, for example, the rule discovered and
created dates for DiagOnset, which is the date on which the patient was diagnosed with a disease. Other
attributes that were created were Sum, Avg, Min, and Max for the Length of Stay column. The length of
stay, usually an average, is the amount of time between the patient being admitted and being discharged
from a long-term health-care facility. The DateDiff function calculates the length of stay.