Home » Developer & Programmer » Reports & Discoverer » Page Break Qtn. - pls. help..
Page Break Qtn. - pls. help.. [message #488502] Sat, 08 January 2011 03:40 Go to next message
Maverick27
Messages: 84
Registered: October 2008
Member
Can somebody pls. help me create a PAGE BREAK in my Report ?

My report is made up of 2 Groups. I want to create a Page Break on 2'nd Grp.

See attached image of my Report.

I want to create a PAge Break btwn 'Antique Brass' & 'Brass'

I set a 'Page Break' & 'PAge Break After' to YES on Repeating Frame of GROUP 2 but it's not working ?!
Re: Page Break Qtn. - pls. help.. [message #488527 is a reply to message #488502] Sat, 08 January 2011 13:37 Go to previous messageGo to next message
Littlefoot
Messages: 21509
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Set Group 2's "Maximum records per page" property to "1" (one). Also, you might set "Page protect" property to "Yes".
Re: Page Break Qtn. - pls. help.. [message #488581 is a reply to message #488527] Mon, 10 January 2011 00:16 Go to previous messageGo to next message
Maverick27
Messages: 84
Registered: October 2008
Member
If i set it to ONE, it will ONLY show 1 GRP per page which is NOT what i want. see attachment.

I want to achieve a PAge Break btwn different Groups in GRP2.

Mave
  • Attachment: Rep.JPG
    (Size: 36.92KB, Downloaded 447 times)
Re: Page Break Qtn. - pls. help.. [message #488588 is a reply to message #488581] Mon, 10 January 2011 01:00 Go to previous messageGo to next message
Maverick27
Messages: 84
Registered: October 2008
Member
Hi Littlefoot - i've created another Report, this time with 3 Groups. I'll to achieve Page Break with this one. If i get stuck, i'll let u know.

Thank - MAve
Re: Page Break Qtn. - pls. help.. [message #615212 is a reply to message #488502] Sat, 31 May 2014 23:07 Go to previous messageGo to next message
jwang02
Messages: 26
Registered: May 2014
Location: Indiana
Junior Member
I have a report with three-groups query linked to another one-group query.

On Layout, the 1st query three groups are on the top: 3rd group is in repeating frame between many 2nd group fields, and the 2nd query group is also in a repeating frame, as a 2nd layout merged into the 1st one, in the bottom. The link is the 2nd group's Emp_ID.

I set Maximum Record per Page to 1 on 2nd group and Page Break After to one of 4th group fields.

Now every new Emp_ID has a new page, but all the first three group fields are repeating on the new page.

What I want is only 4th group fields continuing to new page, not the first three group fields. How to make changes on it?

[Updated on: Sat, 31 May 2014 23:14]

Report message to a moderator

Re: Page Break Qtn. - pls. help.. [message #615214 is a reply to message #615212] Sat, 31 May 2014 23:39 Go to previous messageGo to next message
Littlefoot
Messages: 21509
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Let the first 3 groups print on the "First page" by setting that property in the Property Palette window. Now, it is set to "All pages", I guess.
Re: Page Break Qtn. - pls. help.. [message #615256 is a reply to message #615214] Sun, 01 June 2014 08:44 Go to previous messageGo to next message
jwang02
Messages: 26
Registered: May 2014
Location: Indiana
Junior Member
Thanks, Littleoot! I changed to 'First Page' and it's working now.
Re: Page Break Qtn. - pls. help.. [message #616402 is a reply to message #615214] Mon, 16 June 2014 10:40 Go to previous message
jwang02
Messages: 26
Registered: May 2014
Location: Indiana
Junior Member
A new problem is found on the report:

The report title and page number show up on 1st & 2nd page, no matter the two pages are empty or not.

I set 'First Page' on Print Object On, and only need title/page number on the 1st page and no 2nd empty page.

I tried to move title/page number from Paper Layout/Main Section/Margin to Header Section/Margin, and now if the report is empty, I got the 1st page with title/page number(that's OK) and other two empty pages with nothing on them (I don't want the 2 extra empty pages).

Finally I found there is a line set on the bottom on the report with Page Break Before: Yes, and changed to No. No extra empty page come out. The problem is resolved.

[Updated on: Mon, 16 June 2014 13:01]

Report message to a moderator

Previous Topic: add new matrix report to matrix report Previously created
Next Topic: Oracle Report issue
Goto Forum:
  


Current Time: Wed Nov 13 06:15:12 CST 2019