Can you shrink the size of PageHeader?

  • Thread starter Thread starter Margaret Dullnig via AccessMonster.com
  • Start date Start date
M

Margaret Dullnig via AccessMonster.com

I have four lines in my PageHeader. There are two fields that may not have
data. I have set them to Can Shrink, and set the controlsource as follows:
=iif(strData>"",strData,Null).

The report still prints a blank line. There is no "Can Shrink" property
for the PageHeaderSection. I have also tried setting the height of these
fields to zero, set Can Grow = yes, and Can Shrink = No. Nothing seems to
work.

Any help will be greatly appreciated.

Peg
 
You could try create a new primary sorting and grouping level on a constant
expression like:
=1
Display the =1 group heading section. Set the Repeat Section property of
this group to Yes. The =1 group header can then be used as your page header
and should grow and shrink.
 
This almost works. The problem is that my detail section uses multiple
columns. This group header is printing at the top of each column when I
want it to print at the top of each page. It also is getting cut off at
the column length (want it to print across the page over the columns).

I have tried setting the group to page number, but it doesn't like that.
When I turn the RepeatSection off, it prints the detail in the second
column at the same height as my page data.

Any other suggestions? Thanks for you help.
 
I missed the part in your earlier posting stating this was a multiple column
report ;-)

I have had some success with move all the detailed, multicolumn records to a
subreport and remove the details and column definitions from the main
report.

If this doesn't work, you may be stuck with a constant page header section
height. Maybe someone else has a solution...
 
Back
Top