<!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=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> </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></BODY></HTML>