AnsweredAssumed Answered

Excel style spreadsheet using multiple layouts

Question asked by CraigFiore on Jun 21, 2012
Latest reply on Jun 21, 2012 by philmodjunk

Title

Excel style spreadsheet using multiple layouts

Post

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.

Craig

Screen_shot_2012-06-21_at_10.38.51_AM.png

Outcomes