Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Detail Band Not Using Full Page 2

Status
Not open for further replies.

FoxRookie

Programmer
Sep 27, 2001
17
US
In our client information module we have a ton of demographic info and then six embedded forms that are one-to-many, thus, requiring a multi-banded report. This is no problem, I have used a technique to add all the objects I need in the detail band to cover all the child forms and then conditionally print based on the group designation. This has always worked well until this particular module. The layout is a short page header to reprint client name, etc, a client group header that is very lengthy as it contains a lot of admission information, but will only print once as this report is for one client at a time. The second group header is very short with only a title to the detail form, which conditionally displays differing titles. The detail band is quite lengthy as it simulates six detail bands, but when outputting the band only prints about 4 to 8 lines per record. I would expect that the report would output the detail section with many lines of info as there is plenty of room on each page after the first group header is printed. I could see having four to six record bands print per page, BUT, what I am getting is one record-band or maybe two per page and a very lengthy report, which is unacceptible as this must become part of the medical record. I placed markers at the beginning of the band and at the end to see if I had an object that did not float or something and the markers appropriately surround the record info and then half the page is left blank. I have messed with this for six hours and cant figure out why the band moves to a second page when there is plenty of room on the current page. Additionally there is a page footer with a single line of info. And a group footer for the client group that only prints at the end of the report. Can anyone help me out? :)
 
You say the detail band is quite lengthy. Are you using the "remove line if blank" feature for the lines which aren't supposed to print?

Jim
 
Thanks for the quick reply. Absolutely I am using remove line if blank and i double checked all objects to see if one may not have been set, but all are set correctly
 
With each record in your input table the report writer looks to see if it has enough room on the current page to hold the detail band. This is done before it knows how many detail lines are to be removed because they are blank. So if your detail band contains 20 possible lines you'll skip to a new page if there are only 15 lines left on the page, even though only 2 of the 20 will actually be printed.

You'll need to shorten your detail band, possibly by using a lot of IIF's instead of multiple lines with "print when."

Jim
 
I get same/similar problem.

I have page header 2.6146 inches long.

My detail band is 5.15 inches long.

Footer band is .1667 inches.

In Detail band, I'm printing out a couple of memo fields with the stretch option. Then length of these field is far shorter than 5.15 inches.

I only have one record in my test sample. The results print on two pages. (without any visible detail information on second page) If I shorten the Detail band by .15 inch to 5.00 inches (with absoulutely no other changes), it prints on single page. I am using 11 inch paper type.

For those who may wonder "Why not just shorten the detail band?". I want to put more fixed text there (like a pre-printed form) Right now, I have most of that stripped out and I have found that it seems to be dependent on the length of the detail band alone. I am still working with some of the other factors to see how anything else affects it. (I presume eliminating the page header would get me 2.6 inches for example)

I didn't have this problem with VFP 6.0.

I am reviewing issues and report anything else I find.
 
Again, I don't know how similar my problem is to yours, but I have detail bands that are near or over one page.

From my experimentation, if I have a simple report with a detail band say 8 inches long with a simple single field printing. It is a memo field which prints to a length of about 5 inches. The field is marked stretch with printing. Since the band is 8 inches and the field streched almost 5 inches, it prints an additional page at the end of the report. Any field after that position that is marked float will go on the next page even if it would fit on the current page. (Remember, were only 5 inches down the page so far).

The one way to fix it is making the detail band the full size of the page and marking it 'constant band height'. In my case, there may often be multiple pages for a detail line and that truncates anything past the first page.

To me this appears to be a 'feature' with no ready workaround and as I said previously, did not seem to be the way the VFP6 worked.
 
Hi

I am having the same problem and just wopndered whether you guys had found a fix. I never had this problem in VFP6.0. Now my reports prints 2 pages the second one is blank. My detail band contains one memo field. I canot make the page a constant height as the length of the field varies and can be a few lines to several pages.

Did anyone resolve this problem??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top