Hi All!
i have created a stored procedure which only on execution will determine the number of columns, as it holds dynamic query within it. like,

Code:
Procedure
@Date
@Con

Set @Con = 'Select Col or cols from Table Where Date >' + @Date'
So only after execution will result either with 3 cols or with 4 cols.
Its working well within SQL.
Now when i tried to create a dataset for a rdlc report within the VB.Net environment, i am unable to see the columns to drag and drop into the report form..

How should i use the procedure in creating the report??

i thought that i can make use of two rdlc with appropriate no of cols with it.. can it be done??

Thanks in Advance!!