cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Adding a query in the same report

Former Member
0 Likes
606

Post Author: Marcus

CA Forum: WebIntelligence Reporting

Hi,

I am slightly baffled. I want to set up a series of queries in the same document but each as a new report.

For instance my data relates to Banks and Counterparties. My first query I want to return the data on both of these.

Then I want to add a new query on a second report that just shows me the data relating to Banks and so on. Now the problem is that when I set the filter in the second query it seems to change the filter in the first query as well. As a result the results in both the reports are the same but I distinctly want different results.

Am I trying to do the impossible here. I would not have thought so. Is this possible and if so how do I go about doing it?

Also when adding a second query in the same document does the objects chosen in each query have to be exactly the same Ie if I add another data colum to one query must I also add it to the others?

Thanks,

Marcus.

View Entire Topic
Former Member
0 Likes

Post Author: Chris Chen

CA Forum: WebIntelligence Reporting

Hi,

Marcus,I suggest you use this function:"=Userresponse([Query X];"You prompt")".