logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Mandar  
#1 Posted : Thursday, January 16, 2020 3:41:40 PM(UTC)
Mandar

Rank: Newbie

Groups: Registered
Joined: 12/26/2019(UTC)
Posts: 6
India
Location: Mumbai

I am using Seal Report version 5.1. I have added new table in the data source. Following the sql statement used to fetch data.

SELECT a.* FROM OPENROWSET('sqlncli', 'Server=localhost;Trusted_Connection=yes;', 'exec TestStoredProcedure '{CommonRestriction_Label1}','''','''',''''') AS a

I have used the restriction {CommonRestriction_Label1} in above query.
When I clicked on the Check SQL button, it throws error:

Incorrect syntax near '1'.
SQL Executed:
SELECT a.* FROM OPENROWSET('sqlncli', 'Server=localhost;Trusted_Connection=yes;', 'exec TestStoredProcedure '1=1','''','''',''''') AS a


When I executed the report, it throws following error:

Incorrect syntax near '('.
SQL Executed:
SELECT a.* FROM OPENROWSET('sqlncli', 'Server=localhost;Trusted_Connection=yes;', 'exec TestStoredProcedure '('<restriction_value>')','''','''',''''') AS a


Same sql statement is working fine in Seal Report version 5.0

Please help me resolving this issue.

Edited by user Thursday, January 16, 2020 3:43:35 PM(UTC)  | Reason: Not specified

epf  
#2 Posted : Friday, January 17, 2020 8:49:59 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 929
Switzerland

Thanks: 14 times
Was thanked: 155 time(s) in 149 post(s)
Yes, this is a regression, it will be fix in the 5.1.1 that will be released very soon...
Mandar  
#3 Posted : Monday, January 20, 2020 8:06:22 AM(UTC)
Mandar

Rank: Newbie

Groups: Registered
Joined: 12/26/2019(UTC)
Posts: 6
India
Location: Mumbai

Thanks.
Now Common Restriction working in version 5.1.1
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.