Can you shrink the size of PageHeader?

[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

 

[Duane Hookom]

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.

 

[Margaret Dullnig via AccessMonster.com]

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.

 

[Duane Hookom]

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...