Skip to main content

I have a subreport that gets the total amount invoiced for a sales order.  In the main report i get sales orders with an invoice in a date range and then pass in the sales order number to the subreport to get the total invoice regardless if the invoice is in the entered date range.  The subreport works correctly but in the main report it is not giving me a correct total.  It will sum all but the last value from the subreport.  I’ve tried every combination of the ProcessOrder I can think of.  

 

Attached are the two reports.

I found the solution.  I had the variable in the parent report in the group header. I moved it to the group footer and it is now calculating correctly.

Thank you for sharing your solution with the community @vpoulson!

Reply


Terms & ConditionsCookie settings