[solved]Adding Page Breaks to Report

[BIsrik]

Hi

I have two report pages in my report. Page 1 has list on query1 and page 2 has list on query2. Can i set the page break for only the second page. I don't want to set the page break for page1.

I tried setting the page break but it gets applied to both the pages. Any suggestion of achieving this...

Srik

[MrO]

On what do your pages have to break? Sections? Number of rows? ...?

[BIsrik]

i want them to breaked on a grouped column.

Srik

[Boris-A]

Interesting,

The problem that I see is not as much as adding a page break for page 2 as much as it's gonna be the repeating of page 1 for every page break on page 2..!!

ie.
Page 1
Page 2 (1st of 3)
Page 1
Page 2 (2nd of 3)
Page 1
Page 2 (3rd of 3)

Adding the page break for page 2 is not a problem (at least not to me).  I have only added a grouping with the page breaks on that grouping...and that works fine (as it is only applied to page 2).

But big big problem for the repeating page 1... tried to find a solution by having conditional style to "hide" page 1 when the page number is greater than 1 but no success..!!

[Boris-A]

Adding a page break on a grouped column:

Go to report pages,
Click on Page break icon at bottom,
Select your query 2 in the drop down list,
Select "Page Breaks by grouping levels(recommended)",
Select your grouped column to have the page break on.

If this doesn't work you have a problem.

cheers

[BIsrik]

i have done the same thing...During page break it does not have an option saying use page break on these pages. It just asks the query and grouped column for the page break.

I use query1 for the summary info and query2 for detail infor. Summary info should come in first page( and doesnot spans more than one page also) and the details in the subsequent pages. The detail report has a page break on time period.

Now when i set the page break the summary infor comes in the third, fourth....all the pages. How should i achieve this..

Srik

[Prad]

Hi,

can you do it using master - detail report.......
or
try this

take the query that you are implementing the page break and associate it with the entire page.

1) go to the design view of the page.
2) select the entire page
3) in the properties page under query -> choose the query that you are doing page break on.

Let me know the result.

Prad.

[BIsrik]

I don't feel master detail would help me out...

and ur suggestion didn't work...The page1 data gets repeated for every page break of page2.

Srik

[BIsrik]

it was a simple soln...

When ever u select the query on which u want the page break, u have the grouped columns visible. select the grouped column and even select the overall..

Then u can move the page on which there is no page break to header or footer depending on the requirement.

Thats it...

Srik