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

CA Forum: WebIntelligence Reporting

im not sure from what you are talking about here

but if its related to prompt to many queries in the same report

if you make the prompt text the same,, then you will get one prompt for all ur quereis

but if you gave a different prompt text for every query paramter, then you will get a different prompts.

like Q1 Prompt = "Enter Current Year"

Q2 Prompt = "Enter Last Year"

- you will get two prompots for every paramater

but if you made it like :-

Q1 Prompt = "Enter Current Year"

Q2 Prompt = "Enter Current Year"

you will get only one prompt for both of you queries,

and i dont think you've have to run the report in the EDIT REPORT mode

EDIT REPORT mode , just to create the report, then Save it

and run it from the peviewer lately

thank you

Amr