Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Apr 08, 2020 11:59 pm**

hello guys,

I send my query for report as bellow

var testeVea = "select * from cargo where 1=1 ";


		var report = new Stimulsoft.Report.StiReport();

        report.loadFile("reports/Report.mrt");
        report.dictionary.variables.list.find(x=>x.name == "querySql").val = testeVea;

Okay is done! But when I need put condition for string is bad look

Code: Select all


var testeVea = "select * from cargo where 1=1 and Descicao = 'teste' ";


		var report = new Stimulsoft.Report.StiReport();

        report.loadFile("reports/Report.mrt");
        report.dictionary.variables.list.find(x=>x.name == "querySql").val = testeVea;

when I put in my variable [testeVea] ==> ( and Descicao = 'teste' )

the query is stop and my report return blank.

How make query with filter in string???

Posted: **Mon Apr 13, 2020 1:39 pm**

Hello,

Please send us a sample report with test data for analysis.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

erro when send query for variable

erro when send query for variable

Re: erro when send query for variable