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

John,

    Two of my sample db's, as mentioned below, might be of interest to you:

    (a) Report_WithColumnHeaders
    (b) SubReportTwoColBalanced

    These are available at Rogers Access Library. Link - 
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
 
    Report_WithColumnHeaders, mentioned at (a) above, demonstrates a three column report having group-wise column headers as well as page break after each group. Both styles of column layout, i.e. Across and then Down (A&D) as well as Down and then Across (D&A) are shown.

    Coming to your first post, if A&D layout is adopted, the columns get automatically balanced in a report as well as subreport. No special treatment is needed. However, if there are compelling reasons to adhere to D&A layout, SubReportTwoColBalanced, mentioned at (b) above, demonstrates balancing of subreport's column heights despite adoption of  D&A layout. It takes care of subreports larger than one page and covers both situations as follows:
    (1) Straight content (no group levels).
    (2) Grouped content - This calls for balancing of columns within each group.

    Both samples are in Access 2000 file format. Further details are given in accompanying explanatory notes.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: John Bartow 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, May 08, 2009 22:25
  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