[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/7cc2e675/attachment-0001.html>