Pro SQL Server 2012 Reporting Services

CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0

LEFT OUTER JOIN PatEMRDoc AS EMR ON A.PatProgramID = EMR.PatProgramID
LEFT OUTER JOIN DocumentImage AS DI ON DI.DocumentImageID = EMR.DocumentImageID
LEFT OUTER JOIN Dischg AS DS ON A.DischargeTblID = DS.DischgTblID
WHERE
(PD.DiagOrder = 1)

Figure 13-9. Named query displayed graphically with alias names

Finally, name the query Patient Census. When you click OK to complete the named query, your
simple data source view consists of one object, Patient Census that contains the desired fields for the
model. You can see in Figure 13-10 that 32 fields will be supplied to the model.