Lay out the new Report Heading
Next, we will begin the design of the report layout in the SQL Server Report Builder (SSRB). From the C/SIDE RD, we click on View | Layout to open SSRB, ready to begin work on our layout. We'll begin by defining a report header.
Right-click in the layout work area (in the middle of the screen display), click on Insert, and then select Page Header. On the left-side of the menu, ReportData is displayed. Click on Datasets to display DataSetResult. Depending on what information we want to appear in the header, we might use fields from various parts of ReportData. If we had defined a Label to use for our Report Header, we could have done a drag-and-drop from the Label in the Parameters list. However, in our example, we dragged in a Text Box from the menu ribbon, which we placed in the upper left corner of the layout work area. We then typed a report name into that text box. Most of the other header fields were brought in from the Report Data Built-in...