Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Yikes! Same Report Twice on One Sheet of Paper???
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00664160
Message ID:
00664198
Views:
34
Thanks for the idea Cathy. I'm trying it now. However, I have a question:

1: How do I stop the report from ejecting the page after I print the top half so I can issue the report command again to print the bottom half? I have _peject=NONE already verified.

Tracy


>Since you have a group based on the Receipt number .. you can do it, but it's tricky.
>
>You have to assume that all items in the detail band are butted tight up against the top of the detail band and there is no extra white space at the bottom of the detail band. You also have to assume that there are NO stretchable fields in the Detail band. And the big one ... no receipt can overflow to the next 1/2 page .. it must be contained in one half sheet.
>
>If you can adhere to those rules .. create a report variable called nLines that is a Counter that resets at the end of each Receipt Number. In the Group Footer, add a field object with the following expression: REPLICATE(CHR(13), 99-nLines) .... where "99" is the maximum number of lines that can fit on a receipt. Mark this field as stretch with overflow. This forces enough blank lines in the group footer to make up for empty lines on the receipt.
>
>This method makes a lot of assumptions .. especially the one about not overflowing to a second receipt form. If this isn't acceptable .. then you have to fudge a cursor to print from where it has exactly the right amount of detail lines for each "form" .. even if they are blank. But it still assumes that no fields are marked as stretch with overflow!
>
>Cathy
>
>
>>I have a report that is based on a parent-child relationship. It is a receipt grouped on the receipt number with detail items. It is 8.5 x 5.5 inches and used to print on perforated dot-matrix sheets. Now the users have purchased perforated laserjet sheets so I need the ability to print the same report twice on the same sheet of paper where the first printing will print at the top (already finished that part successfully) and the 2nd printing will start at just below the middle of the SAME page (which would be just below the perforation). I have not figured out how to do the 2nd printing yet. How to do this since you can only have 1 detail band? I already have 1 grouping also. Any ideas?
>>TIA!!!!!
>>Tracy
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform