A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Remove Header Once Report Displays?



 
 
Thread Tools Display Modes
  #1  
Old December 21st, 2009, 03:49 PM posted to microsoft.public.access.reports
scott04
external usenet poster
 
Posts: 197
Default Remove Header Once Report Displays?

Hi All,

I am trying to figure a report issue. I have a report that utilizes the
subreport feature. When the subreport loads it is ok but once the subreport
goes onto a 2nd page the headers are all out of wack. The header contains
the main report which is quite confusing since fields are not the same. Can
my second page only contain the subreport headers? Thanks.
  #2  
Old December 21st, 2009, 04:27 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Remove Header Once Report Displays?

It isn't clear what you mean by "The header contains the main report which is
quite confusing since fields are not the same". A subreport contains nothing
from the main report. When you mention "header", please be specific since
there are potentially 12 "headers" in a report (excluding those from
subreports).

There are ways to cancel the display of main report Page Headers on all but
the first page. If you want this, you are probably better off just using the
Report Header. You can also get a pseudo Page Header in a subreport by
creating a top level sorting and grouping section on a constant expression
like:
=1
Display this groups header and set its Repeat Section property to Yes.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Hi All,

I am trying to figure a report issue. I have a report that utilizes the
subreport feature. When the subreport loads it is ok but once the subreport
goes onto a 2nd page the headers are all out of wack. The header contains
the main report which is quite confusing since fields are not the same. Can
my second page only contain the subreport headers? Thanks.

  #3  
Old December 21st, 2009, 08:47 PM posted to microsoft.public.access.reports
scott04
external usenet poster
 
Posts: 197
Default Remove Header Once Report Displays?

Duane,

Sorry about that. My reports page header is being displayed on the
subreport. I have utilized the pseudo header in subreport of haveing a
header =1 but i still cannot get the report page header to be ignored in
subreport. I have set the repeat section property on the subreport and it
does print on pages following but it has the report page header then my sub
report pseudo header. Any thoughts as reports aren't my strong point.
Thanks!

"Duane Hookom" wrote:

It isn't clear what you mean by "The header contains the main report which is
quite confusing since fields are not the same". A subreport contains nothing
from the main report. When you mention "header", please be specific since
there are potentially 12 "headers" in a report (excluding those from
subreports).

There are ways to cancel the display of main report Page Headers on all but
the first page. If you want this, you are probably better off just using the
Report Header. You can also get a pseudo Page Header in a subreport by
creating a top level sorting and grouping section on a constant expression
like:
=1
Display this groups header and set its Repeat Section property to Yes.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Hi All,

I am trying to figure a report issue. I have a report that utilizes the
subreport feature. When the subreport loads it is ok but once the subreport
goes onto a 2nd page the headers are all out of wack. The header contains
the main report which is quite confusing since fields are not the same. Can
my second page only contain the subreport headers? Thanks.

  #4  
Old December 21st, 2009, 09:53 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Remove Header Once Report Displays?

"My reports page header is being displayed on the subreport." is incorrect.
Your main report page header is displayed in the main report, not the
subreport.

Did you try remove the main report's Page Header section and use the main
report's Report Header?

I don't think there is an easy way to hide a main report Page Header section
based on a subreport continuing on a new page of the main report.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Duane,

Sorry about that. My reports page header is being displayed on the
subreport. I have utilized the pseudo header in subreport of haveing a
header =1 but i still cannot get the report page header to be ignored in
subreport. I have set the repeat section property on the subreport and it
does print on pages following but it has the report page header then my sub
report pseudo header. Any thoughts as reports aren't my strong point.
Thanks!

"Duane Hookom" wrote:

It isn't clear what you mean by "The header contains the main report which is
quite confusing since fields are not the same". A subreport contains nothing
from the main report. When you mention "header", please be specific since
there are potentially 12 "headers" in a report (excluding those from
subreports).

There are ways to cancel the display of main report Page Headers on all but
the first page. If you want this, you are probably better off just using the
Report Header. You can also get a pseudo Page Header in a subreport by
creating a top level sorting and grouping section on a constant expression
like:
=1
Display this groups header and set its Repeat Section property to Yes.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Hi All,

I am trying to figure a report issue. I have a report that utilizes the
subreport feature. When the subreport loads it is ok but once the subreport
goes onto a 2nd page the headers are all out of wack. The header contains
the main report which is quite confusing since fields are not the same. Can
my second page only contain the subreport headers? Thanks.

  #5  
Old December 21st, 2009, 10:35 PM posted to microsoft.public.access.reports
scott04
external usenet poster
 
Posts: 197
Default Remove Header Once Report Displays?

I did try that it does work for the purposes of removing the headers on the
subreport page since now it only shows on first page. I was just checking to
see if there was some code i can use that when the subreport appears that
page and the following pages do not have the page header if i went that
route. The header is kind of necessary for the pages up until the subreport
starts.

"Duane Hookom" wrote:

"My reports page header is being displayed on the subreport." is incorrect.
Your main report page header is displayed in the main report, not the
subreport.

Did you try remove the main report's Page Header section and use the main
report's Report Header?

I don't think there is an easy way to hide a main report Page Header section
based on a subreport continuing on a new page of the main report.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Duane,

