Re: Reports Column listing in Detail Section

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

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 08/22/04

  • Next message: Duane Hookom: "Re: prompt user input for report"
    Date: Sat, 21 Aug 2004 22:56:39 -0500
    
    

    You can base your main report on only the customers. Create a 4 column
    subreport (across then down) of the customer filters and add it to the main
    report.

    -- 
    Duane Hookom
    MS Access MVP
    "Source" <source@deletethishere-alaskanstores.com> wrote in message
    news:a6e101c487f3$25e60210$a501280a@phx.gbl...
    > 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
    

  • Next message: Duane Hookom: "Re: prompt user input for report"

    Relevant Pages

    • Re: crystal report subreport - leaves space for main rpt footer
      ... I have a crystal report that I have a subreport in the group header. ... link the main report to the subreport by a customer id. ... Use this group footer for your totals. ...
      (microsoft.public.vb.crystal)
    • Re: Subreport Problem
      ... report is sorting the account numbers. ... more if you think it's possible a customer could have more than 24 accounts. ...  I have a subreport in the detail section of the "receipt" ...
      (microsoft.public.access.reports)
    • Re: Subreport Problem
      ... I have essentially made a report for a 3 equal-part-per-page receipt ... customer name and address (so it can be seen from the little envelope ... I have a subreport in the detail section of the "receipt" ... lists any accounts belonging to the customer, ...
      (microsoft.public.access.reports)
    • RE: Force page every 20 records.
      ... I doubt a subreport understands anything related to pages. ... code in the report, nothing happens. ... customer information only showed up on the first system of the group. ... Add an unbound control to the detail section. ...
      (microsoft.public.access.reports)
    • Re: Subreport not displaying all info
      ... same information for the same time-frame as the main report. ... the subreport will only contain records from the last ... If you want to show a range of payment dates in the subreport, ... If I change the link to reflect customer number, ...
      (microsoft.public.access.reports)