Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Group not overflowing to new page
Message
From
03/02/2012 08:52:15
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Miscellaneous
Thread ID:
01534311
Message ID:
01534393
Views:
57
Sergey,

Thanks for the link to get the hotfix. We are both up to the latest version mentioned by Tamar. I also added SET REPORTBEHAVIOR 80. Unfortunately, this did not resolve my issues.

I rewrote the report and moved all the Text & Fields that were set 'Fix Relative To Bottom' to the Summary band which I added for that. This leaves only the floating dynamic Field controls in the Group Footer. This has the appearance of working. That might only be because the reports I've tested no longer overflow with 1/2 the controls moved to the summary. Although the summary band does not get counted as a new page when it prints on another page. More testing to be done.

If this all fails, we can try Crystal Reports or R&R Report Writer.

Thanks for your help on this.

>Did you try with ReportBehavior=80?
>
>You may also want to apply the latest hotfix http://www.berezniker.com/content/pages/visual-foxpro/vfp-90-versions
>
>>
>>Yes. When I look at the About screen, it says SP2. The version is 9.00.0000.5815
>>
>>
>>
>>>Did you apply VFP9 SP2 ?
>>>
>>>>
>>>>I have 1 application that is still compiled in VFP6 SP5. The reason for this is because when we try convert and compile it in VFP9, the report will not function correctly. In the Group Footer we have several dynamic Field controls. These fields will contain Comments and tend to stretch. If blank, they are removed. In VFP6 when the 6 fields contain excess test, they continue onto the next page. Along with all the other controls that are set: Fix Relative to Bottom of Band. But when we convert/compile in VFP9, they just run off the bottom of the page and most are not even printed since the page is only so long.
>>>>
>>>>I've tried to adjust the report to have all the Group Footer data in the Summary, but this gave me the same results. The bands are not overflowing to a new page. Is there a setting I've not been able to find?
>>>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform