$%^&#@! Alignment in Subreports

K

Kevin Sprinkel

I have struggled putting a complex report together
consisting of eleven subreports. After prototyping the
horizontal and vertical positions of each report column, I
carefully assigned identical Left positions, Lengths, and
justifications for the matching controls in the various
subforms.

All controls have Can Grow and Can Shrink set to Yes, none
overlap, and the subreport controls on the main report are
all set to the appropriate size.

However, many of the right-justified controls do not line
up. It should look something like this:

Name/Desc Phase Cost Delta Notes
Project Name SD $300,000 2,560 SF
Desc DD $350,000 2,560 SF
Client CD $600,000 2,610 SF
BID $570,000 -5.0% $218.39 /SF
-AVG $620,000 $76.63 /SF Mech
$1.00 /SF Elec
800 Apartments
$775.00 /Apartment

There is one subreport that prints the Name/Desc fields,
four that print the Phase/Cost/Delta info, and the rest
print the Notes columns. All of the problems are in the
latter. The $218.39 prints almost a full character to the
left, the $76.63 1/2 character to the right, the $775.00 a
full character to the left.

Does anyone know what's going on? I hesitate to tweak it,
although I will if I have to, because we will want to
print this report to .pdf to post on our website. The
translation to .pdf seems to introduce other anomolies, so
we'll likely need to prepare two versions of the report.

Any advice will be appreciated.

Kevin Sprinkel
 
F

Fons Ponsioen

The one thing I do not see you mention, is that each of
your subreports are in fact with the same left margin in
the page setup and that they are positioned the same on
the main report.
Hope this helps.
Fons
 
K

Kevin Sprinkel

Thank you for your response.

Yes, each subreport's left margin is the same, and each
subreport was aligned in the main report.

I have since solved the problem, although I do not yet
know why. The numbers that lined up where they belonged
were unit costs that I was rounding and formatting in a
custom function, depending on their magnitude.

Explicly formatting the other values resolved the issue.

Best regards.
Kevin Sprinkel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top