in the sub report for the shared variable formula that gets your amount set it to use default values for nulls. i think that will address the 0 issue, other wise you can reset the value in the main report by placing another shared variable in the another group header (above the sub report) to set the shared variable to 0.

Edited by DBlank - 02 May 2012 at 3:36am

when editing a formula there is a pick list option in the expression editor that has 2 choices, exceptions for nulls/ default values for nulls

create another formula field in the main report that initializes the shared variable and sets it value to 0. it needs to be placed in a GH that is above the sub report (it can be suppressed)

oke I coppied the subreport, and I run it in the Report header as well as in the Group header. Now I am getting the total. But I have another, out-of-the-box issue now.

In the main report, I calculate the collections per client. This is done on payment date. In the subreport, the commission is calculated based on start date. The problem now is, that there are cases that have started in the date range, but doesn't have payments yet. So in the main report they don't show. But when I just use the total out of the subreport, the numbers don't add up with what's in the main report. Anyone has any ideas how I can work around this?
Running totals in the main report doesn't work, he's saying that this field can not be summarized......