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

[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.

[Former Member]

Post Author: Chris Chen

CA Forum: WebIntelligence Reporting

Hi,

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

[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!