I was wondering if anyone can help me out please.
I was using Stored Procedure in SSRS but when I use SP and click on Refresh fields the fields are not getting updated in SSRS.
I have around 6 parameters to pass to stored proc.
I tried in the follwing ways.
1)change the Querytype to Text
Execute sptest @param1,@param2,@param3,@param4,@param5,@param6
2)change the Querytype to StoredProcedure and selected my SP
Gave Refresh fields
But its not working for me.I would be very greatful if you could help me out.