Page Header Control

[Jackson via AccessMonster.com]

Hi,

I've got a report that shows 3 asset classes, Equities, Bonds and FX. They
share the same page headers at the moment, what I'm trying to do now is for
eg on Equities, include a column 'Beta'. It's no problem hiding/showing this
field on the report detail as I control it by whether the Asset Header is
Equity or not. However, for the label which is a page header, I can't control
it's visibility properly because page header is before everything. If I set
it's visbility to the same type of criteria in code, the first page with
Equities doesn't display it but the second page will, I guess because Page
Header>Sub Header...

Is there anyway around such an issue short of creating 3 seperate reports for
each asset class?

Thanks.

 

[Marshall Barton]

I've got a report that shows 3 asset classes, Equities, Bonds and FX. They
share the same page headers at the moment, what I'm trying to do now is for
eg on Equities, include a column 'Beta'. It's no problem hiding/showing this
field on the report detail as I control it by whether the Asset Header is
Equity or not. However, for the label which is a page header, I can't control
it's visibility properly because page header is before everything. If I set
it's visbility to the same type of criteria in code, the first page with
Equities doesn't display it but the second page will, I guess because Page
Header>Sub Header...

Is there anyway around such an issue short of creating 3 seperate reports for
each asset class?

What condition determines the page header label's
visibility? If it's a value in a field in the records, then
you can use the same code in the Page Header section's
Format event (the page header can refer to the data in the
first record on the age).

 

[jackwoodhead via AccessMonster.com]

I've got a report that shows 3 asset classes, Equities, Bonds and FX. They
share the same page headers at the moment, what I'm trying to do now is for

[quoted text clipped - 8 lines]

Is there anyway around such an issue short of creating 3 seperate reports for
each asset class?

What condition determines the page header label's
visibility? If it's a value in a field in the records, then
you can use the same code in the Page Header section's
Format event (the page header can refer to the data in the
first record on the age).

I was using Data in the header under Page header rather than the record -
I'll try that, thanks.

 

[jackwoodhead via AccessMonster.com]

[quoted text clipped - 7 lines]

Format event (the page header can refer to the data in the
first record on the age).

I was using Data in the header under Page header rather than the record -
I'll try that, thanks.

Just tried - same problem where it won't work for the first page of records
but the page after it starts working on...how do I specifically set it to be
based on the first record?

 

[Marshall Barton]

I've got a report that shows 3 asset classes, Equities, Bonds and FX. They
share the same page headers at the moment, what I'm trying to do now is for

[quoted text clipped - 7 lines]

Format event (the page header can refer to the data in the
first record on the age).

I was using Data in the header under Page header rather than the record -
I'll try that, thanks.

Just tried - same problem where it won't work for the first page of records
but the page after it starts working on...how do I specifically set it to be
based on the first record?

Some things to check.

Make sure that a text box is not named the same as the field
you are checking.

Make sure that the group header starts on a new page.
Setting the group header section's ForceNewPage property
might help.

If any part of a group footer spills over to the next page,
that group's last detail is still in effect. (Setting the
group footer section's KeepTogether might help clarify
things)

Try an experiment by setting each section's BackColor is set
to something different so you can see where they start and
end.

 

[jackwoodhead via AccessMonster.com]

Hi Marshall,

I'm trying currently to link the Page Header label to the Asset Type which is
a query field that is displayed under the Asset Type Header. My Page Header
On Format has:

If Me.Asset = "Equity" Then
Me.Beta_Label.Visible = True
Else
Me.Beta_Label.Visible = False
End If

I've made The Asset Type Group header ForceNewPage=Before Section but it
still has the same problem where the first page doesn't include it, but
subsequent equity pages do....Is it because Page Header is Heirachy wise
higher than any Group Header?


Marshall Barton wrote:

[quoted text clipped - 8 lines]

but the page after it starts working on...how do I specifically set it to be
based on the first record?

Some things to check.

Make sure that a text box is not named the same as the field
you are checking.

Make sure that the group header starts on a new page.
Setting the group header section's ForceNewPage property
might help.

If any part of a group footer spills over to the next page,
that group's last detail is still in effect. (Setting the
group footer section's KeepTogether might help clarify
things)

Try an experiment by setting each section's BackColor is set
to something different so you can see where they start and
end.

 

[Marshall Barton]

I'm trying currently to link the Page Header label to the Asset Type which is
a query field that is displayed under the Asset Type Header. My Page Header
On Format has:

If Me.Asset = "Equity" Then
Me.Beta_Label.Visible = True
Else
Me.Beta_Label.Visible = False
End If

I've made The Asset Type Group header ForceNewPage=Before Section but it
still has the same problem where the first page doesn't include it, but
subsequent equity pages do....Is it because Page Header is Heirachy wise
higher than any Group Header?

If the first record in the report has "Equity" in its Asset
field then the Beta label should be visible. The heiarchy
(sorting and grouping) of the report only affects the order
of the records in the report.

As I said before, make certain that you do not have a text
box named Asset.

FYI, your code can be shortened to:
Me.Beta_Label.Visible = (Me.Asset = "Equity")

 

[jackwoodhead via AccessMonster.com]

Ah, I have a textbox labelled Beta in the Asset Group Header...I'll try and
work around this...

I'm trying currently to link the Page Header label to the Asset Type which is
a query field that is displayed under the Asset Type Header. My Page Header

[quoted text clipped - 10 lines]

subsequent equity pages do....Is it because Page Header is Heirachy wise
higher than any Group Header?

If the first record in the report has "Equity" in its Asset
field then the Beta label should be visible. The heiarchy
(sorting and grouping) of the report only affects the order
of the records in the report.

As I said before, make certain that you do not have a text
box named Asset.

FYI, your code can be shortened to:
Me.Beta_Label.Visible = (Me.Asset = "Equity")