AnsweredAssumed Answered

I need help creating reports in an O&G database.... ??

Question asked by kkdunlap on Mar 3, 2016
Latest reply on Mar 3, 2016 by taylorsharpe

I am totally new to FileMaker and have a database that I created in MS Access a million years ago. The individual using this database has now switched to a Mac and FileMaker was the only program I could come up with to try and duplicate it in.  I've got the data entry part of it taken care of so its a simple input screen etc. for them. But I'm not having any luck with getting reports set up.  Here is a screenshot of the data entry screen... I understand to do a new layout I think but I've looked at this so long I've confused myself I think.  Any help would be really appreciated.

I have the columns totaling up in the YTD row and I have the Month Total column totaling up perfect. Just can't wrap my head around getting the reports/layout/script I need of the reports I want to run.




There will be 100+ records to total up.


1st report - a monthly report listing all properties that would have this listed for each record.

                    It would look like this...


                    "month" 2016 summary


       Header-             Purchaser/Operator     Prop ID     Lease Name     O&G     Taxes     Bonus     Totals


                                   each property listed w/ info below                         0.00          0.00     0.00          0.00





2nd report by "State" would be a grand total of all the records YTD oil/gas , then taxes, then bonus and then a total of those all added together.

                   I need to be able to do a report for each state that might be needed.


               2016 Year End By State


                         State     O&G     Taxes     Bonus     Totals


                              OK     0.00     0.00     0.00          0.00

                               IL      0.00     0.00     0.00          0.00    



3rd report - would include grand totals for each State on a separate report


               2016 Year End Totals - IL

                         STATE          STATE O&G     STATE TAXES     STATE BONUS

                              IL               0.00                    0.00                         0.00