>Dear Khubaib,
>Hope this will help
>
>

>tmp =  "csr" + Sys(2015)
>Select id,name,;
>	SUM(iif(year =  2005, no, $0)) As y2005, ;
>	SUM(IIF(year =  2006, no, $0)) As y2006, ;
>	SUM(IIF(year =  2007, no, $0)) As y2007, ;
>	SUM(IIF(year =  2008, no, $0)) As y2008, ;
>	SUM(IIF(year =  2009, no, $0)) As y2009, ;
>	IIF(year =  2010, no, $0) As y2010, ;
>	SUM(no) as total ;
>	from table1 ;
>	GROUP BY 1, 2 ;
>	into Cursor (m.tmp)
>

I look so much like Khubaib, that you mixed us :)

Thanks. Appreciate you trying to help very much.

Congrats on your well deserved solution stars!