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.

Display result set across and down

2 posts in DataWindow Last posting was on 2008-04-30 12:49:29.0Z
JC Posted on 2008-04-30 08:52:16.0Z
Sender: 7b9c.48180698.1804289383@sybase.com
From: JC
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Display result set across and down
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48183340.7e24.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Apr 2008 01:52:16 -0700
X-Trace: forums-1-dub 1209545536 10.22.241.41 (30 Apr 2008 01:52:16 -0700)
X-Original-Trace: 30 Apr 2008 01:52:16 -0700, 10.22.241.41
Lines: 46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86749
Article PK: 416007

PB 10.5

Does anyone have any suggestions on how I can make a result
set such as:

(listing off all benefits Jane & Sean qualify for)
Name Plan Coverage
----- ------------ --------
Jane Medical #1 Employee
Jane Medical #1 Family
Jane Medical #2 Employee
Jane Medical #2 Employee+1
Jane Dental #1 Employee
Sean Medical #1 Employee
Sean Medical #2 Employee
Sean Dental #1 Employee

Look like this on a datawindow:

-------------------------------------------------------
Jane
-------------------------------------------------------
Medical Dental
------- --------
Medical #1 Dental #1
Employee Employee
Family
Medical #2
Employee
Employee+1

-------------------------------------------------------
Sean
-------------------------------------------------------
Medical Dental
------- --------
Medical #1 Dental #1
Employee Employee
Medical #2
Employee

I'm kind of stumped and don't want to jump through hoops if
there is an somewhat straight forward way out there already.

Thanks!
JC


Millard F. Brown III Posted on 2008-04-30 12:49:29.0Z
From: "Millard F. Brown III" <millard.brown@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48183340.7e24.1681692777@sybase.com>
Subject: Re: Display result set across and down
Lines: 57
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.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48186ad9$1@forums-1-dub>
Date: 30 Apr 2008 05:49:29 -0700
X-Trace: forums-1-dub 1209559769 10.22.241.152 (30 Apr 2008 05:49:29 -0700)
X-Original-Trace: 30 Apr 2008 05:49:29 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86753
Article PK: 416012

It looks like your datawindow is set up with groups. You should be able to
move the columns into the detail band and delete the groups and get the
result you're after.

--
Regards,
Millard [TeamSybase]

<JC> wrote in message news:48183340.7e24.1681692777@sybase.com...
> PB 10.5
>
> Does anyone have any suggestions on how I can make a result
> set such as:
>
> (listing off all benefits Jane & Sean qualify for)
> Name Plan Coverage
> ----- ------------ --------
> Jane Medical #1 Employee
> Jane Medical #1 Family
> Jane Medical #2 Employee
> Jane Medical #2 Employee+1
> Jane Dental #1 Employee
> Sean Medical #1 Employee
> Sean Medical #2 Employee
> Sean Dental #1 Employee
>
> Look like this on a datawindow:
>
> -------------------------------------------------------
> Jane
> -------------------------------------------------------
> Medical Dental
> ------- --------
> Medical #1 Dental #1
> Employee Employee
> Family
> Medical #2
> Employee
> Employee+1
>
> -------------------------------------------------------
> Sean
> -------------------------------------------------------
> Medical Dental
> ------- --------
> Medical #1 Dental #1
> Employee Employee
> Medical #2
> Employee
>
> I'm kind of stumped and don't want to jump through hoops if
> there is an somewhat straight forward way out there already.
>
> Thanks!
> JC