AnsweredAssumed Answered

Creating totals from multiple portals - report setup

Question asked by DougBlemker on Feb 4, 2013
Latest reply on Feb 6, 2013 by philmodjunk

Title

Creating totals from multiple portals - report setup

Post

     So, I'm not sure where to start. I know just enough to cause myself problems. I took one of the startup solutions and combined project management and time tracking. I have figured out how to add up my "worked time" from a portal within one of my main layouts, but I need to take all the different projects related to one client and have the system add that up. The attached image shows my tables, the relationships and a sample of the output of a report where I need to add up the totals and it is only adding up the first section (.74) instead off all three.

     Once I get the basic reporting, I need to be able to put that in an invoice where I pull all the projects from a certain client ID for a time period (one month). I don't even know where to start with that.


     Thank you so much for any assistance you can provide. I'm happy to provide anything additional if you need it.

     Doug

FMSamples.jpg

Outcomes