Query which depends on previous query

Stimulsoft Reports.NET discussion
Post Reply
FaciWare
Posts: 6
Joined: Thu Jan 17, 2013 11:49 am

Query which depends on previous query

Post 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
Attachments
StimulsoftTest02.zip
(19.27 KiB) Downloaded 335 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Query which depends on previous query

Post by Alex K. »

Hello,

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

Thank you.
Attachments
StimulsoftTest02_modified.mrt
(4.64 KiB) Downloaded 340 times
FaciWare
Posts: 6
Joined: Thu Jan 17, 2013 11:49 am

Re: Query which depends on previous query

Post 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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Query which depends on previous query

Post by Alex K. »

Hello,

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

Thank you.
Post Reply