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
|
|||
|
|||
Main Report Header is on SubReport
My SubReport is a one page report that is not linked to the main
report. The SubReport is in the Report Footer of the Main Report. When the SubReport prints, the Main Report's Header is on the SubReport (which I don't want). How do I prevent the Main Report Header from Printing on the SubReport? |
#2
|
|||
|
|||
Main Report Header is on SubReport
What version of access? Since at least Access 2000 the REPORT has a format
properties for Page Header and Page Footer that you can use to determine if the Page Header/Page footer prints on all pages , not with the report header, not with the report footer, or with neither the report header nor the report footer. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County iamnu wrote: My SubReport is a one page report that is not linked to the main report. The SubReport is in the Report Footer of the Main Report. When the SubReport prints, the Main Report's Header is on the SubReport (which I don't want). How do I prevent the Main Report Header from Printing on the SubReport? |
#3
|
|||
|
|||
Main Report Header is on SubReport
On Sep 1, 12:31*pm, John Spencer wrote:
What version of access? Since at least Access 2000 the REPORT has a format properties for Page Header and Page Footer that you can use to determine if the Page Header/Page footer prints on all pages , not with the report header, not with the report footer, or with neither the report header nor the report footer. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County iamnu wrote: My SubReport is a one page report that is not linked to the main report. The SubReport is in the Report Footer of the Main Report. When the SubReport prints, the Main Report's Header is on the SubReport (which I don't want). How do I prevent the Main Report Header from Printing on the SubReport? I'm using Access 2002. I don't see the property that you are referring to, and even if I did, it wouldn't do to put the SubReport in the Page Footer, as I would get a SubReport for every page of the Main Report. |
#4
|
|||
|
|||
Main Report Header is on SubReport
You put the subreport in the report footer NOT in the page footer.
Did you look at the FORM's properties? In design view, click on the gray square with the small black square at the top left corner of the form window. Show the properties window if it is not showing. The properties window should say Report. On the Format tab, the property Page Header should be about the 4th one down. Change it from All Pages to Not with Rpt Ftr. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County iamnu wrote: On Sep 1, 12:31 pm, John Spencer wrote: What version of access? Since at least Access 2000 the REPORT has a format properties for Page Header and Page Footer that you can use to determine if the Page Header/Page footer prints on all pages , not with the report header, not with the report footer, or with neither the report header nor the report footer. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County iamnu wrote: My SubReport is a one page report that is not linked to the main report. The SubReport is in the Report Footer of the Main Report. When the SubReport prints, the Main Report's Header is on the SubReport (which I don't want). How do I prevent the Main Report Header from Printing on the SubReport? I'm using Access 2002. I don't see the property that you are referring to, and even if I did, it wouldn't do to put the SubReport in the Page Footer, as I would get a SubReport for every page of the Main Report. |
#5
|
|||
|
|||
Main Report Header is on SubReport
On Sep 1, 2:44*pm, John Spencer wrote:
You put the subreport in the report footer NOT in the page footer. Did you look at the FORM's properties? In design view, click on the gray square with the small black square at the top left corner of the form window. Show the properties window if it is not showing. *The properties window should say Report. On the Format tab, the property Page Header should be about the 4th one down. Change it from All Pages to Not with Rpt Ftr. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County iamnu wrote: On Sep 1, 12:31 pm, John Spencer wrote: What version of access? Since at least Access 2000 the REPORT has a format properties for Page Header and Page Footer that you can use to determine if the Page Header/Page footer prints on all pages , not with the report header, not with the report footer, or with neither the report header nor the report footer. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County iamnu wrote: My SubReport is a one page report that is not linked to the main report. The SubReport is in the Report Footer of the Main Report. When the SubReport prints, the Main Report's Header is on the SubReport (which I don't want). How do I prevent the Main Report Header from Printing on the SubReport? I'm using Access 2002. I don't see the property that you are referring to, and even if I did, it wouldn't do to put the SubReport in the Page Footer, as I would get a SubReport for every page of the Main Report. Well, Great! I'm sorry to have been so dense, but I just didn't know those properties were there. I use the "Report" properties all the time (of course), but I just didn't know what you meant. The report is working exactly as I want it now. Thanks for your help and patience. |
Thread Tools | |
Display Modes | |
|
|