Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 58

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 13th April 2019, 12:45
Arlina Arlina is offline
Junior Member
Join Date: Feb 2019
Posts: 12
Arlina is on a distinguished road
Baan: Infor LN - DB: MSSql - OS: Windows
New Page in Report
Baan: ERP LN 6.1 FP9 (Infor ERP 10.3)
C/S: None/Unknown


Can I get in report script if sufficient lines are remaining on page?Accordingly the layout would be printed on same page or next page.

Reply With Quote
Old 13th April 2019, 12:55
bdittmar's Avatar
bdittmar bdittmar is offline
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,764
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
need ?

are you searching for:
Report script functions
The statements programmed in a report script section consist of a combination of 3GL programming language features: overview and the following 4GL report functions:

layout.again() Evaluate and print layout again. 
need( expr ) Force a page break if the number of free lines is less than expr. 
page() Start a new page. 
reset.suppress() It is possible to suppress printing a value when it is the same as the previous value. You can use this function to suppress the value once (that is, for one value). 
skip( expr ) Skip expr number of lines before printing the next layout. expr ) Skip to the line number indicated by expr. Intervening lines are left blank. If the specified line number is less than the current page number, a new page is started. expr ) Start a new page with number expr. 
You cannot use need(), page(), skip(),, or in header and footer layouts.
Reply With Quote
Old 15th April 2019, 05:47
Arlina Arlina is offline
Junior Member
Join Date: Feb 2019
Posts: 12
Arlina is on a distinguished road
Baan: Infor LN - DB: MSSql - OS: Windows
It is already working with need(expr).
I just wanted to confirm if change in page size would affect it or not.

Reply With Quote
Old 16th April 2019, 13:26
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,229
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Yes - changing the page size would impact the output. So lets say you have need(5) lines and page size is 50, and you currently on line 46. It would do the page command and then print. But if the page size was 55 and still on line 46 it would print the 5 lines on the current page.

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Invoices printing issue-display last record with 2 lines tracylee Tools Development 7 20th October 2017 10:51
Skip page in report rduncan10 Tools Development 2 21st March 2014 16:24
Page x of y: Kevin Brock's solution. ~Vamsi Code & Utilities 4 5th January 2006 11:08
Baan Performance Tracing Questions thomas_b Performance & Tuning 5 25th July 2005 11:22
How to specify report page sizing for a non printer device Jabran Tools Development 1 3rd August 2004 12:39

All times are GMT +2. The time now is 20:12.

©2001-2018 - -