Forget IBExpert / CR,

Why do you have two suspends?
Every time you call suspend a record will be returned in a selectable
stored procedure.

Adam

>
> adam,
> when i run it in IBexpert it shows me correct result but when i am
> displaying in crystal report it shows duplicate values
> thks
>