Embedded SS and single quotes

Stimulsoft Ultimate discussion
Post Reply
David Renner
Posts: 15
Joined: Thu Jul 01, 2021 5:21 pm

Embedded SS and single quotes

Post by David Renner »

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)
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Embedded SS and single quotes

Post by Lech Kulikowski »

Hello,

Please clarify which product and version are you use?

Thank you.
David Renner
Posts: 15
Joined: Thu Jul 01, 2021 5:21 pm

Re: Embedded SS and single quotes

Post by David Renner »

Version 2020.2.3 from April 29 2020 ASP.net, JS
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Embedded SS and single quotes

Post by Lech Kulikowski »

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.
Attachments
Screenshot 2021-12-30 093020.jpg
Screenshot 2021-12-30 093020.jpg (389.73 KiB) Viewed 1746 times
David Renner
Posts: 15
Joined: Thu Jul 01, 2021 5:21 pm

Re: Embedded SS and single quotes

Post by David Renner »

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.
David Renner
Posts: 15
Joined: Thu Jul 01, 2021 5:21 pm

Re: Embedded SS and single quotes

Post by David Renner »

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?
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Embedded SS and single quotes

Post by Lech Kulikowski »

Hello,

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

Thank you.
David Renner
Posts: 15
Joined: Thu Jul 01, 2021 5:21 pm

Re: Embedded SS and single quotes

Post by David Renner »

Saving as files does work, but the website saves them in the database.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Embedded SS and single quotes

Post by Lech Kulikowski »

Hello,

In that case, you should check your database settings.

Thank you.
Post Reply