Get a Jumpstart with our Sample Apps
Results 1 to 5 of 5

Thread: 3 subreports in a detail section

  1. #1
    Member
    Real Name
    Stephen Etter
    Join Date
    Nov 2017
    Posts
    2

    Default 3 subreports in a detail section

    Is it possible to put 3 subreports in a detail section from a set. I am trying to put an item subreport labor subreport and income subreport in the detail section but have not had any luck
    please advise

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,698

    Default Re: 3 subreports in a detail section

    A bit shy on details there.

    The documentation says

    A sub-report is an entire report that is placed in the Detail area of another report. Its main purpose is to display data from tables linked in a set using one-to-many links at the same level
    Is that the case in your efforts?
    There can be only one.

  3. #3
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,383

    Default Re: 3 subreports in a detail section

    Yes

    Details/sample needed
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  4. #4
    Member
    Real Name
    Stephen Etter
    Join Date
    Nov 2017
    Posts
    2

    Default Re: 3 subreports in a detail section

    Sorry for the brief post I have a Invoice set with a Invoiceh dbf, Invoiceitem dbf, labor dbf, and income dbf linked one to many, linking field Invoicen that I built in version 9. I stacked fields
    on top of each other in the detail section from invoiceitem, Labor and income. Which I know is probably wrong, but it worked. But now I am moving up to version 11 and I need to create 3 subreports In the detail section for Invoceitem, Labor and Income, First I created a report with a group insert group "Invoicen" with linking Invoicen and inserted a subreport1 in detail dropped in fields from invoiceitem and it works right but, When I create subreport2 and drop fields in from labor Invoiceitem prints the first item twice and nothing in subreport2, and I don't know how to post a sample

  5. #5
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,698

    Default Re: 3 subreports in a detail section

    If your tables contain any sensitive data duplicate the set and tables to a new location and obscure as necessary. Using either the original or the new duplicate, right click on the set name in the control panel, choose Zip Set. Note the location of the compressed file.

    Post another reply to this thread, use the Go Advanced button, scroll down to Manage Attachments, attach the zip.
    There can be only one.

Similar Threads

  1. Reports - To align labels at the header section with the field at the detail section
    By bradleyward in forum Alpha Five Version 11 - Desktop Applications
    Replies: 4
    Last Post: 01-04-2013, 08:41 PM
  2. Two sub reports in the detail section
    By kartik in forum Application Server Version 11 - Web/Browser Applications
    Replies: 8
    Last Post: 06-19-2012, 11:30 PM
  3. How do you shut off detail section in a report
    By kdankwah in forum Alpha Five Version 7
    Replies: 5
    Last Post: 09-20-2007, 02:31 PM
  4. Detail Section Totaling
    By David S in forum Alpha Five Version 5
    Replies: 1
    Last Post: 10-14-2005, 12:27 PM
  5. Detail section.
    By johnnhoj in forum Alpha Five Version 5
    Replies: 2
    Last Post: 10-09-2002, 05:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •