Hi there,
I have a Clarion Report that has code on a button on the Report Window.
this code writes to a table ( called (FOOD), the data to report.
and the report returns from this table.- works well in Clarion.
Im wanting to total the number of records conditionally by date range each day.
I can import the report and run it Ok with the templates added as instructed as well as the prototype and Parameters set on the window.
PDFTools set as well as the NT templates
the problem is that the report only returns the data already in theFOOD table and does not add or delete from it according to the code.
Where should I relocate the code within the report embeds to do this?
ive tried server side without success...
and p_web.trace doesnt return anything either.
this is the code I need to work....
loc:date and loc:enddate and Hal:name are from session variables
LOOP locdate = loc:date to loc:enddate by 1
! logout(5,food)
! Foo:breakfasttotal = 0
! Foo:lunchTotal = 0
! Foo:DinnerTotal = 0
!
!
! LOG:DateIn = locdate
! set(LOG:keyDate,LOG:keyDate)
! LOOP until access:log.next()
! if log:datein > locdate then break.
! IF LOG:HallName not = Hal:name then CYCLE END
! Foo:BreakfastTotal += LOG:breakfastcount
! Foo:lunchTotal += LOG:lunchcount
! Foo:DinnerTotal += LOG:dinnercount
! Foo:Date = locdate
!
! END
! IF (Foo:BreakfastTotal + Foo:lunchTotal + Foo:DinnerTotal) > 0
! access:food.tryinsert()
! END
! COMMIT
! END
There does not appear to be a NT example report that does anything like this
Thanks
Richard
using NT 8.71 C10