Creating reports and dashboards | Stimulsoft community forum

Dear Stimulsoft,

I have 2 datasource and 1 variable

variable1:
var1 = 1

datasource1:
select costcenter from system where id = {var1} // result string 'cc between 1 and 10'

datasource2:
select * from invoice where id={docid} and {datasource1.costcenter}

and i got error message 'data not found' every time i run it.
i need both datasource run sequence. How to do it? please help me. Thank you

Hello.

Please, send us your report template with sample data for analysis.

Thank you.

Here is my mrt file.

Hello.

Sorry, but we couldn't reproduce your issue without data.

You don't need to to declare variables. It's possible to use our variables exactly in query, the string is inserted without quotation marks.
Following this note it seems that the error occurs at this lines: You could use the variable exactly in the query: Thank you.