Embedded SS and single quotes
-
- Posts: 15
- Joined: Thu Jul 01, 2021 5:21 pm
Embedded SS and single quotes
I noticed that when i create a report using the embedded version, if the sql uses single quotes, it will not save. Is this something to do with the xml being saved with single quotes to a database column?
For instance this will not work and the report will not save, however it will preview:
LEFT JOIN myDatabase.Comment sc WITH (NOLOCK) ON (v.VersionID = sc.ObjectID AND sc.ObjectTable = 'OrdVer' AND sc.DynamicID = d.ServiceTypeID)
For instance this will not work and the report will not save, however it will preview:
LEFT JOIN myDatabase.Comment sc WITH (NOLOCK) ON (v.VersionID = sc.ObjectID AND sc.ObjectTable = 'OrdVer' AND sc.DynamicID = d.ServiceTypeID)
-
- Posts: 6431
- Joined: Tue Mar 20, 2018 5:34 am
Re: Embedded SS and single quotes
Hello,
Please clarify which product and version are you use?
Thank you.
Please clarify which product and version are you use?
Thank you.
-
- Posts: 15
- Joined: Thu Jul 01, 2021 5:21 pm
Re: Embedded SS and single quotes
Version 2020.2.3 from April 29 2020 ASP.net, JS
-
- Posts: 6431
- Joined: Tue Mar 20, 2018 5:34 am
Re: Embedded SS and single quotes
Hello,
We couldn't reproduce the issue. Please clarify how do you save your report?
Also, please try to check the last release build version.
Thank you.
We couldn't reproduce the issue. Please clarify how do you save your report?
Also, please try to check the last release build version.
Thank you.
- Attachments
-
- Screenshot 2021-12-30 093020.jpg (389.73 KiB) Viewed 2175 times
-
- Posts: 15
- Joined: Thu Jul 01, 2021 5:21 pm
Re: Embedded SS and single quotes
I'm using the web embedded version of StimulSoft and not able to upgrade it (that i know of). Writing the code with the single quotes will work, and preview just fine. I hit save and it looks like it saved, but it doesn't. After a lot of trial and error, it comes down to if there are single quotes, it will not save. When a report does successfully save, it appears to write XML to our mssql server and i think that is where the problem is.
-
- Posts: 15
- Joined: Thu Jul 01, 2021 5:21 pm
Re: Embedded SS and single quotes
Our server has compatibility set to 100 and the Quoted Identifier is turned off. Will this setup cause the issues i am having with the single quotes?
-
- Posts: 6431
- Joined: Tue Mar 20, 2018 5:34 am
Re: Embedded SS and single quotes
Hello,
Please try to save reports in files instead of the SQL database and check it.
Thank you.
Please try to save reports in files instead of the SQL database and check it.
Thank you.
-
- Posts: 15
- Joined: Thu Jul 01, 2021 5:21 pm
Re: Embedded SS and single quotes
Saving as files does work, but the website saves them in the database.
-
- Posts: 6431
- Joined: Tue Mar 20, 2018 5:34 am
Re: Embedded SS and single quotes
Hello,
In that case, you should check your database settings.
Thank you.
In that case, you should check your database settings.
Thank you.