Article ID: 109152
Article Last Modified on 2/12/2007
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 7.0 Professional Edition
- Microsoft Visual FoxPro 8.0 Professional Edition
- Microsoft Visual FoxPro 9.0 Professional Edition
This article was previously published under Q109152
SUMMARY
In the Visual FoxPro Report Designer, you can create a data grouping that will break after a certain number of records.
For example, the following procedure will create a data grouping that breaks after every fifth record.
- Create a quick report based on theCustomer table.
- From the Report menu, choose Variables.
- Choose Add to add a variable.
- For the variable name, type cntr.
- For the value to store, type Customer.region. (In VFP 3.0, type Customer.state.)
- Select the Count radio button in the Calculate box and choose OK twice to return to the report.
- From the Report menu, choose Data Grouping.
- Choose Add to add a Data Grouping.
- Enter the following expression to group on:
- INT(cntr/5)
- Select OK twice to return to the report. You can now place fields and text in the group header and footer, which will print every fifth record.
Additional query words: VFoxWin FoxMac FoxDos FoxWin RWriter
Keywords: KB109152