Subreport- Keeping DBmemo with other items

rbuser

Scenario;

Sub report with three fields;

line item number : integer
item description : string (using a DBmemo component)
cost : currency

Sub report is set as child, keep together = true. Main report detail report = Dynamic Height, and has header, footer.

Problem;

I need line wrapping on the item description, so I'm a using DBmemo in the sub report. If I just use a string field, I
get a single line without wrapping, but don't have the problem listed below.

When I use the DBmemo, in most cases it works, but occasionally, I get the DBmemo text printing at the bottom of a page
with the line item number and cost printing at the top of the next page. So, they are out of synch.

bottom of page;

19 This is the description for line item 19 $100.00
and the text wraps nicely when using a
dbmemo component when it won't fit on a
single line.
20 This is the description for line item 20 $200.00
21 This is the description for line item 21 $500.00
This is the description for line item 22


next page:

22 $700.00


In addition, I have line components to make it replicate a grid. The line components stay with the dbmemo component. So,
at the top of the second page, the "grid" is not printed for the "lost" line item from the previous page.

Thanks for any advice!

John

rbuser

UPDATE:

OK...I don't know why this fixed it, but it did...


I put a border around both the item number and cost fields, then turned off the border, and suddenly, all is working.

Any explanation would be greatly appreciated.

Thanks,

John

rbuser

John,

My guess is that by toggling the border, you changed the object's height
slightly and that made the difference.

If you have both static and stretchable objects on the same row and you want
to ensure that they stay together, put them all within a region.

Bob

rbuser

Bob,

Thanks! I ultimately will have to do this.

John