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.

repeating value suppression

3 posts in PB Infomaker Report Writer Last posting was on 1998-06-26 16:37:59.0Z
Linda Dickert Posted on 1998-06-23 19:34:43.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 23 Jun 1998 15:34:43 -0400
From: Linda Dickert <ldickert@tcl.tec.sc.us>
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
Subject: repeating value suppression
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 9
Message-ID: <348_35900353.FA5C2759@tcl.tec.sc.us>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7036
Article PK: 243065

If any of the columns value are the repeats in a previous row I want to
suppress the data and then print the next row. I have sorted the data in
the following order: col 1 col 2 col 3. I used select distinct
in my SQL logic, but it does not seem to work..
I would like to suppress the 2nd row of a repeated id code.
Any Suggestions?


DawnBrownEyes[TeamPS] Posted on 1998-06-26 16:37:59.0Z
Newsgroups: sybase.public.infomaker.general
From: "DawnBrownEyes[TeamPS]" <browneyd@kochind.com>
Subject: Re: repeating value suppression
Organization: TeamPS
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Fri, 26 Jun 1998 12:37:59 -0400
Lines: 19
Message-ID: <348_01bda129$42d5c980$27e9d192@kii-201520>
References: <348_35900353.FA5C2759@tcl.tec.sc.us>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7030
Article PK: 243060

Have you tried: In the dw painter: Menuitem: Rows, Suppress Repeating
Values ...

If you haven't solved it yet,

What does the output look like? And then what do you want it to look like?
I am having a hard time understanding the problem.


--
Dawn T Brown Eyes (TeamPS)

Linda Dickert <ldickert@tcl.tec.sc.us> wrote in article
<35900353.FA5C2759@tcl.tec.sc.us>...
> If any of the columns value are the repeats in a previous row I want to
> suppress the data and then print the next row. I have sorted the data in
> the following order: col 1 col 2 col 3. I used select distinct
> in my SQL logic, but it does not seem to work..
> I would like to suppress the 2nd row of a repeated id code.
> Any Suggestions?
>
>
>


Terry Dykstra [TeamPS] Posted on 1998-06-24 19:03:24.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: repeating value suppression
Date: Wed, 24 Jun 1998 13:03:24 -0600
Lines: 33
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_jNkyjSIo9GA.133@forums.powersoft.com>
References: <348_35900353.FA5C2759@tcl.tec.sc.us>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7032
Article PK: 243061

I answered a similar question a little while back. Here is my answer to
that one:
>>The 'suppress repeated values' is used to blank a column, not to suppress
a
complete row. It appears that you are pulling more columns in the actual
select that you are printing. If you remove those from the select, then the
'select distinct' will do the trick. If you cannot remove these columns,
you could create a group in the report based on col1, col2, col3 and then
move these columns from the detail band into the group band. <<

But I realized you can get it to work the way you want to:
for all columns in the detail band set the visible expression: if
thecolumn [-1] = thecolumn, 0, 1 )
which compares the current row value with the previous row value.

Set the detail band height = 0.

It looks strange not having a detail band, but I tested it and it works.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Linda Dickert wrote in message <35900353.FA5C2759@tcl.tec.sc.us>...
> If any of the columns value are the repeats in a previous row I want to
>suppress the data and then print the next row. I have sorted the data in
>the following order: col 1 col 2 col 3. I used select distinct
>in my SQL logic, but it does not seem to work..
>I would like to suppress the 2nd row of a repeated id code.
>Any Suggestions?
>
>