Creating totals from multiple portals - report setup
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.