0 Replies Latest reply on Apr 14, 2012 6:06 AM by jhowlin

    Help Creating Report with Data from Multiple Related Tables

      Title

      Help Creating Report with Data from Multiple Related Tables

      Post

      Folks have been extremely helpful here, thank you!

      I have a database with tables linked according to the diagram attached.

      CUSTOMERS ulitmately own many TITLES. (They have ORDERS which have PRODUCTS which have TITLES).

      I would like to create a report that shows for each title the number of customers that own the title. (And I've accomplished that). But then I want to show a breakdown for a group of customers that own a particular title, their distribution of ownership across all other additional titles (if any) below that. So something like this:

      Title A1000 Customers Own


      Title A1000 (100%)
      Title B200 (20%)  
      Title C400 (40%)
      Title D100 (10%)

       


      Title B300 Customers Own


      Title A100 (33 %)
      Title B300 (100%)
      Title C200 (66%)
      Title D0 (0%)


      Title C100 Customers Own


      Title A...
      ...
       

      Does anyone have any ideas how to approach this?

       

      I guess I'm even having trouble figuring out which table to base the report off of. Is it titles, since I want to report about how many customers own each title? Or is it customers, since I want to group and summarize the number of customers that own a title?

       

       

      Thanks so much!

       

      Jason

      Screen_Shot_2012-04-12_at_2.25.17_PM.png