>Hi,
>
>I have a dynamic sql stored procedure that I have created to create a cross tab report. Of course, as the columns are dynamically created, when creating a tableadapter in a dataset against this stored procedure, I won't get any columns available.
>
>How do I go about this? Is the only way to hard code the column names and do away with the dynamic sql?

Frank

You can write a query that will create a dataset that you can use for the your report.
Then you can fill the data table with dynamic SQL if you want.