August 13, 2013 at 9:30 pm
I have a report where one of the dataset is calling a stored procedure and parameters section it has 6 parameters and the value expression i am calling the parameters.selected value but i am getting he the below error please help me with the solution
fields names cannot be used in the parameter expressions reporting services
August 14, 2013 at 6:18 am
Can you explain in more detail how you exactly pass the parameters to the stored procedure?
Screenshots might be nice.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 15, 2013 at 6:59 am
Keon is right, really have no idea what you are trying to do without more information. I use parameters and stored procs in datasets many times. One thing to look for is in the dataset properties the "Command Type" should be "StoredProcedure". Thus, again without more information, dont know if this answers your question or not.
August 15, 2013 at 7:00 am
And the name of the stored proc is in brackets like this: [storedProcName] for the datase.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply