I have spent few hours looking into the issue and still cannot figure this one out.
I have created parameter @OrgNumber which I am getting the available values from View(Oracle - connected via OLEDB) and passing it to query to generate report but it returns empty result. Below is i am using ..
SELECT CHANNEL_ID, CHANNEL_CODE, ORGNO, TEAM_CODE, CHANNEL_NAME, CHANNEL_GRADE, CHANNEL_TYPE, CHANNEL_TYPE_NAME, PARENT_ID, STATUS,
LEADER_ID, LEADER_THAI_FULL_NAME, ACNT_ORG_YN, CHANNEL_GRADE_NAME, ZIP, HOUSE_NO, VILLAGE, MOO, SOI, STREET, SUBDISTRICT, DISTRICT, CITY,
TELEPHONE, INSERTED_BY, INSERT_TIME, UPDATED_BY, UPDATE_TIME
WHERE (ORGNO = ('@OrgNumber'))
My question is when I insert the parameter it has single quotes wrapped around parameter name. From Oracle the data type is VARCHAR and I am setting value type as tect in ssrs. ANy suggestions? please help.