Skip to Content
Former Member
Jan 25, 2011 at 10:26 PM

Creating report with multiple queries in clear quest



I am new to reports and currently working with creating reports that connect to clear quest(CQ).

I have successfully created several reports, that connect to the CQ, but they all have data from only one query.

Now I am trying to create a slightly complex report where I need to fetch data from multiple queries. All these queries use 2 parameter to filter their data. I have dynamic cascading parameters to get them. When just connecting they all work ok. I used the link tab to link them to two fields of one query, to make sure that they all filter to fields from same query.

The problem is when I drop the fields from the various queries on the form, the data is fetched multiple times.

I also played with links to make them outer links but in that case I get error and unable to run the report completely.

Any ideas on how to work with multiple queries and provide same parameters to all of the queries?

Thanks in advance.