Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid with sorting capabilities
Message
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00445104
Message ID:
00446371
Views:
19
>> Really pity, that Report's footer doesn't allow stretch with overflow and remove line if blank. I'm quite confident, that hacking frx doesn't give me desired result... I'll try it tomorrow anyway...
>
>When I need that, I create a dummy Group By item (something like EOF()) and use the group footer for that instead of the report summary band. (Or are you talking about the page footer?)

Hi Barbara,

Yes, I'm talking about Page Footer. Page Footer doesn't allow to stretch with overflow and remove record if blank. If it would, my situation would be much much easy.

But now I'm really proud of myself :) and my manager just called me 'clever girl' :) I won! I fight this stupid over-complicated report. The problem was with inserting blank pages if the group ends on the odd page and in this case I need to insert a clean blank page (this report prints on both sides of paper and each group should start from the new page).

I tried lots of different ideas without luck. So, finally I ended with inserting one additional record, if group ends on odd page. This report uses Situs order, which is ccode+city+... At the enter of the group I call a function. This function checks, if it's an odd page, and if it is, it inserts ccode, alltrim(city)+'ZZZ', street='zzzzzzzzzz'. I use few other tricks here.

Anyway, finally it produces a blank page, where it should be inserted. The only problem here, that the report should be printed twice (first time it could be print to dummy file). Also there could be potential multi-user problems, but this is very unlikely.

Uf, really glad, it's over...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform