report on full page

[mapeirce]

I am designing an Invoice report using the VFP report designer. I would like to have a static length detail section with a box around it, but I am unsure how to make sure that the bottom of the box is at a particular spot on the page. I have some summary information that I print at the bottom of the invoice, so I have group footers for that.
Is it possible to programmatically evaluate/set the band height during run time?

ex:
header info
-------------
|detail |
| detail |
|detail |
| detail |
| detail |
| |
| |
| |
--------------
footer info

any ideas?

Thanks
Melinda

 

[craigsboyd]

The only thing I can think of given your example is to figure out how many records it would take to fully fill out the detail section to the desired length and then add or subtract records from the reports datasource prior to running the report...such as in your example you would need to append 3 blank records to the end of the datasource.

Slighthaze = NULL
_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[ramani]

Hi Melinda,

I assume you have completed everything except the box around the detail lines....

Open the report in report desgner,
Make the header band slightly larger
header info
->
-------------
|detail |
| detail |
|detail |
| detail |
| detail |
| |
| |
| |
--------------
->
footer info

Same way make room in the footer band top area.

Now from the report control toolbar.. choose the rectangular box. Click on the Header area (where blue color is shown in above example) and with mouse key pressed down.. drag upto .. footer area top line place

(In fact the detailed band is surrounded by the box.. making sure the starting is in header area and the ending is in footer area.)

Now save the report and see the preview. The box will come as you expect.

There more lines explaining here than the actual work involved.



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[mapeirce]

Yes, that creates a box around the detail section, but the box still grows and shrinks with the detail. I need the box to be a set height, and just let the detail lines fill in as needed.
Unfortunatly, I can't do much with the recordset that the report is printing from. I can't force a certain number of records, and besides, one of the fields is a memo 'strechy' field, so I don't know how long it will be, and wouldn't be able to determine the correct number of blanks to add.
I was hoping that there would be a way to determine what the height of the band is and somehow create a function that can adjust the height of the footer band accordingly.

thanks

 

[ramani]

Hi

The box will grow in size to go up the bottom of physical page, if you are using the box draged upto the footer band.

Probably you left the band at the Group footer. You should transfer the group footer contents to the page footer area, since Invoice forms will print each new group in a new form. So set the group to start at new page as well.

Once the box is touching the footer area, it will stretch as you need.


____________________________________________
Ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

When you ask VFP questions, please add VFP version.

 

[jimstarr]

Hi Melinda,

If you have the box extend from the page header band down into the page footer band it will contain all the detail records, and will remain a fixed height.

Jim

 

[mapeirce]

That works... I hadn't planned to encompass the information in my group header in the same box, but with some creative white filled boxes I could cover up the lines where I didn't want them.

Thanks bunches...

MAP

 

[jimstarr]

Just a thought... If you have only 1 group header per page you can make it a page header instead. Then it's easily kept outside the box. -Jim