Hello Everyone,
I have a strange issue, i have developed a report which has multiple parameters in it. When i am running it in visual studio its working fine but when i deployed it on web server and running it, its giving me a error regarding the parameter which i have pasted below. I checked all my parameters and they are correctly setup in the visual studio and sql server as well..
I have 3 parameters
1) Period --> Available values are set and there is no default values for this as it is a drop down selection (Screen shot attached) I read in a blog that if we are not giving the default parameter values as well it would give us a error. Is that true??
2) Start date--> Available values and default values are set
3) End date--> Available values and default values are set
And also i have attached the run time error also in my attachments.
Any suggestion or solution is appreciated and thanks in advance!!
Runtime-Error.png
Period_screenshot.png