Hi all, i need to display a field “nextinsurence” in the report which is not exits in the table. For that i write a display method in table and i drag that method in the reports.But i am getting the first record date,for the every record in the report.Please help me out. This is my method display date nextinsurence() { date ret; VechicalINformation vechinf; ; select insurdate from vechinf; ret =nextYr(vechinf.InsurDate)-1; return ret; }
Yep, it will return the same record, as there is no specific condition in the select statement which can differentiate it for different records.