[AccessD] Setting up a strange report

(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.
 
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.)
 
HTH
David McAfee

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
Sent: Thursday, April 24, 2003 9:49 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Setting up a strange report


Susan
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.
 
Andy Lacey
http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/> 



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Klos, Susan
Sent: 24 April 2003 14:49
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Setting up a strange report


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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030424/f8bd6723/attachment-0001.html>