>>I see - from your note - that will need to learn how to create datasets. And since most of the stuff I do is in stored procedures, I will have to learn how to do in in Stored Procedure.
>>
>>Thank you.
>
>Well, it's actually quite easy. If you have a stored proc that is bringing back the result set you want....and you just want the SSRS report to bind to it. it's quite easy.
>
>In a nutshell
>
>- you define a new dataset in the SSRS report
>- you can tell it whether you want it to be a query or a proc....if you choose proc, you get a dropdown and can pick the proc name
>- that will populate the dataset definition with the columns from the report.
>
>So it's pretty straightforward.
Thank you. I will try these steps in my SQL Server (and I don't even know if I have SSRS enabled).
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham