Seal Report Forum
»
Report Edition
»
Data Source Creation
»
Common Restrictions not working in version 5.1
Rank: Newbie
Groups: Registered
Joined: 12/26/2019(UTC) Posts: 6  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 aI 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 aWhen 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 aSame 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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Yes, this is a regression, it will be fix in the 5.1.1 that will be released very soon...
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 12/26/2019(UTC) Posts: 6 Location: Mumbai
|
Thanks.
Now Common Restriction working in version 5.1.1
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Data Source Creation
»
Common Restrictions not working in version 5.1
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.
