query report

[Former Member]

i have created four different queries and i want to create a query report by combining all those four queries .Is it possible in query reporter??

[Former Member]

> i have created four different queries and i want to

> create a query report by combining all those four

> queries .Is it possible in query reporter??

Hi Swapnil,

If I understood your problem correctly, you can accomplish this with a union query.

For instance:

= = = =

select 'ORDR' as srctable, DocEntry, DocDate, DocTotal from ORDR

union

select 'ODLN' as srctable, DocEntry, DocDate, DocTotal from ODLN

union

select 'OINV' as srctable, DocEntry, DocDate, DocTotal from OINV

= = = =

While this sample query is rather useless in a real-world scenario, it should give you an idea how union queries work. Naturally, the columns need to have the same type and name in each of the queries to be combined.

Regarding on the situation, I sometimes prefer doing the union queries in a MSSQL view and just query the results with the B1 query tools.

Regards,

Henry