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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|