2 Replies Latest reply on Jun 19, 2013 8:30 AM by mikebeargie

    Please help with Reporting


      I need to combine two summary reports on one layout. I attached sample files and pdf to better understand what I'm working with. I believe similar issue was in artical call "Two sets of summary data, One report" (http://www.phillyfilemaker.org/index.php/2009/07/reporting-on-the-same-group-of-records-sumarized-two-different-ways/).


      I can't quite understand how he did it in that artical, and I wish there would be a sample file. Maybe can someone take a look at my work and guide me in the right direction. Thank you. If you can help me with this and you around Calgary, I will buy you a beer or what ever your poison is


      Here is my files https://www.dropbox.com/sh/7d8xbkzgpcqozxx/K9-XDf5NtJ


      The sample file is a cut version of actual db I created, so since I did a cut on it, it might not function properly, but I believe it will be enought to troubleshoot this issue. if not let me know.





        • 1. Re: Please help with Reporting

          You can do this by calculations and sorting and layout settings... or you can do it with relationships... or a combination.


          At the end of a report you can have a "Trailing Grand Summary" part on the layout. It will allow you to place the totals fields at the end of your report in the layout which the PDF shows.


          When you want a breakdown by Department or by Service you can use the existing summary field to show the totals by creating a relationship to the data by a calcluation field which has a value H relating to the Department. Using that relationship you can place the related summary field Dept H::total hours next to your H. You can create a new relationship for each of the other values.


          - Lyndsay

          • 2. Re: Please help with Reporting

            And of course, if it's mission critical and you aren't able to figure things out, it might be worth it to find a consultant to help you out.


            Elance.com and Odesk.com are good places to find some help.