hello.

i have a report with a subreport, this is the oddest thing, the subreport has a running sum field, and at the bottom of the subreport, has an Over All Total that is taken from the running sum.

now, i try to look up the field in the subreport and add it in the main report, the oddest thing is, if it's in report view, the field's data is accurate, but when it's in print preview, the data changes to something else, like it's the sum of a group rather than a whole.

any ideas?

In which section do you have that subreport located?

Hmm...I've had a weird thing once where something was working properly on screen but goimg wrong when printed in hard-copy. I *think* it had something to do with an event in the report, possibly the OnPrint event of the detail, or maybe the footer in your case.

Do you have anything like that going on? I can't be of much more help I'm afraid but it might give you a clue as to where to look and maybe one of the gurus on the site will suggest something.

@bob at the detail section, the field being looked up in the subform is on it's report footer.

@big pat, yeah exactly like thatm, i anaylzed it more and i found out that when i do the print preview, it only looks up the first data of the running sum field. odd.

If in the detail section and it is linked via Master/Child links then it would properly only apply to the group it is linked to (if there are any groupings in the report).

umm its an unbound report :D lols.

umm its an unbound report :D lols.

So there are no groupings?

none. hehe. is it wrong?

none. hehe. is it wrong?

I guess I'd have to see the actual report in the database to know what is up.