Lining Up Columns Of Subreports

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

In putting a report of nine subreports together, we
painstakingly documented each controls Left, Top, Height,
and Width properties. We also took care that control
heights within each subreport, and the subreport controls
within the main report were set such that they did not
overlap, which we knew could affect the Can Grow/Can
Shrink behavior.

For the most part, the report is successful, with the
following punch list. Any assistance in resolving these
issues would be highly appreciated.

1. In one column, report controls of subsequent
subreports do not line up, although they are both set to
right-justified, and have the same Left and Width
properties. The first prints a number in Standard format,
the second a number in Currency format.

2. Some subreports do not shrink to nothing if they
contain no data. The third subreport always begins
printing in its positioned location, rather than moving up
into the voided space.

3. In the same column referred to in 1, another Currency
field does not line up, except on the other side of the
number in Standard format. Again, Left and Width
properties, and justification are identical.

I know I can correct it for printing by tweaking it over a
few hundred twips, and I may do that in this case, but I
would really like to know what I'm missing. If anyone can
shed light on this, or point me toward a resource, I'll be
grateful.

Kevin Sprinkel
 
Kevin said:
In putting a report of nine subreports together, we
painstakingly documented each controls Left, Top, Height,
and Width properties. We also took care that control
heights within each subreport, and the subreport controls
within the main report were set such that they did not
overlap, which we knew could affect the Can Grow/Can
Shrink behavior.

For the most part, the report is successful, with the
following punch list. Any assistance in resolving these
issues would be highly appreciated.

1. In one column, report controls of subsequent
subreports do not line up, although they are both set to
right-justified, and have the same Left and Width
properties. The first prints a number in Standard format,
the second a number in Currency format.
Click to expand...

Could this be because the positive currency format has a
space character on the right? (It's there because negative
values are enclosed in ( ) and the space is required on
positive numbers so they line up with the negative numbers.)
If that's the problem, you can use a custom format to either
add a space to the regular numbers or choose a different
negative format for negative currency values.

2. Some subreports do not shrink to nothing if they
contain no data. The third subreport always begins
printing in its positioned location, rather than moving up
into the voided space.
Click to expand...

This could be because you did not set the section's
CanShrink property to Yes. Or, it could be that there is
some kind of control beside the subreport (e.g. a line or
label).

3. In the same column referred to in 1, another Currency
field does not line up, except on the other side of the
number in Standard format. Again, Left and Width
properties, and justification are identical.
Click to expand...

I don't understand what you mean by "other side"
 
In case 1, the control formatted Currency lines up
slightly left of the Standard number whereas in case 3,
the Currency control is slightly to the right.

However, I've just noticed that I do in fact have
overlapping controls in the subreports. I will plan to
repost if any problems remain after correcting.

Thank you for your response.
Best regards.

Kevin Sprinkel
 
Back
Top