I have a MS Sql Server stored procedure that returns a variable number of columns, is it possible to create a report that will show the stored procedure results.
The desired output of the report is:

Name    Contest1      Contest2    Contest3
aaa       50 pt            45pt            40pt
bbb       48 pt            41pt            38pt


These are the points of each runner in the different contests.
The SP is using dynamic sql to create a crosstab. There is a lot of logic in it to calculate the points so I don't want to redo the same work in Crystal Reports. The purpose is to reuse the result of the SP, but I don't know in advance how many contests there will be. How can you do this is in Crystal Reports. So I just want the same output as the SP to be displayed in Crystal Reports.

I've seen the following answer (http://forums.asp.net/t/1210635.aspx) :  You have to use the .XSD file to communicate your SQL Table to Crystal report.
Is it possible to explain a little bit more if this can be a solution to the problem?