<!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.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=130480618-24042003><FONT face=Arial color=#0000ff size=2>Sorry.
Should have checked that. My memory lets me down again. Profuse
apologies.</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A><BR><BR></FONT></P>
<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>David
McAfee<BR><B>Sent:</B> 24 April 2003 18:43<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=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></BLOCKQUOTE></BODY></HTML>