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.

Suppress Repeating Rows vs Filter

2 posts in DataWindow Last posting was on 2008-09-24 15:34:14.0Z
lfenceroy Posted on 2008-09-24 14:53:34.0Z
Sender: 75d0.48da5405.1804289383@sybase.com
From: lfenceroy
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Suppress Repeating Rows vs Filter
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48da546e.75de.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Sep 2008 07:53:34 -0700
X-Trace: forums-1-dub 1222268014 10.22.241.41 (24 Sep 2008 07:53:34 -0700)
X-Original-Trace: 24 Sep 2008 07:53:34 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87837
Article PK: 417092

Hello,

Trying to create report to suppress repeating rows which
works; however there is a blank line that is being displayed
in the result set. A filter function was considered but
cannot figure how to implement.

Any suggesstions...

Thanks...

LaChandra


Chris Werner Posted on 2008-09-24 15:34:14.0Z
From: "Chris Werner" <cwAT{PleaseNoSpam}f-s.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48da546e.75de.1681692777@sybase.com>
Subject: Re: Suppress Repeating Rows vs Filter
Lines: 40
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.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48da5df6@forums-1-dub>
Date: 24 Sep 2008 08:34:14 -0700
X-Trace: forums-1-dub 1222270454 10.22.241.152 (24 Sep 2008 08:34:14 -0700)
X-Original-Trace: 24 Sep 2008 08:34:14 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87838
Article PK: 417093

Hi LaChandra,

in case the rows are ordered by the columns which
indicate a row is a repeated one you can use a filter
like this:

colA <> colA[-1] and colB <> colB[-1] ...

where colA and colB are this columns

Because I'm paranoid I'd code it using extra braces:

(colA <> colA[-1]) and (colB <> colB[-1]) ...

Don't try that for computed fields, that won't work.
Use the underlying column instead.

HTH

Chris Werner
f+s software gmbh



<lfenceroy> schrieb im Newsbeitrag
news:48da546e.75de.1681692777@sybase.com...

> Hello,
>
> Trying to create report to suppress repeating rows which
> works; however there is a blank line that is being displayed
> in the result set. A filter function was considered but
> cannot figure how to implement.
>
> Any suggesstions...
>
> Thanks...
>
> LaChandra