Can not get fields using stored procedure on reporting service.
Posted on 2005-03-16
I am using Reporting service and stored procedure. My stored procedure works on the "Data" tab,and result can succeed in displaying on this page. But after I press to "Layout" tab, the "fields" is empty. It means that I can not drop the field into the table on the Layout page.
I tried to set some options on the Dataset dialogue box: in the "Fields" tab, I set the "Field name", "Type" as "Database Field" and "Value", "Parameters" and "Filters". However, what I get on the "preview" page is just the field name s that I set on "Field name" option and no any data on the page.
Moreover, except the resource on the microsoft website, is there any other resource for Reporting Service, such as some books? Thanks.
I set 500 points on this problem.