Summing Subreport Values

[Dominato]

I have a subreport in the detail section of one of my reports. On the footer of the main report, I want to sum up the value of a column in the subreport. I've been fighting with this thing for some time to no avail. Any suggestions?

 

[Dominato]

Nevermind, I actually figured it out...

 

[jnixon]

How did you get this to work? I'm having the same problem with a few subreports right now!

 

[Dominato]

In the same section of the report that you put the subreport, create a field that equals the value of the field in the subreport. Then make the field invisible, and a running sum over group. That way, later on in the report, you can just refer to the invisible field if you want a summed value.

 

[Rich]

The problem with that method is that it will generate error when there is no data in the sub report

 

[colmtourque]

I tried to use this and I got only the first value from my subreport. Why would that be?