thanks.it worked.

I did that but I am getting an error

this is what I did

SELECT ....

,isnull([PAID],'NO') as [PAID] ,

CASE WHEN isnull(a.[Refill Sales ID],0) = 0 then 'No Refil'

ELSE ...

I am considering whether to create 2-3 #temp 's in a procedure and generate a report or to create a 2-3 view and call in the report.

considering all other thing...

Thanks Andras.It was of great help.

Hi thanks.it worked.