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.

Detail band text overlapping in next page header in Composite dwo problem

4 posts in DataWindow Last posting was on 2008-05-08 07:50:09.0Z
RMK.B Posted on 2008-05-02 10:47:17.0Z
From: "RMK.B" <rammuralikrishnanb@zylog.co.in>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Detail band text overlapping in next page header in Composite dwo problem
Lines: 1574
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <481af135@forums-1-dub>
Date: 2 May 2008 03:47:17 -0700
X-Trace: forums-1-dub 1209725237 10.22.241.152 (2 May 2008 03:47:17 -0700)
X-Original-Trace: 2 May 2008 03:47:17 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86760
Article PK: 416018

Hi all,

The following is my composite dwo details.

dw_composite > which is a composite dwo and has the following child dwo's.
dw_header_top
dw_doc_detail
dw_doc_lines
dw_footer

The dw_header_top, dw_doc_detail and dw_footer dwo's will always have a
single row.
The dw_doc_lines may have >= 1 row(s).

Now my problem is dw_doc_lines dwo. The dw_doc_lines dwo is a tabular dwo
and has a header and detail. The "Auto size height" property is set for the
detail band of the dw_doc_lines dwo and the text columns in the detail band.

The auto size height is working perfect. But if a row detail has huge detail
then it's overlapped with the next page header and the report looks awkward.

Now, I want to avoid the detail band overlapping in successive pages.

Any round-about or solutions is appreciated.

Note:
1. Please check the attached image which shows the overlapping of the Page 3
details of the report in Page 4. Actually the details overlapped in
the 4th page detail which should be displayed down after the header.
2. If we check the dw_doc_lines dwo alone there is no overlapping issue.
3. Also, removed all dwo's except the dw_do_lines dwo in the composite dwo
and checked. The overlapping issue occurs though the composite dwo has a
single
dwo alone.

TIA
Rammurali Krishnan B


RMK.B Posted on 2008-05-02 10:56:56.0Z
From: "RMK.B" <rammuralikrishnanb@zylog.co.in>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <481af135@forums-1-dub>
Subject: Re: Detail band text overlapping in next page header in Composite dwo problem
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <481af378$1@forums-1-dub>
Date: 2 May 2008 03:56:56 -0700
X-Trace: forums-1-dub 1209725816 10.22.241.152 (2 May 2008 03:56:56 -0700)
X-Original-Trace: 2 May 2008 03:56:56 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86761
Article PK: 416020

I Am using PB Version 10.2.0 and Build 7516.

"RMK.B" <rammuralikrishnanb@zylog.co.in> wrote in message
news:481af135@forums-1-dub...
> Hi all,
>
> The following is my composite dwo details.
>
> dw_composite > which is a composite dwo and has the following child dwo's.
> dw_header_top
> dw_doc_detail
> dw_doc_lines
> dw_footer
>
> The dw_header_top, dw_doc_detail and dw_footer dwo's will always have a
> single row.
> The dw_doc_lines may have >= 1 row(s).
>
> Now my problem is dw_doc_lines dwo. The dw_doc_lines dwo is a tabular dwo
> and has a header and detail. The "Auto size height" property is set for
> the
> detail band of the dw_doc_lines dwo and the text columns in the detail
> band.
>
> The auto size height is working perfect. But if a row detail has huge
> detail
> then it's overlapped with the next page header and the report looks
> awkward.
>
> Now, I want to avoid the detail band overlapping in successive pages.
>
> Any round-about or solutions is appreciated.
>
> Note:
> 1. Please check the attached image which shows the overlapping of the Page
> 3
> details of the report in Page 4. Actually the details overlapped in
> the 4th page detail which should be displayed down after the header.
> 2. If we check the dw_doc_lines dwo alone there is no overlapping issue.
> 3. Also, removed all dwo's except the dw_do_lines dwo in the composite dwo
> and checked. The overlapping issue occurs though the composite dwo has a
> single
> dwo alone.
>
> TIA
> Rammurali Krishnan B
>
>
>
>


Dave Fish [TeamSybase] Posted on 2008-05-06 08:32:29.0Z
From: "Dave Fish [TeamSybase]" <n0Spam__dfish@sybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Detail band text overlapping in next page header in Composite dwo problem
Organization: TeamSybase
Reply-To: n0Spam__dfish@sybase.com
Message-ID: <jr50245bhuosm0ce0qncic2e49pdj063du@4ax.com>
References: <481af135@forums-1-dub> <481af378$1@forums-1-dub>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 6 May 2008 01:32:29 -0700
X-Trace: forums-1-dub 1210062749 10.22.241.152 (6 May 2008 01:32:29 -0700)
X-Original-Trace: 6 May 2008 01:32:29 -0700, vip152.sybase.com
Lines: 65
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86780
Article PK: 416038

I'm not sure if it would resolve the issue but we introduced autosize
height for all bands in 10.5. Might be worth downloading an evaluation
copy of 11 and seeing if using that feature fixes your report.

Regards,
Dave Fish
Sybase

PowerBuilder Blog:
http://powerbuilderevangelist.blogspot.com/

On 2 May 2008 03:56:56 -0700, "RMK.B" <rammuralikrishnanb@zylog.co.in>

