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 .
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.