<html><div style='background-color:'><DIV>
<P>I have an inherited database which I have converted from A97 to AXP in which reports seem to ignore any format changes I make to any controls on the reports. I have looked everywhere for whatever it is that is changing the format when the report runs. Modules, CBF, Macros. Nothing is hidden, I find nothing that would explain it, and yet....it happens. Is there some option somewhere that can control and override report formatting (I mean font size,bolding, that sort of thing). </P>
<P>TIA,</P>
<P>_d<BR></P></DIV>
<DIV></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Klos, Susan" <SUSAN.KLOS@FLDOE.ORG>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: "'accessd@databaseadvisors.com'" <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: [AccessD] Setting up a strange report
<DIV></DIV>>Date: Thu, 24 Apr 2003 09:49:11 -0400
<DIV></DIV>>
<DIV></DIV>>I have a report that I have to create which needs to look like a previous
<DIV></DIV>>excel spreadsheet that was created by hand before implementation of the
<DIV></DIV>>database. I want to include several subreports in the detail section but I
<DIV></DIV>>cannot get the headers of the subreports to show up. I have the main
<DIV></DIV>>report bound to the client query which fills in the header information. I
<DIV></DIV>>need to have the following subreports each of which has to have a header and
<DIV></DIV>>footer: lodging, food services, facility use, and miscellaneous. I cannot
<DIV></DIV>>do a grouped report from one large query since I need to list all lodging
<DIV></DIV>>and food services possibilities whether or not they were used for any one
<DIV></DIV>>event and the outer joins won't work. Any help would be greatly
<DIV></DIV>>appreciated.
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>Protect your PC - <a href="http://g.msn.com/8HMEENUS/2755">Click here</a> for McAfee.com VirusScan Online </html>