Maximum value from a dataset using RAP.

rbuser

Dear All.

I would like to display a maximum value of a database field on my report
(just like select max(field1) from table_name) if I selected a data from a
database as normal, is it posible to get the maximum value of a specific
database field using RAP? How?

Thanks for your help.
Kongthap Thammachat

Top Trend Manufacturing Co., Ltd.
jeud@yahoo.com
ICQ: 13026976

digitalmetaphors

If you don't want to add a MAX() calculated field on a dataset, then use a
TppDBCalc component in the report and hook it to a field on the dataset and
set its DBCalcType to dcMaximum. Also, you'll probably want to set
DBCalc.LookAhead to true.


Cheers,

Jim Bennett
Digital Metaphors