BUG: Multicolumn Reports with Groups Break Incorrectly
ID: Q109234
|
<![CDATA[
2.5x 2.60 2.60a | 2.50B
WINDOWS | MACINTOSH
kbtool kbprint kbbuglist
--------------------------------------------------------------------
The information in this article applies to:
- Microsoft FoxPro for Windows, versions 2.5x, 2.6, 2.6a
- Microsoft FoxPro for Macintosh, versions 2.5b
--------------------------------------------------------------------
SYMPTOMS
========
A multiple column report containing data groupings that force page and
column breaks behaves incorrectly.
STATUS
======
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
MORE INFORMATION
================
The following example shows how the report writer fails to break the
page when the primary group changes. It requires that a secondary
group be created which begins a new column when it changes.
Steps to Reproduce Behavior
----------------------------
1. In the command window issue the following SQL query.
SELECT state, city, company ;
FROM customer ;
ORDER BY state, city, company ;
INTO CURSOR query
2. Open a new report.
3. Choose the Page Layout... item from the report menu and change
columns to 2 in the page layout dialog.
4. Create a primary data grouping on the state field. In the Group Info
dialog check the box labeled 'New Page' in the region labeled 'When
Group Changes, Begin.'
5. Create secondary data grouping on the city field. Check the box in
the Group Info dialog labeled 'New Column' in the region labeled
'When Group Changes, Begin.'
6. Create field expressions for state and city in the corresponding
group headers.
7. In the detail band create a field expression for company.
8. Preview the report and note that information from two different
states, Alaska and Alabama, appear on the same page.
RESOLUTION
==========
Do not use the New Column option in a data grouping.
Additional reference words: 2.50 2.50a 2.50b 2.60 2.60a FoxWin FoxMac
RWriter buglist2.50 buglist2.50a buglist2.50b buglist2.60 buglist2.60a
KBCategory: kbtool kbprint kbbuglist
KBSubcategory: FxtoolRwriter
]]>
Keywords :
Version :
Platform :
Issue type :
Last Reviewed: June 27, 1995