How to use stored procedures as the dataset for reports?

Hi,
I want to use a stored procedure as the dataset for a report.
Even though I could execute the stored procedure in the query designer view,
the report designer did not generate the fields list (in the fields window).
Then I specified all the fields explicitly in the fields property of that
dataset. But when I tried to see the report in the preview pane, it gave me
a message that the dataset does not contain the required fields. I verified
the field names and they were exactly matching so no typo out there.
Can anyone tell me how can use a stored procedure as the dataset?
thanks,
NileshThere is a button that looks like the refresh button in IE that if you hover
over it is says refresh fields. Click on that and it will get all the field
information.
Bruce L-C
"Nilesh Oswal" <nilesh_oswal@.persistent.co.in> wrote in message
news:enGR9A3YEHA.3892@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I want to use a stored procedure as the dataset for a report.
> Even though I could execute the stored procedure in the query designer
view,
> the report designer did not generate the fields list (in the fields
window).
> Then I specified all the fields explicitly in the fields property of that
> dataset. But when I tried to see the report in the preview pane, it gave
me
> a message that the dataset does not contain the required fields. I
verified
> the field names and they were exactly matching so no typo out there.
> Can anyone tell me how can use a stored procedure as the dataset?
> thanks,
> Nilesh
>|||After executing the query from the designer, click the refresh button. Your fields should then populate.
Dave
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.