BUG: Multicolumn Reports with Groups Break Incorrectly
ID: Q109234
|
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 :
|
