August 2, 2011 at 8:36 am
Hi,
I am working with SSRS 2008R2 and is getting an error when I attempt to "drag and drop" a field from a dataset that uses a SQL stored procedure although SSRS exposes the list of fields from the procedure. I added a calculated field to the dataset but still gets the error.
Error Msg: "only fields from the current dataset can be added"
Thanks for your help.
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
August 2, 2011 at 8:51 am
You probably have a table linked to dataset 1 and trying to drag fields from data set z.
August 2, 2011 at 9:38 am
That was my problem. I deleted and re-added the table to the form and it worked. Thanks
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
August 2, 2011 at 10:02 am
You're welcomed ;-).
Been bitten a few times by this one myself :hehe:.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply