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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text Object in Fixed Place 3

Status
Not open for further replies.

clapag22

Programmer
Mar 9, 2001
239
US
CR 8.5

I am printing a check. It's portrait 8.5" x 11" and is perforated 1/3 of the way down and 2/3 of the way down (check on top and then two duplicate stubs - one we keep, one we send with the check). The stub contains detailed info about what customers used a service, etc. Sometimes the stub will have one detail line, sometimes 5 - 10.

Anyway, I need to put a message on the bottom of the middle stub (the one that stays attached to the check) but I always want it in the exact same spot regardless of how many detail lines there are. Currently, if there are only a couple of detail lines, it's printed way too high. I guess what I need is some sort of dynamically sized blank section.

Any ideas?

Thanks,
Craig
 
Rather than trying to describe requirements with text, please try to provide some visuals.

Since you need something to always print in the same location, and only in the middle section, you might create another section (right click any section and select insert section below - you gave no idea what section is printing where) place the text you need in the upper section, and use the Underlay Following Section to make sure that it's always in the same location.

Wild guess based on very little layout information.

-k
 
You haven't explained how you have created the three sections on the page. One approach would be to create the top third by using a manually sized group header section, with the middle section based on the detail records. The third section might be a subreport of those same details placed in the group footer and linked to the main report by the group field. In this case, you could size the middle section in the following way. First determine how many lines would constitute a full section. Let's say it is 18. Then replace one of your recurring detail fields, e.g., {table.field} with a formula like:

if {#cntwingrp} = count({table.field}, {table.id}) then
{table.field} + replicatestring(chr(13),18-count({table.field},{table.id})) +
"My last line in the middle section" else
{table.field}

...where {#cntwingrp} is a running total created with the running total expert: Select {table.id}, count, evaluate for each record, reset on change of group (table.id). Place this formula on the report canvas instead of {table.field} and then right click on it->format field->common->check "Can Grow". This will force multiple returns on the last record to create the space necessary before the last line prints.

This assumes that the number of detail records will not exceed 18.

If this approach doesn't work, please provide information on how you are creating the three sections.

-LB
 
Thanks to both of you for your help. I used one of your responses to format the wording on the correct spot and the other response to keep the spacing between the duplicate detail sections the same regardless of how many detail lines exist. At the time I thought I was being thorough regarding the info in my initial request but looking back I realized I should've mentioned I have two break groups; one on check number and the other on my "repeater" field (which allows me to print the detail section twice w/o a subreport).

Thanks again,
Craig
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top