Oracle Reports 2.5: Help with page breaks

From: Tom Kanary <tekanary_at_on.bell.ca>
Date: 1997/03/27
Message-ID: <333A9260.5C9A_at_on.bell.ca>#1/1

Help,

        I am using oralce reportwriter (Developer 2000/1.3) on Solaris 2.5 to create a report. r25desm & r25runm

        This report is a bit complex where there is a master record ( Service Order) which has 1 or more Services. Each Service reflects an inventory of equipment at a location. There may be 1 or more different types of equipemnt and 1 or more types of the same type of the equipment.

        What I must do is to create a report, given only the Service Order Number, which is organized like so:

1. Master Service Order
2. First Service 2.1) 0 or more frames of equip type 1 2.2) 0 or more frames of equipment type 2 and so on
3. Next Service 3.1) ....

	Now the data modal tool allows me to specific the 
	logic ok but I have problems with the layout.

	I put the Servie info into a repeating frame (S)
	and after printing some generic Service info I have
	a series of repeating frames ( E1, E2, ....)
	Remember S may have 1 E1 , 2 E7s etc) so the report 
	must shrink or expand depending on the Service Order.
	I need corrent page numbers and no blank pages. Several
	Enn frames can fit on a page . If a Enn frame cannot fit
	on the current page , it should start on the next 
	page.

	Now all worked well until S ( with its enclosed Enn) 
	could no longer fit on a physical. Then I had to 
	modify the report properties to have multiple physical
	pages per logical page. Once I did that all Enn frames 
	which by default would start on a new phyical page
	if they could not fit on the current page now start
	on the current page and continue on the next physical
	page. All options to control page printing appear
	to work on a logical page so if I force a page break,
	I get 2-3 blanks physical pages.


	My options appear to be
	1) find a way to get reportwriter to do the right thing,
		ie consume blank pages, start frames on physical
		page boundaries, etc . I need HELP here.

	2) not to use the data modal linkages and to create the
		final report as a series of individual queries.
		( I can make the queries but I can't figure
		out how to make sure the Enns for S1 are printed
		immediately after S1, followed by S2 with its Enn
		records, etc.) 

	3) something else ???, perhaps use plsql triggers in
	some way.



_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


_/  Tom Kanary                   _/  Email: tekanary_at_on.bell.ca   _/

_/  Bell Sygma                   _/         TEKANARY              _/

_/  160 Elgin RM 1950            _/  Phone: 613-830-6917          _/


_/  Ottawa, Ont, Ca, K2P 2C4     _/  Fax:   613-781-3620          _/

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Received on Thu Mar 27 1997 - 00:00:00 CET