Search found 15 matches

by David Renner
Wed Jan 05, 2022 6:58 pm
Forum: Stimulsoft Ultimate
Topic: Embedded SS and single quotes
Replies: 8
Views: 1983

Re: Embedded SS and single quotes

Saving as files does work, but the website saves them in the database.
by David Renner
Wed Jan 05, 2022 5:47 pm
Forum: Stimulsoft Ultimate
Topic: Changing data source
Replies: 8
Views: 2286

Re: Changing data source

That worked. Thanks!
by David Renner
Wed Jan 05, 2022 12:06 am
Forum: Stimulsoft Ultimate
Topic: Embedded SS and single quotes
Replies: 8
Views: 1983

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?
by David Renner
Tue Jan 04, 2022 4:08 pm
Forum: Stimulsoft Ultimate
Topic: Embedded SS and single quotes
Replies: 8
Views: 1983

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, ...
by David Renner
Wed Dec 29, 2021 3:19 pm
Forum: Stimulsoft Ultimate
Topic: Changing data source
Replies: 8
Views: 2286

Re: Changing data source

The highlighted data source is a MSSQL server, it executes a Stored Procedure. I don't have privilege's to edit that stored procedure. So i copied it, add one line of code to pull in one additional column and now that data source is linked to Midnight_Procs2 (not shown in picture). I kept all the na...
by David Renner
Wed Dec 29, 2021 2:52 pm
Forum: Stimulsoft Ultimate
Topic: Embedded SS and single quotes
Replies: 8
Views: 1983

Re: Embedded SS and single quotes

Version 2020.2.3 from April 29 2020 ASP.net, JS
by David Renner
Tue Dec 28, 2021 3:07 pm
Forum: Stimulsoft Ultimate
Topic: Embedded SS and single quotes
Replies: 8
Views: 1983

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 JOI...
by David Renner
Tue Dec 28, 2021 3:05 pm
Forum: Stimulsoft Ultimate
Topic: What version of embedded SS am i running
Replies: 3
Views: 834

What version of embedded SS am i running

How can i figure out what version of embedded StimulSoft i am running? Can i create a report that returns the version?
by David Renner
Tue Dec 28, 2021 2:59 pm
Forum: Stimulsoft Ultimate
Topic: Changing data source
Replies: 8
Views: 2286

Re: Changing data source

a little more info, one group has 7 data sources with 4 relations, a second group 3 data sources. What i want to do is move one data source from group 1 and put it in group 2. When i do this through the UI, the report breaks and its a very complex report. The difference between the 2 groups is they ...