Xref: alice comp.databases.oracle.tools:37833 Path: alice!news-feed.fnsi.net!newsfeed.icl.net!dispose.news.demon.net!demon!newsfeed.gamma.ru!Gamma.RU!comstar.ru!not-for-mail From: Valeri Sorokine Newsgroups: comp.databases.oracle.tools Subject: Re: Reports 3 Question for those in the know - Including Valeri :-) Date: Wed, 29 Dec 1999 15:57:13 +0300 Organization: ProSoft, Russia, Moscow Message-ID: <386A0529.24F969FC@dd.ru> References: Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Trace: storm.comstar.ru 946472248 25184 195.208.79.22 (29 Dec 1999 12:57:28 GMT) X-Complaints-To: abuse@comstar.ru NNTP-Posting-Date: 29 Dec 1999 12:57:28 GMT To: Ken Halsted X-Mailer: Mozilla 4.05 [en] (Win95; I) Lines: 51 Hello Ken, It's nice to hear from you! Thank you for your question. As far as I know the 'Maximum Records per Page' property means number of recors, not number of lines. So, I you want to restrict your detail frame by 20 lines, you should set the Vertical Elasticity property of the main frame (which is around the detail frame) to 'Fixed'. Set its size big enough to fit all 20 lines of the detail frame. Hope that helps. Let me know if you need more advice... Have a nice New Year! Valeri Ken Halsted wrote: > > I hope I can relay this correctly. I've created a perfectly aligned report > that print's invoices. The only problem is, I have a detail frame (that > only allows 20 items Maximum) that prints the items for each invoice and on > certain items, below it, I am printing a Remark (text field, fixed vertical > and horizontal). Problem is (I think) the remarks are causing my invoices > with 20 lines and a number of remarks to print wrong on the second page if > the invoice overflows to the next page. It's like, Reports doesn't count > but 1 line and is ignoring the remark line. The remark only prints if NOT > NULL. The remark and the items are both in the same repeating frame (which > has the 20 max) on it. > > Any suggestions would be much appreciated. > > Thanks, > > Ken. > > -- > _________________ > Kenneth W. Halsted > Mountaire Corporation > ph: (501) 399-8812 > url: http://www.mountaire.com > email: kenman@mail.snider.net -- Valeri Sorokine Oracle Certified Application Developer, Rel.2 ProSoft, Russia, Moscow, Information Systems Division Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640 E-mail: vsorokin@dd.ru ; http://www.dd.ru