hi all,

please see attachment. is it possible to write where expression of aggregate function in after.report layout in report ?

I shall appreciate your earliest reply.

Vishal

Hello Vishal

Can you please attach the file which you intended? It will be of great help in understanding.

hi,

sorry as i forgot to attach the file. pl find it attached.

Vishal

Hi,

I think the best way is to put it in the layouts where your values are getting calculated. i.e. o.copr.amnt,o.copr.amnt.set & sa. Putting it in the total layout won't help.

Hi

If your requirement is that if aggregate condition is true then you want the total to get printed and if it is not true then you want a blank field as a total and not zero and you want it to implement in the Report script

Then on the basis of above requirement i would suggest write in the code


boolean print.aggr

before.program:
print.aggr = false

after.report:
before.layout:
if {where_expression} then
print.aggr = true
endif

after.layout:
print.aggr = false | Making it false again




And in the Print Condition, put this variable. print.aggr. As far as i have understood, the where condition and the Print condition looks to be similar. I maybe wrong?

Also can you put out your whole where expression?