Excel style spreadsheet using multiple layouts
Here is my situation. I am looking to make a report in an Excel type spreadsheet. I hope I can explain this clearly.
I have one layout called "Work Orders". This layout has all my basic job info. Including a "JobID" field. This field is an unique number given to each job.
I have a second layout called "Expense Log". This layout tracks all the expense for each job. I have a portal in "Work Orders" to view the totals of each category. (See Pic).
I would like to set up a layout that will allow me to view multipul jobs expenses. I would like to set up a report sorted by "Owners" then "Porperty Name" then finally by "JobID" Then going horizionaly, Id like to have the column titels be: Admin Fees, Labor, Material Cost, Non-Material Cost, Sub Contractor, and Equipment. These field I just listed are in the "Expense Log" and are in a field called "Catagories" with a drop down.
I hope this is enough infomation. Any help is greatful.