I am new to SSRS. when ever i am accessing data from oracle thru passing '?' or variable into report. it is throwing syntax error. if I do hard code the value then it will show me all the data. what should be sytax. Thanks in Advance

pass a parameter to an Oracle dataset using ':' like so: select * from dual where :value = 'tiger' once you do this, visual studio should automatically add the parameter to your report parameter list and your dataset properties

pass a parameter using ':' like so: select * from dual where :value = 'tiger' once you do this, visual studio should automatically add the parameter to your report parameter list and your dataset properties

Hi Aric Thomas, Has Nehemiah Willis' reply helped you, if so please make it as answer, if not could you please give a feedback, thanks.