How to correctly make a box on a VFP-Report 2

[Koen Piller]

Hi,

I need to make on a report a box containing nNumber of fields.
When I set the top line of the box just above the detail band and the bottom line of the box
just over the bottom of the detailband I get a box high as the detailband the records which fit into that box are printed inside the remaining outside.
Increasing the box with just 1 pixel in height will result in a box spanning the whole page.
See picture enclosed. (Have enlarged the picture of the box in the report designer here, to make things more clearly.
Anybody who can advise me how to arrange a box with all the records, inside?
It seems to me this is also an old similar matter, which was by that time solved with instructions of Mike.
This one I can't get it working.
Regards,
Koen

 

[mjcmkrsr]

 

[mjcmkrsr]

..
and a slightly pimped up version
hth
MarK

 

[Koen Piller]

Mark,
I must say a fine example of thinking out of the box.
Unfortunately this is not the layout I am looking for.
I was looking for a box around a couple of records and below that, in a second band (?) no box but some other records.
Unfortunately VFP does not allow this, a group by with a streched box in detail band with a second detail band without a group by.
I have now changed my layout into 2 reports.
Regards,
Koen

 

[Olaf Doschke]

As said you could simply set the "print when" condition of the box or lines. The same goes for report fields, so in the same bands you already have you print something else depending on the value defining the group.

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name

 

[mjcmkrsr]

 

[mjcmkrsr]

Hi Koen

I was looking for a box around a couple of records and below that, in a second band (?) no box but some other records.
Unfortunately VFP does not allow this, a group by with a streched box in detail band with a second detail band without a group by.

Don't give up that fast. What about this (please download the files)
hth
MarK

 

[Koen Piller]

Hi Mark,
Looks nice I must say. Unfortunately it does not comply with my design
The listings below the boxes do not make sense (in my layout). If you could put them in the very last band it would be good.

Regards,

Koen

 

[mjcmkrsr]

Hi Koen

Please note in the report in the 2nd Band all data from cDag8 should be listed.

That's what I did!

Unfortunately it does not comply with my design The listings below the boxes do not make sense (in my layout).

Now what IS your design? Furthermore it's what you were asking for (see 1st quote) - or do I miss something? Perhaps you could provide some living data and draw a sketch of what you're after.

If you could put them in the very last band it would be good.

What do you understand by "very last band" - is it the Detail Band Footer, the Group Band Footer, the Page Footer or ...? You then just may want to drag and drop the data control there.
hth
MarK

 

[mjcmkrsr]

...

and a sketch of how to use variables in a report

hth

MK

 

[Koen Piller]

Mark!

Good morning!, I have just had to put a print when = no in the visitors field and that's it.

I shall quickly implant this in my live data, remove the 'vistors' and finalize the report.

Do you have any idea what this was for?
A group of people are scheduled for a daypart viz morning, anood, evening. They can be scheduled once or several times a day or several days.
Also they can be opted for backup-reserve.
So I will list Monday to Sunday, group those for morning and for anoon and evening. That's where the box are for.
Below that a simple list of backup-reserve's.
After al a very simple sheet of paper showing who is when scheduled.
Thanks a lot sir, for your first correct tip how to construct that box. And now your tip how to show the backup-reserve's
I like the idea to ut the group into a memo-field instead of different fields, which did not look so neat and nice as with a memo.
Thanks again.
Koen

P.S. I was never be4 involved in a thread of 68(!) messages. What a mess. Now it is fixed.

 

[mjcmkrsr]

Hi Koen,

Thanks. Pleased to read that it worked out for you.

What a mess.

No - you learned a lot and me too!

MarK