Query Designer is not enabled / Grayed

[Haneef Puttur]

Hi,

I have 2 issues.

1. I cannot use query designer , its grayed out as in the attachment. 

2. 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.

I am attaching my rdl file and also screenshots for your reference.

My requirement is i want to use the parameter defined in the query.

Actually I am using Oracle database .

Thanks in advance,

Regards

Haneef

Attachment: syncreport_9f0c188b.7z

[Anandakumar S]

Hi Haneef, 

Thanks for your interest in Syncfusion components. 

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

Regards, 

Anandakumar S 

[Haneef Puttur]

Dear Sir, 

Thanks for the quick support.

# As you said i have tried with :APP_ID , The moment I press OK its asking me for Define query parameters. Whatever I enter , it says Index was out of range. Must be non negative and less than the size of collection. Parameter name : index

Hoerver I was able to solve only by editing the rdl file and adding below parameters manually below select statements.

 <QueryParameters>

          <QueryParameter Name="APPID">

            <Value>=Parameters!APPID.Value</Value>

          </QueryParameter>

        </QueryParameters>

Is there any specific syntax for define query parameters.  

My issue is resolved , however it may help out those oracle users who facing similar issue.

Thanks for the great product and great support.

Regards

Haneef

[Vinoth Srinivasan]

Hi Haneef, 

We were able to reproduce the reported issue at our end. A support incident has been created under your account and we request you to login into our Direct Trac support system for further updates on this issue. Our Direct Trac support system can be accessed from the following link: 

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents 

 

Regards, 

Vinoth S.