mjpedreira1
8th May 2007, 14:36
Hi,

I would like to use the sum function in the 'out expression' for a Before.field format.

The expression will be sum(tdpur045.amnt)<>0, and I would like insert it in the subsession Maintain formats reports (ttadv3131s000). I prefer don´t touch de code of the report.

Thanks,

María

mark_h
8th May 2007, 15:08
I don't think you can unless you pass it to the report. I would recommend doing it in the session script for the report, but it looks like you do not want to do that. Another (much harder) alternative is to manipulate the records in the report script itself(and I do not recommend this). Here is a link (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=1908). It would be just a lot easier and cleaner if you did it in the session script.

Hitesh Shah
9th May 2007, 16:04
I think this will not be available as sum is not a valid 4gl function . If there is any corresponding total.. variable in report (which i doubt will have proper value in before.field section) , u may use somthing like "total..5 <> 0 " .