joebloeonthego
Technical User
I have a report that does some stuff in the detail band, but only displays the results in the summary. It's been brought to my attention that some of the values are wrong. the one value in particular I've been 'debugging' is exactly double what it should be. I then ran the report with the detail visible so I could see where it was doubling, but then the result was correct! I am completely stumped. Here is the field in the detail band:
ronhand:
=IIf([ordernum]="On Hand",[supply],0)
and it sums over group
then the summary band references [ronhand].
With detail band visibility set to 'no', the result is exactly double, when set to yes it is correct. And there is only one line of detail (out of about 20) that have the ordernum = 'On Hand' if that helps any.
any suggestions?
ronhand:
=IIf([ordernum]="On Hand",[supply],0)
and it sums over group
then the summary band references [ronhand].
With detail band visibility set to 'no', the result is exactly double, when set to yes it is correct. And there is only one line of detail (out of about 20) that have the ordernum = 'On Hand' if that helps any.
any suggestions?
