Microsoft KB Archive/143309

= FIX: The Report Designer ignores the Constant Band Height setting =

Article ID: 143309

Article Last Modified on 2/22/2005

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q143309



SYMPTOMS
The Report Designer ignores the Constant Band Height setting of the Detail band when "Remove Line If Blank" is selected for the expressions in a single-column report and there are blank fields in the record source table.



WORKAROUND
For more information about preserving constant band height when some fields are empty in a single column report, please see the following article in the Microsoft Knowledge Base:

143063 How to Remove White Lines in Mailing Labels and Reports



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in Visual FoxPro 5.0 for Windows.



Steps to Reproduce Problem
 Using the Report Designer, create a single column report based on the Customer table located in the Samples\Data subdirectory.  Place the following fields in the Detail band of the report:      cust_id city region country phone fax  Double-click each expression in the Detail band. Then choose the Print When button, and select "Remove Line If Blank." Double-click the Detail band itself, and check "Constant Band Height." Preview the report and look at the record for Cust_id = "ANTON". Notice that the fax number is missing. "Remove Line If Blank" worked; and "Constant Band Height" did not have any effect.</li></ol>

Keywords: kbbug kbfix kbvfp500fix KB143309

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.