Hi,
I need put data from different queries in my report, but i want to see them in order: first all data from one query, then data from another query. Is there any way to do this?
Hi,
I need put data from different queries in my report, but i want to see them in order: first all data from one query, then data from another query. Is there any way to do this?
create 2 sub report, one for each query
but if you have big batch of data calculating this report takes too much time every time when you want run this repotr
I don't think sub reports make more calculations.
If you have time-consuming calculation in you queries, any way they cost you long time unless you create temporary table for the result, then the report get data directly from the temp table.
This solution is good for those the data don't change frequently in the source table, because once the source table is changed, you need to re-create the temp table to reflect the changes.
Hello,
Forget about this method for a moment (I know subreports are good approach, but not in my case). Maybe, is any way to create some code which force every field from different queries to show data one after another, for example:
Query 1 has data: A1; A2; A3...
Query 2 has data: B1; B2; B3...
Query 3 has data: C1; C2; C3...
and I need something like that:
A1
A2
A3
B1
B2
B3
C1
C2
C3
.
.
.
Any suggestions?
use union query:
select * from query1 union all select * from query2 union all select * from query3
the condition is: you must have save number of fields and same field type in all three queries(tables).
union query isn't working for me, because i have 20 different queries which different fields inside, for example:
Pipe: line number; code; description; length; weight
Elbow: line number; code; description; quantity; weight
I think about something like possibility to expand field with data up to showing all data from one query and then showing data from another query etc.