Hi Guy's Please forgive the nube question, but I'm new to Jasper. I'm trying to produce a report that requires some post DB computation :( I've done quite a bit of reading, but if I've missed an article please advise. In short, several of the fields on the report are calculated from input fields (this I can do). However the formula needs to generate default values if an input is null, and/or override values that are out of bracket.. Crystal would use separate functions.. EG(a simple example, the variable count can be much higher) --KM (Entry Point) {FLD.DISTANCE} - {@CurrentKM}; --@CurrentKM local numbervar km :=0; km:= ({CONTRACT.DISTANCE}/{CONTRACT.DURATION})*{@ReportPeriod}; if isnull({CONTRACT.INITIALDISTANCE}) then km:=km else km:= km+{CONTRACT.INITIALDISTANCE}; km; --@ReportPeriod local datetimevar effEnde :=CurrentDate; local numbervar effLZ := 0; if CurrentDate>= {CONTRACT.ENDDATE} Then effEnde := {CONTRACT.ENDDATE} else effEnde := CurrentDate; effLZ := (Days360 ({CONTRACT.STARTDATE},effEnde ,FALSE )+1)/30; efflz; ?? It must be possible to achieve something like this with Jasper, I just can't see it :( Thanks in advance for helping :) R
