I have two lists on a same page. Both the lists uses different queries. like Q1 for List1 and Q2 for List2. I wanted to set page breaks for both queries.
How should i do this. if this is not possible suggest me some alternate methods.
Srik
On which query do you want the page break Q1 / Q2 or on Q1 and Q2?
Have you tried it by creating a parent query with child relations to Q1 and Q2?
So
Q3 (Parent) -> Q1 (Child)
Q3 (Parent) -> Q2 (Child)
and set the page break on Q3.
I think this is the way I should do it.
i wanted to page breaks on both Q1 and Q2. There is no relations b/w Q1 and Q2. The user just selects from a prompt which Query to execute.
If i have page1 for Q1 and page2 for Q2, and when the selected to execute Q2 then i get first a blank page of page1 and then the Q2 comes in page2.
Please tell me how should i do solve this..
Srik
I'm going to take a look at this Friday, because i'm doing this all by head (it's my day off :D)
But if I understand you correctly the user chooses which query to run and based on that query the page break must be set. I think it's not possible in a normal way. What you can do is the following:
Build a report for each query and in that report you set the page breaks the way you want it.
Next you create another report in which you set 2 drill-througs to each of the queries. This should solve it.
So:
Report 1 -> List 1 with Q1 and the necessary page breaks
Report 2 -> List 2 with Q2 and the necessary page breaks
Report 3 -> List 3 with Q3 (which is a dummy query only 2 rows must be returned) with drill-througs to Q1 and Q2
Report 3 functions like a "prompt page"
This should solve it.
Let me know if this works
fine...When asked the same in cognos they said set the drill b/w pages. They said create page1 for ur index page and then create page2 and 3 for ur queries. drill from page1 to 2 or 3 from the user input.
But i couldn't find where to set this drill b/w pages...Any help on this...
Srik
Look in the properties of you query item... Do you see the drill through option there?
i see a property of drill through of a query item (which can be used to set the drill through b/w reports) and not for a query. How will that help me setting up drill through b/w pages of the same report...
Srik
Hi BIsrik,
It can't be done with 1 report.
You have to create 3 reports:
Report1 with Q1
Report2 with Q2
Report3 with drill through to Report1 and Report2
What's the status of this topic. I closed it. Plz let us now if you succeeded and if it worked