Stimulsoft Business Intelligence System | Forum

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)

Hello,

Please clarify which product and version are you use?

Thank you.

Version 2020.2.3 from April 29 2020 ASP.net, JS

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.

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.

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?

Hello,

Please try to save reports in files instead of the SQL database and check it.

Thank you.

Saving as files does work, but the website saves them in the database.

Hello,

In that case, you should check your database settings.

Thank you.