https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/168527&feed=atom&action=history
Microsoft KB Archive/168527 - Revision history
2024-03-29T01:13:56Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/168527&diff=342097&oldid=prev
X010: Text replacement - """ to """
2020-07-21T10:03:56Z
<p>Text replacement - """ to """</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 10:03, 21 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l53">Line 53:</td>
<td colspan="2" class="diff-lineno">Line 53:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Visual FoxPro has a limitation on the length of report bands. The maximum length for a single band is the page length.<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Visual FoxPro has a limitation on the length of report bands. The maximum length for a single band is the page length.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>It is possible to create a report that simulates a detail band with a length greater than the length of a single page. This requires setting up a dummy data grouping on RECNO(<table with records repeating in the detail band>), and creating what amounts to a larger <del style="font-weight: bold; text-decoration: none;">&quot;</del>virtual<del style="font-weight: bold; text-decoration: none;">&quot; </del>Detail Band comprised of the RECNO() Group Header, the actual Detail Band, and the RECNO() Group Footer. See the MORE INFORMATION section of this document for details.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>It is possible to create a report that simulates a detail band with a length greater than the length of a single page. This requires setting up a dummy data grouping on RECNO(<table with records repeating in the detail band>), and creating what amounts to a larger <ins style="font-weight: bold; text-decoration: none;">"</ins>virtual<ins style="font-weight: bold; text-decoration: none;">" </ins>Detail Band comprised of the RECNO() Group Header, the actual Detail Band, and the RECNO() Group Footer. See the MORE INFORMATION section of this document for details.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l63">Line 63:</td>
<td colspan="2" class="diff-lineno">Line 63:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Create a new report.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Create a new report.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Make a Quick Report using Report/Quick Report from the Visual FoxPro menu.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Make a Quick Report using Report/Quick Report from the Visual FoxPro menu.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># Select the Customer table in the VFP\Samples\Data directory for Visual FoxPro versions 3.0 and 5.0 or the home(2)+<del style="font-weight: bold; text-decoration: none;">&quot;</del>data<del style="font-weight: bold; text-decoration: none;">&quot; </del>directory for Visual FoxPro 6.0 when prompted for a table.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># Select the Customer table in the VFP\Samples\Data directory for Visual FoxPro versions 3.0 and 5.0 or the home(2)+<ins style="font-weight: bold; text-decoration: none;">"</ins>data<ins style="font-weight: bold; text-decoration: none;">" </ins>directory for Visual FoxPro 6.0 when prompted for a table.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># From the Quick Report dialog box, select the right-most <del style="font-weight: bold; text-decoration: none;">&quot;</del>Field layout<del style="font-weight: bold; text-decoration: none;">&quot; </del>button, and then click OK.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># From the Quick Report dialog box, select the right-most <ins style="font-weight: bold; text-decoration: none;">"</ins>Field layout<ins style="font-weight: bold; text-decoration: none;">" </ins>button, and then click OK.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># In the Report Designer, set up a data grouping. This is done by selecting Report/Data Grouping from the menu. In Visual FoxPro 9.0, select Report/Optional bands from the menu.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># In the Report Designer, set up a data grouping. This is done by selecting Report/Data Grouping from the menu. In Visual FoxPro 9.0, select Report/Optional bands from the menu.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># In the <del style="font-weight: bold; text-decoration: none;">&quot;</del>Group expressions<del style="font-weight: bold; text-decoration: none;">&quot; </del>box, type the expression <del style="font-weight: bold; text-decoration: none;">&quot;</del>RECNO('customer')<del style="font-weight: bold; text-decoration: none;">&quot;</del>, without the outer quotes, into the top box. Optionally, you may select the <del style="font-weight: bold; text-decoration: none;">&quot;</del>Start each group on a new page<del style="font-weight: bold; text-decoration: none;">&quot; </del>check box to start each new virtual detail band on a new page. Click OK to close the dialog box.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># In the <ins style="font-weight: bold; text-decoration: none;">"</ins>Group expressions<ins style="font-weight: bold; text-decoration: none;">" </ins>box, type the expression <ins style="font-weight: bold; text-decoration: none;">"</ins>RECNO('customer')<ins style="font-weight: bold; text-decoration: none;">"</ins>, without the outer quotes, into the top box. Optionally, you may select the <ins style="font-weight: bold; text-decoration: none;">"</ins>Start each group on a new page<ins style="font-weight: bold; text-decoration: none;">" </ins>check box to start each new virtual detail band on a new page. Click OK to close the dialog box.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># Double-click on the Page Header separator bar, and set the Page Header height to .25<del style="font-weight: bold; text-decoration: none;">&quot;</del>, and select the <del style="font-weight: bold; text-decoration: none;">&quot;</del>Constant band height<del style="font-weight: bold; text-decoration: none;">&quot; </del>check box.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># Double-click on the Page Header separator bar, and set the Page Header height to .25<ins style="font-weight: bold; text-decoration: none;">"</ins>, and select the <ins style="font-weight: bold; text-decoration: none;">"</ins>Constant band height<ins style="font-weight: bold; text-decoration: none;">" </ins>check box.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># Double-click on the Page Footer separator bar, and set the Page Footer height to .25<del style="font-weight: bold; text-decoration: none;">&quot;</del>.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># Double-click on the Page Footer separator bar, and set the Page Footer height to .25<ins style="font-weight: bold; text-decoration: none;">"</ins>.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># To simulate a two-page <del style="font-weight: bold; text-decoration: none;">&quot;</del>detail band,<del style="font-weight: bold; text-decoration: none;">&quot; </del>set the Group Header for the RECNO() band height to 10 inches (for portrait page layout), and the Detail Band height to 10 inches. These are accessed by double-clicking the separator bar for each band. Select the <del style="font-weight: bold; text-decoration: none;">&quot;</del>Constant band height<del style="font-weight: bold; text-decoration: none;">&quot; </del>check box for each band as well, then click OK to close the dialog box.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># To simulate a two-page <ins style="font-weight: bold; text-decoration: none;">"</ins>detail band,<ins style="font-weight: bold; text-decoration: none;">" </ins>set the Group Header for the RECNO() band height to 10 inches (for portrait page layout), and the Detail Band height to 10 inches. These are accessed by double-clicking the separator bar for each band. Select the <ins style="font-weight: bold; text-decoration: none;">"</ins>Constant band height<ins style="font-weight: bold; text-decoration: none;">" </ins>check box for each band as well, then click OK to close the dialog box.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># To simulate a three-page <del style="font-weight: bold; text-decoration: none;">&quot;</del>Detail Band,<del style="font-weight: bold; text-decoration: none;">&quot; </del>follow Step 9 above but also set the Group Footer band height for the RECNO() band to 10 inches as well and select the <del style="font-weight: bold; text-decoration: none;">&quot;</del>Constant band height<del style="font-weight: bold; text-decoration: none;">&quot; </del>check box, and then click OK to close the dialog box.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># To simulate a three-page <ins style="font-weight: bold; text-decoration: none;">"</ins>Detail Band,<ins style="font-weight: bold; text-decoration: none;">" </ins>follow Step 9 above but also set the Group Footer band height for the RECNO() band to 10 inches as well and select the <ins style="font-weight: bold; text-decoration: none;">"</ins>Constant band height<ins style="font-weight: bold; text-decoration: none;">" </ins>check box, and then click OK to close the dialog box.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Place some of the fields added when the Quick report was made at the top and bottom of each of the bands sized in Step 9 and optionally Step 10.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Place some of the fields added when the Quick report was made at the top and bottom of each of the bands sized in Step 9 and optionally Step 10.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Preview the report. Each of the 10-inch bands print on a different page, but since the group breaks on RECNO() the group header and footer will also print information from that detail record alone.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Preview the report. Each of the 10-inch bands print on a different page, but since the group breaks on RECNO() the group header and footer will also print information from that detail record alone.</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/168527&diff=290408&oldid=prev
X010: Text replacement - ">" to ">"
2020-07-20T19:29:42Z
<p>Text replacement - ">" to ">"</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:29, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l53">Line 53:</td>
<td colspan="2" class="diff-lineno">Line 53:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Visual FoxPro has a limitation on the length of report bands. The maximum length for a single band is the page length.<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Visual FoxPro has a limitation on the length of report bands. The maximum length for a single band is the page length.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>It is possible to create a report that simulates a detail band with a length greater than the length of a single page. This requires setting up a dummy data grouping on RECNO(<table with records repeating in the detail band<del style="font-weight: bold; text-decoration: none;">&gt;</del>), and creating what amounts to a larger &quot;virtual&quot; Detail Band comprised of the RECNO() Group Header, the actual Detail Band, and the RECNO() Group Footer. See the MORE INFORMATION section of this document for details.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>It is possible to create a report that simulates a detail band with a length greater than the length of a single page. This requires setting up a dummy data grouping on RECNO(<table with records repeating in the detail band<ins style="font-weight: bold; text-decoration: none;">></ins>), and creating what amounts to a larger &quot;virtual&quot; Detail Band comprised of the RECNO() Group Header, the actual Detail Band, and the RECNO() Group Footer. See the MORE INFORMATION section of this document for details.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/168527&diff=280235&oldid=prev
X010: Text replacement - "<" to "<"
2020-07-20T16:08:11Z
<p>Text replacement - "<" to "<"</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:08, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l53">Line 53:</td>
<td colspan="2" class="diff-lineno">Line 53:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Visual FoxPro has a limitation on the length of report bands. The maximum length for a single band is the page length.<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Visual FoxPro has a limitation on the length of report bands. The maximum length for a single band is the page length.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>It is possible to create a report that simulates a detail band with a length greater than the length of a single page. This requires setting up a dummy data grouping on RECNO(<del style="font-weight: bold; text-decoration: none;">&lt;</del>table with records repeating in the detail band&gt;), and creating what amounts to a larger &quot;virtual&quot; Detail Band comprised of the RECNO() Group Header, the actual Detail Band, and the RECNO() Group Footer. See the MORE INFORMATION section of this document for details.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>It is possible to create a report that simulates a detail band with a length greater than the length of a single page. This requires setting up a dummy data grouping on RECNO(<ins style="font-weight: bold; text-decoration: none;"><</ins>table with records repeating in the detail band&gt;), and creating what amounts to a larger &quot;virtual&quot; Detail Band comprised of the RECNO() Group Header, the actual Detail Band, and the RECNO() Group Footer. See the MORE INFORMATION section of this document for details.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/168527&diff=88272&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:34:03Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB168527"></span>How to simulate a detail band that is longer than the length of one page in Visual FoxPro =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 168527<br />
<br />
Article Last Modified on 2/12/2007<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft Visual FoxPro 3.0 Standard Edition<br />
* Microsoft Visual FoxPro 3.0b Standard Edition<br />
* Microsoft Visual FoxPro 5.0 Standard Edition<br />
* Microsoft Visual FoxPro 5.0a<br />
* Microsoft Visual FoxPro 6.0 Professional Edition<br />
* Microsoft Visual FoxPro 7.0 Professional Edition<br />
* Microsoft Visual FoxPro 8.0 Professional Edition<br />
* Microsoft Visual FoxPro 9.0 Professional Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q168527<br />
<br />
</div><br />
<div class="summary_section"><br />
<br />
== SUMMARY ==<br />
<br />
Visual FoxPro has a limitation on the length of report bands. The maximum length for a single band is the page length.<br /><br />
<br /><br />
It is possible to create a report that simulates a detail band with a length greater than the length of a single page. This requires setting up a dummy data grouping on RECNO(&lt;table with records repeating in the detail band&gt;), and creating what amounts to a larger &quot;virtual&quot; Detail Band comprised of the RECNO() Group Header, the actual Detail Band, and the RECNO() Group Footer. See the MORE INFORMATION section of this document for details.<br />
<br />
</div><br />
<div class="moreinformation_section"><br />
<br />
== MORE INFORMATION ==<br />
<br />
To create a sample report demonstrating this behavior, complete the following steps:<br />
# Create a new report.<br />
# Make a Quick Report using Report/Quick Report from the Visual FoxPro menu.<br />
# Select the Customer table in the VFP\Samples\Data directory for Visual FoxPro versions 3.0 and 5.0 or the home(2)+&quot;data&quot; directory for Visual FoxPro 6.0 when prompted for a table.<br />
# From the Quick Report dialog box, select the right-most &quot;Field layout&quot; button, and then click OK.<br />
# In the Report Designer, set up a data grouping. This is done by selecting Report/Data Grouping from the menu. In Visual FoxPro 9.0, select Report/Optional bands from the menu.<br />
# In the &quot;Group expressions&quot; box, type the expression &quot;RECNO('customer')&quot;, without the outer quotes, into the top box. Optionally, you may select the &quot;Start each group on a new page&quot; check box to start each new virtual detail band on a new page. Click OK to close the dialog box.<br />
# Double-click on the Page Header separator bar, and set the Page Header height to .25&quot;, and select the &quot;Constant band height&quot; check box.<br />
# Double-click on the Page Footer separator bar, and set the Page Footer height to .25&quot;.<br />
# To simulate a two-page &quot;detail band,&quot; set the Group Header for the RECNO() band height to 10 inches (for portrait page layout), and the Detail Band height to 10 inches. These are accessed by double-clicking the separator bar for each band. Select the &quot;Constant band height&quot; check box for each band as well, then click OK to close the dialog box.<br />
# To simulate a three-page &quot;Detail Band,&quot; follow Step 9 above but also set the Group Footer band height for the RECNO() band to 10 inches as well and select the &quot;Constant band height&quot; check box, and then click OK to close the dialog box.<br />
# Place some of the fields added when the Quick report was made at the top and bottom of each of the bands sized in Step 9 and optionally Step 10.<br />
# Preview the report. Each of the 10-inch bands print on a different page, but since the group breaks on RECNO() the group header and footer will also print information from that detail record alone.<br />
<br />
NOTES:<br /><br />
<br /><br />
<br />
* It is not necessary to have the Group and Detail bands exactly 10 inches, but the sum of the height of each of these individual bands plus the Page Header and Page Footer heights should be around 10.5 inches.<br />
* Having report fields that print memo data or are set to stretch can cause unexpected results with the above scenario.<br />
<br />
<br />
</div><br />
Keywords: kbdesigner kbhowto KB168527<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd