Reports Column listing in Detail Section

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Source (source_at_deletethishere-alaskanstores.com)
Date: 08/22/04 

Date: Sat, 21 Aug 2004 19:53:05 -0700

I have a list of customers and a list of filters for each
customer. Each customer may have 20-25 filters. If they
repeat on each line that is 20-25 lines per customer.
It's a waste of space. I want to list the filters in
columns within the detail area (say 4 columns) and have
those columns repeat for as many lines as necessary.

I do not want the customers within the columns, only the
columns within the detail section. Would would be ideal
is to have something like the merge property where you
can set up 4 fields horizotally and, in the 2,3,4th
fields have a "nextrecord" type of command" and then let
that set of 4 feilds repeat for each line necessary.

I've tried a few things with subreports but nothing has
gelled yet. Hopefully it is something simple that I'm
overlooking.

Any help would be appreciated.

Source

Relevant Pages

  • Re: Are you as polite and diplomatic as COBOL?...
    ... be the resulting customer name display field. ... wrongly then the name would be filled with the error message 'Customer ... repeat. ...
    (comp.lang.cobol)
  • Copying a formula
    ... instance of the customer name. ... I've gotten rid of all of the repeat data so that the customer name ... There is no set number of invoices per customer so I can't set it to ... I'm a macro ...
    (microsoft.public.excel.programming)
  • Re: Confidence Level
    ... I repeat the same ... percentage value) I can be in answering the customer that I have ... Also how confident ... a proper test of the "problem". ...
    (sci.stat.math)
  • Re: Extracting Duplicate Records in VB6
    ... this question should be posted in another newsgroup. ... > consist of customer numbers and shipto numbers. ... The customer and shipto number may repeat ...
    (microsoft.public.vb.6.webdevelopment)
  • Re: How do I get rid of empty space on my report?
    ... that there is a control below the line and you should drag a ... the amount of space for each customer has to be the same. ... There's 4 lines of customer info in the detail area with a straight line ... the title (or page header). ...
    (microsoft.public.access.reports)