Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Don't print anything if field in group footer is empty
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00601732
Message ID:
00602216
Views:
30
As I said in the other post, I got a project that has a higher priority today, but as soon as I can get back to that other report, I will give this a shot and let you know how it goes.

Thanks for looking into it,

Michelle


>Okay ... this got the best of me and I had to play around. If you don't have any stretchable fields (other than the note field in the group footer) ... here's what I "think" you can do (I didn't test it fully so it's just theory at this point) ...
>
>Create a variable (nLines) to count the number of lines per page. Figure out how many lines fit on a page (maxlines) and then add a field object at the top of the group footer with the following expression:
>
>replicate(chr(13), - nLines)
>
>Make it one line tall and mark it as stretchable. Set the printwhen logic to only print if the notes field isn't empty. Directly underneath that object, add the field object for the notes field. Make it stretchable, float, and change the printwhen logic to only if it's not empty.
>
>The group footer band should only be as tall as the two objects ... not a full page. The concept is that the first object in the group footer stretches and takes up all the rest of the room on the page so the second object which is the real notes object ends up flowing over to the next page and prints.
>
>Again ... this is just theory ... but I think it might work.
>
>Good Luck ... and let me know if it works out!
>Cathy
Previous
Reply
Map
View

Click here to load this message in the networking platform