Tableframe in report skips records on next page 1

[rmcmorris]

Using PDX 8. I have a report which has a tableframe in the report header. If the table has enough records, the tableframe continues on the next page of the report. If the report is printed, one or more records are not printed from the first page to the second. For example, if I have 100 records, records 1-30 might be printed on the first page, and then 33-100 printed on the second. Records 31 and 32 do not print. If the report is viewed in print preview, all of the records are displayed correctly from page to page.

I have detached the tableframe header and reduced the tableframe to one record, as suggested by another user. This does not seem to help.

Any ideas??

Thanks,

Regan

 

[Langley]

I don't know if this works with tableframes, but try adding a group band and then select 'group by number of records'. Choose a number that fits the space, then place a pagebreak on the lower half of the band. Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[rmcmorris]

A Group Band must be contained within the Page Band. My problem is that the tableframe is in the Report (Header) band, so I cannot use a Group Band here.

Another clue is that in print preview, the last record on the first page (say record 21) is displayed, with page 2 starting at record 22. But when printed, the first page only displays 20 records, with page 2 starting at record 22. So I am wondering if it might be a printer driver or setup issue?

 

[rmcmorris]

Well, I found a solution, sort of. It seems that if I change the Page setup option "Design for (Printer|Screen)" to "Screen" rather than "Printer" (File|Page Setup from menu) then my data all prints out, but now, the last record on the first page is repeated as the first record on the second page. For example, if my last record on Page 1 is Record 21, the first record on Page 2 will also be Record 21. Besides the disadvantage of the repeated record, some of the lettering is spaced strangely, with combinations of letters being squished together in places. Looks a bit odd.

I think this really might be some type of printer driver issue. We use networked printers which probably utilize Windows NT drivers.

I suspect that Paradox tries to calculate how much data will fit on each page and then it sends the data to the printer. But why there is a difference between print preview and the actual printed copy is beyond me.

 

[Langley]

Version 8 has some printing issues. If you are using an HP driver, then you should try an older one (HP LaserJet2 always works). And make sure your patches are applied. Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[rmcmorris]

I cannot change the drivers, as they are part of a network printer controlled by the company IT group.

However, I do think that I am going to upgrade the entire application to PDX10 at the first of the year.

 

[footpad]

rcmorris,

Also, you may want to try setting the record band to unbreakable. To do so:

1. Right-click the record band.
2. Choose Properties
3. Select the Run Time tab.
4. Remove the checkmark next to Breakable.
5. Choose OK.

That may help.

Hope it does...

-- Lance

 

[Langley]

Lance, his tableframe is outside of the record band (which may be part of the problem - I never had good luck doing that). Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[footpad]

Mac,

Yikes! That's problematic, for there's no way to consistently predict the height of the band.

I think I'd need to tinker with the report to see if there's a way to control it.

-- Lance

 

[adelson007]

Had this problem in 8, migrated to 10, still have the same problem. Found that if I elliminated "text wrap" from all areas of the report and show only one record in design mode that this has helped.

 

[rmcmorris]

EXCELLENT!! This was a perfect clue that has resulted in correcting this problem!! Thanks so much.

In the tableframe, I had two fields that had text wrap enabled. I unchecked text wrap, but was still having a problem. Above the tableframe, I had some other fields that had "Delete when empty" enabled. I unchecked this option and ran again. This time, all of the records print correctly!!

It dawned on me that what the issue is here is that the spacing of the Record Band must remain constant up to the point to where the tableframe begins. That means that there can be no other objects above the table frame which will change in size, such as text wrap, as Adelson pointed out, or "delete when empty" fields. The exception seems to be memo fields, which appear to resize (fit height) and do not seem to affect the tableframe below.

Thanks all for your suggestions. I hope someone else gets some useful ideas from this thread.

 

[rmcmorris]

Correction above. I said the spacing of the "Record Band", when I meant the spacing of the "Report Band". Also, I have thought another good approach would be to pin the vertical of all the objects above the tableframe. That way the tableframe would always start at the same spot in the Report Band.

 

[Langley]

Great - and thanks for posting the solution! Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us