Dynamic SQL help

I have a SP that returns a different dataset based on different id(parameter).
So that I can NOT get fields in the Report Builder.
Is there a way to have a "generic" Report that displays whatever it gets
from the SP.
In a simple "table" format.
If not, could you, please, get me some suggestions how to address this
problem.
One idea that I have in mind is to create Report Definitions dynamically...
I'd rather not to go there.. but..
Thank you very much!Can you UNPIVOT in the SPROC and then use a matrix in the report?
that would make the datatable always 3 columns... one for the row number,
one for the column name, one for the data.
I am just tossing this out there because I have not tried it.
"GoldenTamarin" <GoldenTamarin@.discussions.microsoft.com> wrote in message
news:298CC26A-E105-425B-B647-FD12EDDBD48A@.microsoft.com...
>I have a SP that returns a different dataset based on different
>id(parameter).
> So that I can NOT get fields in the Report Builder.
> Is there a way to have a "generic" Report that displays whatever it gets
> from the SP.
> In a simple "table" format.
> If not, could you, please, get me some suggestions how to address this
> problem.
> One idea that I have in mind is to create Report Definitions
> dynamically...
> I'd rather not to go there.. but..
> Thank you very much!