Hi SSRS Experts,
I created a stored procedure MySP in BIDS, everything works fine, that MySP returns exactly 3 fields of data I want.
Then I went to visual studio (SSRS), and then created a new dataset which points to MySP.
Then I click on RUN (!), it returned 3 columns just like what I want.
BUT, when I moved to LAYOUT and tried to drag-and-drop the dataset fields to layout, the data is not there!
Nothing is under the dataset MySP !!!
Why is it so?
Please help me out!!