Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group Header Showing Last Group Info
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01351054
Message ID:
01351469
Views:
23
>VFP9SP2 ReportBehavior 80
>
>I have a weird issue wherein the page and group headers of the first page of a new group are printing the OLD group header information. If this new group spans multiple pages, the second page will show the correct header info.
>
>This problem doesn't appear to be the same as http://cathypountney.blogspot.com/2007/11/gotcha-serious-report-bug-with-data.html
>
>Just in case the problem is related to the above mentioned bug, I turned off the option to reprint page headers and that did not fix it.
>
>Also, this report only has a 1 to many relationship with one table (it has many 1 to 1 relationships with other tables), yet it gives very, very wacky results unless I put the expression in the detail band. Without the expression in the detail band the report will have an infinite number of pages, and the header band will only ever show the detail from the first header record.
>
>If I set ReportBehavior to 90 I get the same result.
>
>I just tried this report in VFP8 and I get an infinite number of pages (same as VFP9 until I change the detail expression band). I'm assuming that's the vital clue?
>
>
>Any ideas?

My guess is that the tables aren't related correctly, or the wrong table is selected when you run the report. How are you setting up the tables, indexes, relations, skip, etc? What table is activate when you run the report .. the parent or the child? Does the expression in the group header include the table reference?
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform