Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Insert Page Break

2 posts in General Discussion (Chinese) Last posting was on 2009-01-20 12:17:29.0Z
Ang Posted on 2009-01-07 08:39:23.0Z
Sender: 5023.4964693b.1804289383@sybase.com
From: Ang
Newsgroups: sybase.public.chinese.powerbuilder.general
Subject: Insert Page Break
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49646a3b.506f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jan 2009 00:39:23 -0800
X-Trace: forums-1-dub 1231317563 10.22.241.41 (7 Jan 2009 00:39:23 -0800)
X-Original-Trace: 7 Jan 2009 00:39:23 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:435
Article PK: 104459

I have a report with 300 records and each record has 7 to 9
lines to print, If I consider an A4 size paper, exactly two
records can fit on each page. Is it possible that I insert
page break in such a fashion, it only prints entire record
on a page, otherwise it may break page and print entire
record on other page.


Arnoud Oortwijk Posted on 2009-01-20 12:17:29.0Z
Sender: 4893.4974a4f5.1804289383@sybase.com
From: Arnoud Oortwijk
Newsgroups: sybase.public.chinese.powerbuilder.general
Subject: Re: Insert Page Break
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4975c0d9.6230.1681692777@sybase.com>
References: <49646a3b.506f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Jan 2009 04:17:29 -0800
X-Trace: forums-1-dub 1232453849 10.22.241.41 (20 Jan 2009 04:17:29 -0800)
X-Original-Trace: 20 Jan 2009 04:17:29 -0800, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.chinese.powerbuilder.general:439
Article PK: 104463

You can only force a page break on a group.

if you cannnot define a group per 2 records by logic, you
can force this by adding a computable column to the
resultset and set a group on this column. After retrieving
the DW you'll have to itterate over all rows and set a value
e.g. the page number for every two rows. For example. the
first two rows get value 1 row3 and 4 get value 2 etc.
When you call GroupCalc() after this you should get the
result you're looking for.

HTH

Arnoud

> I have a report with 300 records and each record has 7 to
> 9 lines to print, If I consider an A4 size paper, exactly
> two records can fit on each page. Is it possible that I
> insert page break in such a fashion, it only prints entire
> record on a page, otherwise it may break page and print
> entire record on other page.