Sorry about that. My reports page header is being displayed on the
subreport. I have utilized the pseudo header in subreport of haveing a
header =1 but i still cannot get the report page header to be ignored in
subreport. I have set the repeat section property on the subreport and it
does print on pages following but it has the report page header then my sub
report pseudo header. Any thoughts as reports aren't my strong point.
Thanks!

"Duane Hookom" wrote:

It isn't clear what you mean by "The header contains the main report which is
quite confusing since fields are not the same". A subreport contains nothing
from the main report. When you mention "header", please be specific since
there are potentially 12 "headers" in a report (excluding those from
subreports).

There are ways to cancel the display of main report Page Headers on all but
the first page. If you want this, you are probably better off just using the
Report Header. You can also get a pseudo Page Header in a subreport by
creating a top level sorting and grouping section on a constant expression
like:
=1
Display this groups header and set its Repeat Section property to Yes.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Hi All,

I am trying to figure a report issue. I have a report that utilizes the
subreport feature. When the subreport loads it is ok but once the subreport
goes onto a 2nd page the headers are all out of wack. The header contains
the main report which is quite confusing since fields are not the same. Can
my second page only contain the subreport headers? Thanks.

  #6  
Old December 22nd, 2009, 12:56 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Remove Header Once Report Displays?

Can you use a group header rather than a page header?

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

I did try that it does work for the purposes of removing the headers on the
subreport page since now it only shows on first page. I was just checking to
see if there was some code i can use that when the subreport appears that
page and the following pages do not have the page header if i went that
route. The header is kind of necessary for the pages up until the subreport
starts.

"Duane Hookom" wrote:

"My reports page header is being displayed on the subreport." is incorrect.
Your main report page header is displayed in the main report, not the
subreport.

Did you try remove the main report's Page Header section and use the main
report's Report Header?

I don't think there is an easy way to hide a main report Page Header section
based on a subreport continuing on a new page of the main report.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Duane,

Sorry about that. My reports page header is being displayed on the
subreport. I have utilized the pseudo header in subreport of haveing a
header =1 but i still cannot get the report page header to be ignored in
subreport. I have set the repeat section property on the subreport and it
does print on pages following but it has the report page header then my sub
report pseudo header. Any thoughts as reports aren't my strong point.
Thanks!

"Duane Hookom" wrote:

It isn't clear what you mean by "The header contains the main report which is
quite confusing since fields are not the same". A subreport contains nothing
from the main report. When you mention "header", please be specific since
there are potentially 12 "headers" in a report (excluding those from
subreports).

There are ways to cancel the display of main report Page Headers on all but
the first page. If you want this, you are probably better off just using the
Report Header. You can also get a pseudo Page Header in a subreport by
creating a top level sorting and grouping section on a constant expression
like:
=1
Display this groups header and set its Repeat Section property to Yes.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Hi All,

I am trying to figure a report issue. I have a report that utilizes the
subreport feature. When the subreport loads it is ok but once the subreport
goes onto a 2nd page the headers are all out of wack. The header contains
the main report which is quite confusing since fields are not the same. Can
my second page only contain the subreport headers? Thanks.

  #7  
Old December 22nd, 2009, 03:01 PM posted to microsoft.public.access.reports
scott04
external usenet poster
 
Posts: 197
Default Remove Header Once Report Displays?

Duane,

I think the group header my be the best route to semi solve this problem. I
appreciate all of your suggestions.

Scott

"Duane Hookom" wrote:

Can you use a group header rather than a page header?

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

I did try that it does work for the purposes of removing the headers on the
subreport page since now it only shows on first page. I was just checking to
see if there was some code i can use that when the subreport appears that
page and the following pages do not have the page header if i went that
route. The header is kind of necessary for the pages up until the subreport
starts.

"Duane Hookom" wrote:

"My reports page header is being displayed on the subreport." is incorrect.
Your main report page header is displayed in the main report, not the
subreport.

Did you try remove the main report's Page Header section and use the main
report's Report Header?

I don't think there is an easy way to hide a main report Page Header section
based on a subreport continuing on a new page of the main report.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Duane,

Sorry about that. My reports page header is being displayed on the
subreport. I have utilized the pseudo header in subreport of haveing a
header =1 but i still cannot get the report page header to be ignored in
subreport. I have set the repeat section property on the subreport and it
does print on pages following but it has the report page header then my sub
report pseudo header. Any thoughts as reports aren't my strong point.
Thanks!

"Duane Hookom" wrote:

It isn't clear what you mean by "The header contains the main report which is
quite confusing since fields are not the same". A subreport contains nothing
from the main report. When you mention "header", please be specific since
there are potentially 12 "headers" in a report (excluding those from
subreports).

There are ways to cancel the display of main report Page Headers on all but
the first page. If you want this, you are probably better off just using the
Report Header. You can also get a pseudo Page Header in a subreport by
creating a top level sorting and grouping section on a constant expression
like:
=1
Display this groups header and set its Repeat Section property to Yes.

--
Duane Hookom
Microsoft Access MVP


"scott04" wrote:

Hi All,

I am trying to figure a report issue. I have a report that utilizes the
subreport feature. When the subreport loads it is ok but once the subreport
goes onto a 2nd page the headers are all out of wack. The header contains
the main report which is quite confusing since fields are not the same. Can
my second page only contain the subreport headers? Thanks.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.