No Display Output using Stored Procedure

I call a stored procedure from the RS Data area and all data is retrieved on
the browse area when I run the procedure in the data window. I have
manually listed all fields in the Dataset->Fields window and drag them into
the Layout screen.
When I try to preview the report it seems to load the rows (ie 7 pages are
shown as loaded) but doesn't display any data, only the headings show with
and blank body section. If a put a string literal in one field it appears
on each row of the report but all other fields are blank.
I've looked through Output Options without any joy...Could you please post the rdl and ddl for a stored procedure that goes
against any of the sample databases so I can investigate?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"spamh8ers" <spamh8ers@.discussions.microsoft.com> wrote in message
news:2C2EC175-8681-42F9-A398-CAF83DEE765C@.microsoft.com...
> Does anyone have a solution for this yet? I have similar issues with
> creating new reports. If I start the the report with text query like
Select
> SalesOrder from SalesOrders, the report runs with no problem but when I
> change to a stored procedure, I get pages of empty report body.
> Ideas or workarounds?
> "news.microsoft.com" wrote:
> > I call a stored procedure from the RS Data area and all data is
retrieved on
> > the browse area when I run the procedure in the data window. I have
> > manually listed all fields in the Dataset->Fields window and drag them
into
> > the Layout screen.
> >
> > When I try to preview the report it seems to load the rows (ie 7 pages
are
> > shown as loaded) but doesn't display any data, only the headings show
with
> > and blank body section. If a put a string literal in one field it
appears
> > on each row of the report but all other fields are blank.
> >
> > I've looked through Output Options without any joy...
> >
> >
> >