I have stored procedure that return set of columns depend on date passed to stored procedure

 

If user pass for example: 1/1/2011

 

the stored procedure return 10 columns first column name is 1/1/2011 and second column name is 2/1/2011 and third column name is 3/1/2011 and .. until 10th column name is 10/1/2011 

 

 

now how i can design cretal report in VS.Net to solve like this problem

 

Can any one help me

 

i use temp table and change columns name

 

 

Thank you