combine 2 queries

[Former Member]

Hi Friends,

We have a requirement to combine 2 queries or generate the report which is there in 2 queries. can any one tell me how can we combine 2 queries and generate the report .

Thanks,

Prasad

[Former Member]

Are you using web templates?

How about putting 1 query above the other one, but set the variable entry (a checkbox in web template properties) to show variables only once?

Then both queries will be run at the same time for the same variable restrictions.

However, each query needs to be downloaded into Excel separately, then merged together if needed.

[Former Member]

Hi,

you can use workbooks that can contain a lot of queries.

Regards,

Veronika.

[former_member185132]

What do you mean by combining two queries? If you want to see the results of the two queries together, you can create a MultiProvider and create a query on top of that. If you want to drill down from one of the queries to another query, you can use RRI

[Former Member]

can u please explain more about RRI

[former_member185132]

Please use the search. http://help.sap.com/saphelp_nw04s/helpdata/EN/99/08629bd3e41d418530c6849df303c9/content.htm .

There is more material on help.sap and also in these forums on RRI.