wrote:

>I Am using PB Version 10.2.0 and Build 7516.
>
>"RMK.B" <rammuralikrishnanb@zylog.co.in> wrote in message
>news:481af135@forums-1-dub...
>> Hi all,
>>
>> The following is my composite dwo details.
>>
>> dw_composite > which is a composite dwo and has the following child dwo's.
>> dw_header_top
>> dw_doc_detail
>> dw_doc_lines
>> dw_footer
>>
>> The dw_header_top, dw_doc_detail and dw_footer dwo's will always have a
>> single row.
>> The dw_doc_lines may have >= 1 row(s).
>>
>> Now my problem is dw_doc_lines dwo. The dw_doc_lines dwo is a tabular dwo
>> and has a header and detail. The "Auto size height" property is set for
>> the
>> detail band of the dw_doc_lines dwo and the text columns in the detail
>> band.
>>
>> The auto size height is working perfect. But if a row detail has huge
>> detail
>> then it's overlapped with the next page header and the report looks
>> awkward.
>>
>> Now, I want to avoid the detail band overlapping in successive pages.
>>
>> Any round-about or solutions is appreciated.
>>
>> Note:
>> 1. Please check the attached image which shows the overlapping of the Page
>> 3
>> details of the report in Page 4. Actually the details overlapped in
>> the 4th page detail which should be displayed down after the header.
>> 2. If we check the dw_doc_lines dwo alone there is no overlapping issue.
>> 3. Also, removed all dwo's except the dw_do_lines dwo in the composite dwo
>> and checked. The overlapping issue occurs though the composite dwo has a
>> single
>> dwo alone.
>>
>> TIA
>> Rammurali Krishnan B
>>
>>
>>
>>
>


RMK.B Posted on 2008-05-08 07:50:09.0Z
From: "RMK.B" <rammuralikrishnanb@zylog.co.in>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <481af135@forums-1-dub> <481af378$1@forums-1-dub> <jr50245bhuosm0ce0qncic2e49pdj063du@4ax.com>
Subject: Re: Detail band text overlapping in next page header in Composite dwo problem
Lines: 84
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4822b0b1$1@forums-1-dub>
Date: 8 May 2008 00:50:09 -0700
X-Trace: forums-1-dub 1210233009 10.22.241.152 (8 May 2008 00:50:09 -0700)
X-Original-Trace: 8 May 2008 00:50:09 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86793
Article PK: 416051

Thanks Dave.

I think, it's PB technical issue, PB is not considering child dwo header in
successive pages within a composite dwo and starts header band and detail
band values from the same position. Autosize height property is also not
resolving the issue.

Please send your suggestions/ feedback.

Rammurali Krishnan B

"Dave Fish [TeamSybase]" <n0Spam__dfish@sybase.com> wrote in message
news:jr50245bhuosm0ce0qncic2e49pdj063du@4ax.com...
> I'm not sure if it would resolve the issue but we introduced autosize
> height for all bands in 10.5. Might be worth downloading an evaluation
> copy of 11 and seeing if using that feature fixes your report.
>
> Regards,
> Dave Fish
> Sybase
>
> PowerBuilder Blog:
> http://powerbuilderevangelist.blogspot.com/
>
> On 2 May 2008 03:56:56 -0700, "RMK.B" <rammuralikrishnanb@zylog.co.in>
> wrote:
>
>>I Am using PB Version 10.2.0 and Build 7516.
>>
>>"RMK.B" <rammuralikrishnanb@zylog.co.in> wrote in message
>>news:481af135@forums-1-dub...
>>> Hi all,
>>>
>>> The following is my composite dwo details.
>>>
>>> dw_composite > which is a composite dwo and has the following child
>>> dwo's.
>>> dw_header_top
>>> dw_doc_detail
>>> dw_doc_lines
>>> dw_footer
>>>
>>> The dw_header_top, dw_doc_detail and dw_footer dwo's will always have a
>>> single row.
>>> The dw_doc_lines may have >= 1 row(s).
>>>
>>> Now my problem is dw_doc_lines dwo. The dw_doc_lines dwo is a tabular
>>> dwo
>>> and has a header and detail. The "Auto size height" property is set for
>>> the
>>> detail band of the dw_doc_lines dwo and the text columns in the detail
>>> band.
>>>
>>> The auto size height is working perfect. But if a row detail has huge
>>> detail
>>> then it's overlapped with the next page header and the report looks
>>> awkward.
>>>
>>> Now, I want to avoid the detail band overlapping in successive pages.
>>>
>>> Any round-about or solutions is appreciated.
>>>
>>> Note:
>>> 1. Please check the attached image which shows the overlapping of the
>>> Page
>>> 3
>>> details of the report in Page 4. Actually the details overlapped in
>>> the 4th page detail which should be displayed down after the header.
>>> 2. If we check the dw_doc_lines dwo alone there is no overlapping issue.
>>> 3. Also, removed all dwo's except the dw_do_lines dwo in the composite
>>> dwo
>>> and checked. The overlapping issue occurs though the composite dwo has a
>>> single
>>> dwo alone.
>>>
>>> TIA
>>> Rammurali Krishnan B
>>>
>>>
>>>
>>>
>>