I want to display the reciept date and cost of those products who's cost is change than the last receipt. this selection should be based on date parameter.

for e.g

 1.  Pcode       trandate           price      supplier code

      101           10/07/2008      50.00      106

      101            25/2/2007        45.00      106

 

I display that infromation but now the problem is sometime the supplier is changed and the pcode is same but it pick the different supplier value then how it is possible. i used this formula

 

If {movement.tran_date}={?date} and
    {movement.Cost}<>next({movement.Cost}) then
    

    cstr({movement.Cost}) + "     "+"        "+ cstr(next({movement.Cost}))else

 

"x"

2.   but if in second record there is no value then it pick the next records value which i dnt want

can anyone help me plzzzzzzzzz its urgent