Using virtual tables to loop through data

Just as you can repeat code using a loop, you can also repeat data items in a report using a virtual table. This recipe will show you how to use the most common virtual table, Integer.

How to do it...

1. Create a new report by following the Using the Report Generation Wizard recipe.

2. Add the following global variable:

   Name	Type
   NoOfCopies	Integer

3. Add a label and textbox control to the request form.

4. Set the following property on the textbox control:

   Property	Value
   SourceExpr	NoOfCopies

5. Set the following property on the label control:

   Property	Value
   Caption	No. of Copies

6. Insert an Integer data item above the Customer data item.

7. Change the Name field for the Integer data item to CopyLoop.

8. Indent the Customer data item by using the right arrow button on the bottom of the form.

9. Delete the CopyLoop Body section from the Section Designer.

10. Add the following code to the OnPreDataItem trigger for CopyLoop:

    SETRANGE(Number, 0, NoOfCopies);
    

11. Save and close...