<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=649032917-24042003><FONT face=Arial color=#0000ff size=2>(sub)
Report headers and footers DO show on parent reports. Page header and footers do
not. At least in my A97 reports. I have one right now that I am looking at that
has a running sum total in a report footer which shows up on the parent
report.</FONT></SPAN></DIV>
<DIV><SPAN class=649032917-24042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=649032917-24042003><FONT face=Arial color=#0000ff size=2>BTW,
if you are trying to emulate an excel spreadsheet, don't forget to search the
archives for help on drawing the grid (if you have text boxes set to
can grow.)</FONT></SPAN></DIV>
<DIV><SPAN class=649032917-24042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=649032917-24042003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=649032917-24042003><FONT face=Arial color=#0000ff size=2>David
McAfee</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Andy
Lacey<BR><B>Sent:</B> Thursday, April 24, 2003 9:49 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Setting up a
strange report<BR><BR></FONT></DIV>
<DIV><SPAN class=320404416-24042003><FONT face=Arial color=#0000ff
size=2>Susan</FONT></SPAN></DIV>
<DIV><SPAN class=320404416-24042003><FONT face=Arial color=#0000ff
size=2>Report headers (and I think footers) of sub-reports are suppressed. I
suppose this is a design 'feature' to allow you to have the same report def as
a stand-alone (with header) or a sub-report (no header). The way round this is
to add to the query which drives your sub-report a dummy field which returns a
constant (eg SELECT 1 AS Dummy, then all your fields). In your report you set
the top sortkey as Dummy and say GroupHeader Yes (and footer if you want). Put
your report header in there and because the Dummy never changes you only get
it once, but because it's a group header not a report header Access (bless it)
won't suppress it.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A><BR><BR></FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Klos,
Susan<BR><B>Sent:</B> 24 April 2003 14:49<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD] Setting up a
strange report<BR><BR></FONT></DIV>
<DIV><FONT size=2><SPAN class=156441113-24042003>I have a report that I have
to create which needs to look like a previous excel spreadsheet that was
created by hand before implementation of the database. I want to
include several subreports in the detail section but I cannot get the
headers of the subreports to show up. I have the main report bound to
the client query which fills in the header information. I need to have
the following subreports each of which has to have a header and footer:
lodging, food services, facility use, and miscellaneous. I cannot do a
grouped report from one large query since I need to list all lodging and
food services possibilities whether or not they were used for any one event
and the outer joins won't work. Any help would be greatly
appreciated.</SPAN></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>