Hi All, I am building a report that shows job costs for invoices. he invoices data is on one table and the job data on another. i have the invoice table as my main report and it is linked by sales order #. Not all invoices have a Job associated to them, since some are for fees and such. for those invoices i will have blank data which is fine.
I created a variable to capture the job cost from the job subreport for each sales order and i was able to pass it to my main report.
the problem I am having is that now I want to summarize all those costs (from my variable) but i cant sumarize that field.
how would i go about adding a summary grand Total.
Please help
Thank You!
IP Logged