[Solved] Page Breaks

[BIsrik]

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

[sir_jeroen]

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.

[BIsrik]

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

[sir_jeroen]

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

[BIsrik]

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

[sir_jeroen]

Look in the properties of you query item... Do you see the drill through option there?

[BIsrik]

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

[sir_jeroen]

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

[sir_jeroen]

What's the status of this topic. I closed it. Plz let us now if you succeeded and if it worked