on ‎2007 Jun 14 12:27 PM
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.
Request clarification before answering.
Post Author: Chris Chen
CA Forum: WebIntelligence Reporting
Hi,
Marcus,I suggest you use this function:"=Userresponse([Query X];"You prompt")".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.