Dear All,

I have a table tdsfl311 where the structure is

Orno
Date
Temperature

The data contains different Order no, Date of Orno(which might be same or different), Differrent temperature.


I want to pick minimum temperature of Whole day and maximum temperature of Whole day.

My layout is

Date Min temp max temp
01/10/2012
02/10/2012



30/10/2012

Can u help me in developing a script.

just create the report with sort field as date and orno . Create the aforesaid layout in afterfield of date and use the aggregate function min and max for temp field on the layout and in the program script do rprt_send in the selectdo of your table for appropriate conditions.