Adding a query in the same report

[Former Member]

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.

[Former Member]

Post Author: gchambers

CA Forum: WebIntelligence Reporting

I'm designing a report for a manager and I do not want him to see the report on the "Edit Report" window but on the "Java viewer" (hope I'm using the right terminology here). I am able to apply different time ranges on tables that are based on two different queries IF I run the queries from "Edit Report". However, I'm experiencing the same problem as Marcus if I run the report on the "Java viewer". Is there a way to run the queries with different time ranges separately from the "Java viewer". I have already separated the two tables based on the two different queries into two different "tabs" or "reports", however, the prompts located in the "user prompt input" affect both tabs (I do not experience this issue if I run the queries separately from the "Edit Report" view). Any suggestions? Thank you so much.