Pro SQL Server 2012 Reporting Services

(sharon) #1

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



  • Branch

  • Diag

  • Discipline

  • Documentlmage

  • PatEMRDoc

  • Employee

  • PatDiag

  • Dischg

  • Patient


Each table contains specific information that is relevant to the individual patient’s admission
history, and together they will provide enough data to create many kinds of census reports for many
departments within the health-care agencies. You know the kinds of questions you will need to answer,
and the tables have been designed to deliver that information based on direct feedback and requests for
users. Now, let’s move on to designing the query and building the report model.

Introducing the Report Model


Just because you don’t understand the intricacies of putting all the parts of a car engine together does
not mean you can’t drive, right? The same can be said for report designers who will design and publish
reports using the ad hoc Report Builder 1.0. In this case, you have little need to understand the pieces
and parts of the database structure in order to build reports. It is unavoidable, though, that someone
must understand the database schema, just as mechanics must understand brake pads and fan belts.
Building a versatile report model, which the report designer will use to create reports, will most likely fall
under the authority of the DBA, data analyst, or SQL developer, who will have an intimate understanding
of the data sources. In this section, we will show how to use the feedback gathered from the report
consumers to develop a report model for the patient census reports that will serve to make the data
easily accessible with logical and intuitive field names.
You will perform the following procedures to create the report model for the Patient Census report
model:


  1. Create a report model project using BIDS/SSDT.

  2. Create a data source.

  3. Create a data source view.

  4. Create the Patient Census report model based on the data source view

  5. Publish the Patient Census report model to the SSRS server.


The process of building a report model consists of many individual steps, many of which are
controlled entirely by stepping through available wizards. A report model can be complex or simple,
based on your individual needs. For the sake of brevity, we will keep the sample model as simple as
possible; you will be able to answer the feedback questions for the patient census, and you will be able to
create and publish your own report model without any issues.
Free download pdf