We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Query Designer is not enabled / Grayed

Thread ID:

Created:

Updated:

Platform:

Replies:

129759 Apr 2,2017 12:11 PM UTC Apr 7,2017 03:52 AM UTC Report Platform 3
loading
Tags: Report Designer
Haneef Puttur
Asked On April 2, 2017 12:11 PM UTC

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 [Syncfusion]
Replied On April 3, 2017 09:59 AM UTC

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
Replied On April 5, 2017 05:45 AM UTC

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 [Syncfusion]
Replied On April 7, 2017 03:52 AM UTC

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: 

 
Regards, 
Vinoth S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;