Report header


T

Troy

I did a search through the previous post and I didn't see
this so I'll ask the group. I have a report that
contains two sub reports. Everything works fine except
the main report header shows up on the last page or two
of the report with the header of the subreports. Is
there a way to keep the header of the main report from
showing if there isn't any thing to list?
Using access 2000.

Let me know if more information is needed.

Thanks,

Troy
 
Ad

Advertisements

E

Eric Butts [MSFT]

Hi Troy,

Have you tried testing for the HasData property of the subReport? An
example of such is included in the following:

ACC2000: "#ERROR" Message When Referencing Subreport Controls
http://support.microsoft.com/default.aspx?scid=kb;en-us;208718

From what you wrote I guess you want to do something like:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
IF Me.NameOfSubReport.HasData = False THEN
Me.ReportHeader.Visible = False
END IF
End Sub

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights



--------------------
| Content-Class: urn:content-classes:message
| From: "Troy" <[email protected]>
| Sender: "Troy" <anon[email protected]>
| Subject: Report header
| Date: Fri, 12 Mar 2004 07:48:22 -0800
| Lines: 14
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQISXLmV4PNUkTCQMqBllNgls4O1Q==
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.reports:133270
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.reports
|
| I did a search through the previous post and I didn't see
| this so I'll ask the group. I have a report that
| contains two sub reports. Everything works fine except
| the main report header shows up on the last page or two
| of the report with the header of the subreports. Is
| there a way to keep the header of the main report from
| showing if there isn't any thing to list?
| Using access 2000.
|
| Let me know if more information is needed.
|
| Thanks,
|
| Troy
|
 
T

Troy

Not sure if I follow you, or you don't follow me. When I
print the report I am seeing the main report's header
above the subreport's header when there is no more
information from the main report. The subreports do fine,
just the header from the report is on pages with the
subreports when there is no more information from the main
report to display.

Troy
 
Ad

Advertisements

E

Eric Butts [MSFT]

Hi Troy,

Maybe you can use the reverse of this article
http://support.microsoft.com/?id=231808

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Troy" <[email protected]>
| Sender: "Troy" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: RE: Report header
| Date: Mon, 15 Mar 2004 09:42:10 -0800
| Lines: 104
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQKtNeQFZGdaM51Rmij5k8maj8BWg==
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.reports:133464
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.reports
|
| Not sure if I follow you, or you don't follow me. When I
| print the report I am seeing the main report's header
| above the subreport's header when there is no more
| information from the main report. The subreports do fine,
| just the header from the report is on pages with the
| subreports when there is no more information from the main
| report to display.
|
| Troy
|
|
| >-----Original Message-----
| >Hi Troy,
| >
| >Have you tried testing for the HasData property of the
| subReport? An
| >example of such is included in the following:
| >
| >ACC2000: "#ERROR" Message When Referencing Subreport
| Controls
| >http://support.microsoft.com/default.aspx?scid=kb;en-
| us;208718
| >
| >From what you wrote I guess you want to do something like:
| >
| >Private Sub Detail_Format(Cancel As Integer, FormatCount
| As Integer)
| > IF Me.NameOfSubReport.HasData = False THEN
| > Me.ReportHeader.Visible = False
| > END IF
| >End Sub
| >
| >I hope this helps! If you have additional questions on
| this topic, please
| >respond back to this posting.
| >
| >
| >Regards,
| >
| >Eric Butts
| >Microsoft Access Support
| >[email protected]
| >"Microsoft Security Announcement: Have you installed the
| patch for
| >Microsoft Security Bulletin MS03-026? If not Microsoft
| strongly advises
| >you to review the information at the following link
| regarding Microsoft
| >Security Bulletin MS03-026
| ><http://www.microsoft.com/security/security_bulletins/ms03
| -026.asp> and/or
| >to visit Windows Update at
| <http://windowsupdate.microsoft.com/> to install
| >the patch. Running the SCAN program from the Windows
| Update site will help
| >to insure you are current with all security patches, not
| just MS03-026."
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights
| >
| >
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Troy" <[email protected]>
| >| Sender: "Troy" <[email protected]>
| >| Subject: Report header
| >| Date: Fri, 12 Mar 2004 07:48:22 -0800
| >| Lines: 14
| >| Message-ID: <[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Thread-Index: AcQISXLmV4PNUkTCQMqBllNgls4O1Q==
| >| Newsgroups: microsoft.public.access.reports
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.access.reports:133270
| >| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| >| X-Tomcat-NG: microsoft.public.access.reports
| >|
| >| I did a search through the previous post and I didn't
| see
| >| this so I'll ask the group. I have a report that
| >| contains two sub reports. Everything works fine except
| >| the main report header shows up on the last page or two
| >| of the report with the header of the subreports. Is
| >| there a way to keep the header of the main report from
| >| showing if there isn't any thing to list?
| >| Using access 2000.
| >|
| >| Let me know if more information is needed.
| >|
| >| Thanks,
| >|
| >| Troy
| >|
| >
| >.
| >
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report header 2
Report Header 3
Header in Reports 2
Report Headers 0
Headers on a report 3
Report Headers 2
Report Header 1
Report header 2

Top