i want to print total order booked for a selective period along with other details.

i defined for total amount in after field . it appearing correctly
now
i want to know how many orders in total .e.g. 100 or 250 etc. count.
where and what to define

please help

You can use aggregate function Count in the report ouput field.

i tried to use aggregation for tdpur400.orno in report level and count in aggregation , found compile error as rs-format error.

then i tried to use as tdpur400.oamt and count in aggregation. success fully completed

if i want to perform for the orno what is to be define.

Don't use tdpur400.orno as print expression, but something like lval(tdpur400.orno). And change the domain to tcmcs.long. The problem is that the tdpur400.orno field is not numeric, so the count result cannot be printed with that domain.

thanks ..Japp..

i shall try.

i want to develop new report

e.g. top 20 bp-customer based on tdpur400

orno, bpid,oamt