Using Repeaters

Use repeaters to repeat items when you run the report. For example, you can use repeaters to create mailing labels, including customer names and addresses.

To build a repeater, drag the Repeater or Repeater Table object from the Toolbox tab to the work area. Use repeaters to repeat items across a single row without a particular structure. For example, you want to create a list that contains Year, and Product line. For each year, you want all product lines to appear in a single row. To do this, create a list with Year as a column and with a repeater as a second column. Then insert Product line into the repeater. Use repeater tables to repeat items in a table structure. Drop the items in the repeater, and modify the properties of the repeater to obtain the results you want. For example, you can specify how many frames appear per page in a repeater table by typing values in the Across and Down properties.

Convert a List into a Repeater

You can convert a list into a repeater table to take advantage of an existing list.

Steps

1. Click any part of the list.

2. From the Structure menu, click Convert List to Repeater.

Example - Create Mailing Labels

You are a report author at The Great Outdoors Company, which sells sporting equipment. You are requested to create mailing labels for all of the company's retailers.

Steps

1. Open Report Studio with the GO Data Warehouse (query) package.

2. In the Welcome dialog box, click Create a new report or template.

3. In the New dialog box, click Repeater Table and click OK.

4. Click the repeater, click the select ancestor button  in the Properties pane title bar, and click Repeater Table.

5. In the Properties pane, set the following properties:

   • Set the Across property to 2.

   • Set the Down property to 5.

   • Double-click the Table Properties property, select the Fixed size check box, and click OK.

6. In the Insertable Objects pane, on the Toolbox tab, drag the Table object to the repeater.

   The Insert Table dialog box appears.

7. In the Number of columns box, type 1 and click OK.

8. Click the table, ensure that you see Table Cell in the Properties pane title bar, and modify the following properties:

   • Double-click Background Image, click Browse, click logo.jpg, and click OK.

   • In the Background Image dialog box, under Position, click the align top right button.

   • Under Tiling, click Do not tile and click OK.

   • Double-click Size & Overflow, and in the Height box, type 175, and click OK.

9. Click the table, click the select ancestor button in the Properties pane title bar, and click Table.

10. In the Properties pane, specify properties for the table:

    • Double-click Border.

    • In the Style box, click Solid line.

    • In the Width box, click 1 pt.

    • In the Color box, click Black.

    • Under Preview, click the apply all borders button  and click OK.

    • Double-click Font, and under the Size box, click 8pt, and click OK.

11. In the Insertable Objects pane, on the Toolbox tab, drag the Block object to the repeater 8 times to create 8 blocks.

12. Drag the Text Item object  to the first block:

    • In the Text dialog box, type To: and click OK.

    • Select the text item.

    • Double-click the Font property, set the weight to Bold, and click OK.

13. Click the first block, and, in the Properties pane, specify properties for the first block:

    • Double-click the Padding property, type 35 in the box on the right, click mm as the unit, and click OK.

    • Set the Horizontal Alignment property to Center.

14. In the Insertable Objects pane, on the Source tab , expand Sales and Marketing (query), Sales (query), and Retailer site and drag seven data items to the remaining seven blocks.

15. Ctrl+click the seven blocks to select them, and in the Properties pane, specify properties for the seven blocks:

    • Double-click the Padding property, type 25 in the box on the left, click mm as the unit, and click OK.

    • Set the Horizontal Alignment property to Left.

When you run the report, each page contains 10 mailing labels in two columns.