Query |
Response |
I cannot use query designer , its grayed out as in the attachment. |
As of now we don’t have support to design queries using QueryDesigner for Oracle data source type and we have already added it to our feature request list. We will implement this feature in any of our upcoming release. |
I cannot use parameters in the query which gives this error SelectCommandConnection property has not been initiated
May be I feel because of query designer.
My requirement is i want to use the parameter defined in the query.
Actually I am using Oracle database |
The mentioned error raised due to the query parameter syntax. In your attached files the query parameter used with @ prefix letter, but oracle query parameter must have a : (colon) prefix (eg: select * UGAPP_MASTER where APPLICATION_ID=:APPID). Please refer the below forum discussion for more details on this.
https://social.msdn.microsoft.com/Forums/en-US/1718c53e-4f6f-4f2e-b73e-1d60f62026d9/defining-oracle-query-parameters-report-designer-ssrs?forum=sqlreportingservices |