Showing posts with label helloi. Show all posts
Showing posts with label helloi. Show all posts

Friday, March 9, 2012

Reporting Service Q: stored procedure works fine, but preview doesnt

Hello

I got an error when doing preview of my report.
The data set 'dsTransTime' contains a definition for the field 'Trans_Type'. This field is missing from the returned result set from the data source.

The data set is populated by stored procedure. The data set works fine when I run it seperately at the Data view in Visual Studio 2003. But it doesn't work on Preview.

Please help!, thanks,

Spent few hours, finally find the solution.
Just click the 'Refresh' button on the Data view.