Pro SQL Server 2012 Reporting Services

(sharon) #1

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



  1. Next, Drag Visit_Count and Estimated_Cost over to the values area as seen in
    Figure 13-48.


Figure 13-48. Arrange fields screen


  1. Click Next to proceed to the Layout selection screen. This screen allows us to
    select a blocked or stepped look for our report. It also has a feature for auto
    creating expanding or collapsing drill down capabilities using the
    Expand/collapse groups checkbox. Leave the default values as shown in Figure
    13-49 and click Next.

  2. Leave the default Ocean style selected and click Finish to generate our report.

  3. Adjust the columns to a width that prevents the header contents from
    wrapping to the next line.

  4. Change the title to Service Type Estimated Cost by Branch.

Free download pdf