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

Hi John:

Maybe the following is not the most sophisticated method but it works...
every time. I am assuming that you are talking about a report that has a
header and footer with a 3 column subtable.

When the report starts, a public function is called from the report's open
event. The function does the following:
1. Checks to see if a specific hidden table exists, if it does not, it
creates it from template (handles multi-user issues) and if it does, clears
any data.
2. The table has the equivalent of 3 columns. (Any configuration...)
3. The function now queries the data set and through a series of for/next
loops populates the table.
4. The new table is used for the subtable.

This technique works every time regardless of how complex of subtable that
is required for the report display.

Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Friday, May 08, 2009 9:56 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] (was: Report with 3 column detail section)

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com