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;
	into Cursor tmp