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.

long text columns

3 posts in PB Infomaker Report Writer Last posting was on 2001-11-26 21:20:13.0Z
Rick Marden Posted on 1998-01-30 16:35:12.0Z
Newsgroups: sybase.public.infomaker.general
From: "Rick Marden" <rmarden@primavera.com>
Subject: long text columns
Date: Fri, 30 Jan 1998 11:35:12 -0500
Lines: 34
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_U3NLZPZL9GA.206@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7302
Article PK: 244358

We are currently using IM 5.0.03 to provide a variety of different reports.
We have some tabular reports that are used to produce a certain type of
document by selecting one row from the database. The report contains some
text and columns above the header and in the detail there are three nested
reports with a long text data column between the first and second nested
reports. Here is the basic setup:

<address info>
_____________________________________________________
HEADER

nestreport1
remarks
nestreport2
nestreport3
____________________________________________________
DETAIL

All objects in detail have slide up and autosize height turned on.
Summary and footer do not contain anything and have height = 0.

The problem occurs when the data contained in the remarks column causes the
report to go to a second page. When the remarks data begins on the second
page, it starts printing higher on the page than it should, and gets mixed
up with the objects in the header.
We tried to account for this by leaving more space between the header and
the objects above it which does fix the one problem, but now the last line
of text from the remarks column on the first page repeats again on the first
line of the second page.

This is something that happened in InfoMaker 4 as well. Ever heard of this?
Thanks.


Stephen Dupre Posted on 1998-01-31 23:33:25.0Z
Newsgroups: sybase.public.infomaker.general
Date: Sat, 31 Jan 1998 15:33:25 -0800
From: Stephen Dupre <sdupre@powersoft.com>
Reply-To: sdupre@powersoft.com
Organization: Powersoft Tools, Sybase, Inc.
X-Mailer: Mozilla 3.0 (Win16; U)
MIME-Version: 1.0
Subject: Re: long text columns
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 52
Message-ID: <348_34D3B4C5.48E1@powersoft.com>
References: <348_U3NLZPZL9GA.206@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7301
Article PK: 244357


Rick Marden wrote:
>
> We are currently using IM 5.0.03 to provide a variety of different reports.
> We have some tabular reports that are used to produce a certain type of
> document by selecting one row from the database. The report contains some
> text and columns above the header and in the detail there are three nested
> reports with a long text data column between the first and second nested
> reports. Here is the basic setup:
>
> <address info>
> _____________________________________________________
> HEADER
>
> nestreport1
> remarks
> nestreport2
> nestreport3
> ____________________________________________________
> DETAIL
>
> All objects in detail have slide up and autosize height turned on.
> Summary and footer do not contain anything and have height = 0.
>
> The problem occurs when the data contained in the remarks column causes the
> report to go to a second page. When the remarks data begins on the second
> page, it starts printing higher on the page than it should, and gets mixed
> up with the objects in the header.
> We tried to account for this by leaving more space between the header and
> the objects above it which does fix the one problem, but now the last line
> of text from the remarks column on the first page repeats again on the first
> line of the second page.
>
> This is something that happened in InfoMaker 4 as well. Ever heard of this?
> Thanks.

Close up the detail band (to 0 height) and preview again. If you still
get the repeating line on the 2nd printed page, you've hit the
datawindow limit of having all data associated with 1 row fitting on 1
page.

(includes nests, etc).

This is a known limitation. Try composite datawindows where you can
page break between reports. You can place retrieval args at the
composite level to pass to the child reports. In composites, you have
control of page breaks at the end of each report.

If this isn't acceptable, you may need to redesign part of your report.
Sorry.

Stephen


Miiko Posted on 2001-11-26 21:20:13.0Z
Newsgroups: sybase.public.infomaker.general
From: Miiko
Date: Mon, 26 Nov 2001 16:20:13 -0500
Subject: Re: long text columns
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <348_977296D3492C47D00075351F85256B10.005C1F3385256863@webforums>
References: <348_U3NLZPZL9GA.206@forums.powersoft.com> <348_34D3B4C5.48E1@powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.infomaker.general:2661
Article PK: 237261

RE:
...you've hit the
datawindow limit of having all data associated with 1 row fitting on 1
page.

What is the limit of data associated with 1 row to fit on one page?

I am evaluating how to proceed around this limitation.
Thank you!
-Miiko