Using Query Results From Multiple Queries in a Report

[Guest]

Hi All,

We are developing a dashboard report for site level performance results by
category. Each category result is derived from a separate query. Is there
an easy way to populate a report with values from multiple queries? Sort of
like the Forms Property. [queries].[query1].[query1Field]?

So far I have tried adding sub reports for each individual query. I have
also added each of the individual queries to one query and just pulled down
the values I needed to populate the report. I then linked that new query to
the Report. Both of these worked but I'm just trying to figure out if there
is a better more efficient way to do this.

Thank you for your help.

 

[Guest]

The two approaches you have used are Okay, However, what I ususally do is to
desing one or more query(ies) where I combine various data sources (queries
and/or tables) where I than select just the required data elements, andrename
them with simpler names so I do not have to use
[queries].[query1].[query1Field].
Hope this gives you some idea.
Fons