[]
        
(Showing Draft Content)

Overflow PaceHolder

In a Page report, the Overflow Placeholder control is a rectangular placeholder for data that does not fit inside the fixed size of a List, Banded List, Tablix or Table data region. When you link a data region to an Overflow Placeholder, this control gets its Size property values from the FixedSize of the data region it is linked with.

You can also place multiple Overflow Placeholder controls in a report to create different looks for your data output. Link a data region to an Overflow Placeholder control and then link that Overflow Placeholder control to another Overflow Placeholder control. Two common layouts that you can create are:

  • Multiple Page Layout: Place the data region on the first page of the report and Overflow Placeholder controls on subsequent pages to create a layout with overflow data on multiple pages.

  • Columnar Report Layout: Place the data region and the Overflow Placeholder on the same page of the report to create a layout that displays data in a columnar format.

Some properties of the Overflow Placeholder control are described below. Note that you need to enable Advanced Properties Mode to view all properties.

Name: The Overflow Placeholder name.

Overflow Name: Select an Overflow Placeholder control to associate with the Overflow Placeholder control from the drop-down list. If a report does not contain any Overflow Placeholder control or if you don't want to associate the Overflow Placeholder control with another one from the report, select None.

Use Case

Let us create a report that displays a list of sales for a store with a columnar report layout. Place the Table data region and the Overflow Placeholder control on the same page to display the report data in two columns.

The final report will be as shown.

  1. Create a Page report and drag-drop four Textbox controls onto the design area and set their Value properties as follows.

    • Select TextBox1 and enter the expression =Globals!ExecutionTime

    • Select TextBox2 and enter the text 'Store:'

    • Select TextBox3 and enter the expression =Fields!Store.Value

    • Select TextBox4 and enter the text 'Dear sir/madam, Thank you for your business. Below is a list of your sales for the past year. Please take this opportunity to review each sale and the total for accuracy. Call us at 1-800-DNT-CALL with any questions or concerns.'

  2. Drag-drop the Overflow Placeholder control and set its properties to the following values in the Properties tab.

    • Left: 3.4in

    • Top: 2.7in

    • Width: 3in

    • Height: 5.6in

  3. Similarly, drag-drop the Table control and set its properties to the following values.

    • Data Set Name: Select the report data set from the drop-down list of bound data sets

    • Overflow Name: OverflowPlaceholder1

    • Left: 0.2in

    • Top: 2.7in

    • Width: 3in

    • Height: 0.5in

    • FixedWidth: 3in

    • Fixed Height: 5.6in

  4. In the Filters property, go to Show Items, and select Add Item.

  5. Click the icon to display filter properties, then click the radio button next to Filter Expression and select 'Store'.

  6. From the drop-down next to Operator, select 'Equal'.

  7. Click the radio button next to Value and enter the expression '1002'.

  8. Bind the TextBoxes in the Table's Details row to [SalesID], [SaleDate], and [TotalAmount] as shown in the following.

  9. Drag-drop two Textbox controls onto the design area and set their Value properties as follows.

    • Select TextBox11 and enter the text 'Total:'

    • Select TextBox12 and enter the expression =SUM(Fields!TotalAmount.Value)

  10. Improve the appearance of the report by resizing the controls and applying font style and alignment properties.

  11. Preview the report.