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: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Allow Declared Parameters in the Query Text?

Thread ID:

Created:

Updated:

Platform:

Replies:

147778 Sep 23,2019 09:34 PM UTC Nov 7,2019 12:51 PM UTC Report Platform 5
loading
Tags: Report Designer
Brian
Asked On September 23, 2019 09:34 PM UTC

I'm trying to figure out how to have a locally declared parameter that stays with the Datasets query and does not try to get added to the parameters list on the dataset or the report.  I have some advanced queries that store some temp data in local parameters in the query text.  All the queries I'm trying to bring over have been running on SSRS and work fine.  

Example:
DECLARE @dr table(acct varchar(max));
INSERT INTO @dr values('acct1'),('acct2');
SELECT * FROM @dr;


Every time I try to use one of these types of queries, the report designer tries to add the parameter for @dr to the dataset and the report and then I receive the error that @dr has already been declared.  I have tried to delete the automatically added parameter to no avail. If I remove the declare statement I then receive errors regarding conversion between string and object even if I try to declare the type for the parameter inside the report designer.

Is there any way to have the report designer ignore query declared parameters?  This is Report Server v4.1.0.25.

Thanks,
Brian

Mahendran Shanmugam [Syncfusion]
Replied On September 24, 2019 02:10 PM UTC

Hi Brain, 
 
We were able to reproduce the mentioned dataset issue when using the shared Transect SQL queries. We will fix this issue and include this fix in our upcoming Report Platform release. Which is estimated to release on end of this month September 2019. 
 
Regards, 
Mahendran S. 


Brian
Replied On October 25, 2019 12:34 PM UTC

I've been watching for a new release.  Do we have an updated timeframe for the next release version?

Mahendran Shanmugam [Syncfusion]
Replied On October 28, 2019 11:13 AM UTC

Hi Brain, 

We have included the fix changes in our BoldReports server Report Designer.  

Could you please confirm whether the mentioned issue was cleared or not in BoldReports server. Please find the below BoldReports documentation for your reference. 

Regards, 
Mahendran S. 


Brian
Replied On October 28, 2019 12:30 PM UTC

I was hesitant to move to bold reports as I could not find any information on the possibility of a community edition.

Does bold reports support what was the Community Edition of Report Server?

Swetha Srikumar [Syncfusion]
Replied On November 7, 2019 12:51 PM UTC

Hi Brain, 
  
For sales related please contact sales@syncfusion.com or mattu@syncfusion.com directly for immediate assistance. 
  
Regards, 
Swetha 


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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

Live Chat Icon For mobile
Live Chat Icon