Results 1 to 9 of 9

Thread: "Distinct Reords"

Threaded View

<< Previous Post   Next Post >>
  1. #1
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    8,193

    Default "Distinct Reords"

    I've tested this in both 4.0.something as well as the latest (6.1.5?) & it's got me stumped. RDS report. It's a subreport within a subreport on a complicated report (15 or so tables total) - so adding test data would be difficult. The subreport I'm having issues with is only 2 tables - basically invoice detail with a parent of parts info. This subreport is constrained by Job # in the parent report.

    The data has 2 lines that are identical:

    Part: PST00047 SIDE POST, VANGUARD A-SLOT GALV. Qty: 1.00 @ 21.14 = 21.14
    Part: PST00047 SIDE POST, VANGUARD A-SLOT GALV. Qty: 1.00 @ 21.14 = 21.14
    Unfortunately, this is valid (please don't ask why).

    If the report has "Distinct Rows" checked, it prints one of the lines. What's got me, is that if I uncheck it, it prints 4!

    There are 2 jobs (2 parent report records) - so is that it? They print under their correct Job #:

    Click image for larger version. 

Name:	DupParts.PNG 
Views:	14 
Size:	119.4 KB 
ID:	11707

    Here's VData from the .RV:

    Click image for larger version. 

Name:	DupPartsVData.PNG 
Views:	9 
Size:	14.8 KB 
ID:	11708

    Any ideas?

    TIA
    Last edited by Garret Mott; 13-Feb-2018 at 06:09 PM.
    Garret

    the only intuitive interface is the nipple.. everything else is learned.




Posting Permissions

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