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: jsanzone

CA Forum: WebIntelligence Reporting

Marcus,

I am not sure why you are having such difficulties with your report, but to give you the "short and get you through the day answer", here goes:

Upon going into your report in "Modify" mode and the report runs and presents you with the information in the first tab (so far so good, right), you can click on the Edit Query mode. Then, hover your mouse at the tab "Query 1" and right-click, then choose "Add Query". You'll be presented with a new query page (Query 2) which you can now develop independently from your first query. When you are done, you can click on the "Run Query" option (and now you'll notice a drop-down next to it where you can choose to run all queries or just Query 1 or Query 2. Bottom line is you need to execute your new report, either en-masse or separately. When you run your new report you'll get prompted on what to do with the new output (you'll have three options: add as a new grid to your old report, add as a new grid in a new report, or don't do anything). I would recommend the option to add as a new grid in a new report. From here on out you should be able to work your two reports independently and without too much more problems. There are a couple of other ways to handle the requirement you are faced with, however, with the difficulties you've already stated I think that the solution I propose will get you through the day.

Good luck!