[AccessD] (was: Report with 3 column detail section)

John Bartow john at winhaven.net
Fri May 8 11:55:38 CDT 2009


A follow up question:

I now have my one page report looking just perfect - one customer order with
3 columns in the detail section. I now need to include the functionality to
print all orders for a period with each order being on a separate page

The customer 1->M order detail relationship uses the natural key of
country/ordertype/custnumb. (I have to link to their data source so there is
NO possibility of changing this.)

Issue I'm having is that with a 3 column report everything other than the
report header/footer and page header/footer goes into 3 columns. So I can't
use the report's Sorting & Grouping to do this.

First thought I had was to create a recordset and loop through it
(filtering) the report to print only that natural key but I'd like to know
if there is a method to do this in the report itself.

PS: The data is supplied by someone else so let's not get into a natural key
debate here ;o)

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Thursday, May 07, 2009 11:55 PM
To: _DBA-Access
Subject: [AccessD] Report with 3 column detail section

I need to create a report that has page wide header info, page wide footer
info and a 3 column detail section.
 
I create the order detail report using a page setup of 3 columns -works
fine.
 
I placed the detail report into the detail section of the main report but it
only displays one column.
 
Can I have a report with a 3 column sub report in the detail section? If so
how do I get the sub report to show all 3 columns?
 
A2k3




More information about the AccessD mailing list