Page 1 of 1

Query which depends on previous query

Posted: Wed Sep 10, 2014 9:28 am
by FaciWare
Hi,

I've already used parameters in reports, but I asked me if stimulsoft could be have a query which depends on a previous query.

Example (in Access)
qry1 get data from tbl between date1 and date2
qry2 get data from qry1, but for example some columns.

in Stimulsoft:
qry3 is like qry1 in Access
and
qry4 is like qry2 in Access

The error/problem is, stimulsoft search for the query/table in database. Could I say "use the query inside the report"?

Attached there are samples. I hope some one understand me :P

Thanks in advance

Re: Query which depends on previous query

Posted: Wed Sep 10, 2014 11:27 am
by Alex K.
Hello,

Please try to use the "Data from other DataSource" datasource type for this task.

Thank you.

Re: Query which depends on previous query

Posted: Wed Sep 10, 2014 11:57 am
by FaciWare
Hi Aleksey,

thank you for your suggestion. This is a possible way if the result of the query are my "end-data" for the report, but I can't write the next statement based on a previous query to define my data again, right? If not, maybe a feature for the future :D

Re: Query which depends on previous query

Posted: Wed Sep 10, 2014 12:03 pm
by Alex K.
Hello,

Unfortunately, we do not have plans to realize this feature.

Thank you.