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 values in trailer group

2 posts in DataWindow Last posting was on 2008-07-23 16:57:40.0Z
Sharon Posted on 2008-06-11 18:02:20.0Z
Sender: 486e.484edc2f.1804289383@sybase.com
From: Sharon
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: suppress repeating values in trailer group
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4850132c.750d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Jun 2008 11:02:20 -0700
X-Trace: forums-1-dub 1213207340 10.22.241.41 (11 Jun 2008 11:02:20 -0700)
X-Original-Trace: 11 Jun 2008 11:02:20 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87144
Article PK: 416399

using pb 10.0
in DW have two groups
group 1 for GL_account
group 2 for Cost_account

group 2 trailer shows:
Gl_account Cost_account amount
123 ABC 5.00
123 DEF 10.00


any way to suppress the repeating field GL_account in the
group trailer?


"John Olson [Team Sybase]" <john.olson Posted on 2008-07-23 16:57:40.0Z
From: "John Olson [Team Sybase]" <john.olson@nospam_teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4850132c.750d.1681692777@sybase.com>
Subject: Re: suppress repeating values in trailer group
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48876304$1@forums-1-dub>
Date: 23 Jul 2008 09:57:40 -0700
X-Trace: forums-1-dub 1216832260 10.22.241.152 (23 Jul 2008 09:57:40 -0700)
X-Original-Trace: 23 Jul 2008 09:57:40 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87441
Article PK: 416696

That'll be a tricky one because you'd have to know if it is the first
instance of the cost_account group within the gl_account group. I can't see
anyway to do that using normal features. However, in tough I sometimes call
a global function and have it interact with the database or PB code outside
the DW. In this case you could possibly have it become invisible if the
function determines it's the second cost_account group within the gl_account
group.

Regards,
John

<Sharon> wrote in message news:4850132c.750d.1681692777@sybase.com...
> using pb 10.0
> in DW have two groups
> group 1 for GL_account
> group 2 for Cost_account
>
> group 2 trailer shows:
> Gl_account Cost_account amount
> 123 ABC 5.00
> 123 DEF 10.00
>
>
> any way to suppress the repeating field GL_account in the
> group trailer?