4 Replies Latest reply on Nov 6, 2016 1:56 PM by James_L

    Reports not presenting as expected


      I've got two tables and a join table (many-to-many):


      Names_Searched <---> Names_Items_Join <---> Items_Found


      Each "Name" in the first table is unique.

      Each "Items" record has a field "date."


      I'm trying desperately to get what should be a simple report, and not getting expected results.


      What I want to see is a report that sorts my Names from the first table alphabetically, then lists the "Items" from the third table that are joined to it, sorted by date:


      Names Record A

           Items 4 1/1/2016

           Items 2  2/1/2016

           Items 3 3/5/2016

           Items 5 7/1/2016


      Names Record B

           Items 1 3/1/2015

           Items 4 1/1/2016


      And so on.


      In my Layout, I've got "Names" as a Leading Grand Summary. 

      I've got "Items" as a sub-summary sorted by date, but it isn't sorting by date.  I have no idea why.