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.

Multi level Grouping

3 posts in DataWindow Last posting was on 2009-12-30 11:29:10.0Z
paleri Posted on 2009-12-29 10:01:39.0Z
From: paleri <jayadevpaleri@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Multi level Grouping
Date: Tue, 29 Dec 2009 02:01:39 -0800 (PST)
Organization: http://groups.google.com
Lines: 46
Message-ID: <3ab4e2c2-82ff-4f18-9e5e-0008e2d999f8@r5g2000yqb.googlegroups.com>
NNTP-Posting-Host: 86.96.160.13
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1262080899 27213 127.0.0.1 (29 Dec 2009 10:01:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 29 Dec 2009 10:01:39 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r5g2000yqb.googlegroups.com; posting-host=86.96.160.13; posting-account=1IDZHAoAAADPnovfnhTcyckEfkzY6rhs
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.0 (KHTML, like Gecko) Chrome/3.0.195.33 Safari/532.0,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!r5g2000yqb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90503
Article PK: 410108

Hi,

Is there is any way to in PB to do a multilevel grouping in the
report?

The scenario is ,

I have multiple level department structure, ie,

A - First level
B - Second level
C - Third level
D - Fourth level
E - Fifth level

If the employees are assigned to only to the "Fifth Level" that means
"E" then there will not be any issue, I can use simple group data
window object. But here my challenge is, the employees will be
assigned to any level. that is some employees will be assigned to
level B and some will be under level C and Some under level E. The
structure will be as shown below.


Group A
-----------------------------
Sub Group B
---------------------------- Employees In Department B
Sub Group C
-----------------------------Employees In Department C
Sub Group D
-----------------------------
Sub Group E
-------------------------Employees
In Department E
Group Total E
-----------------------------
Group Total D
----------------------------
Group Total C
-----------------------------
Group Total B
---------------------------
Group Total A

Can anybody give me a suggestion how to incorporate this in the
datawindow? or any other method to do this?


Jeremy Lakeman Posted on 2009-12-30 11:29:10.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Multi level Grouping
Date: Wed, 30 Dec 2009 03:29:10 -0800 (PST)
Organization: http://groups.google.com
Lines: 62
Message-ID: <fb3f6dbb-02e7-425f-812c-a050b3505331@k23g2000yqa.googlegroups.com>
References: <3ab4e2c2-82ff-4f18-9e5e-0008e2d999f8@r5g2000yqb.googlegroups.com>
NNTP-Posting-Host: 122.49.175.125
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1262172550 9940 127.0.0.1 (30 Dec 2009 11:29:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 30 Dec 2009 11:29:10 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k23g2000yqa.googlegroups.com; posting-host=122.49.175.125; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!k23g2000yqa.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90505
Article PK: 410110


On Dec 29, 8:01 pm, paleri <jayadevpal...@gmail.com> wrote:
> Hi,
>
> Is there is any way to in PB to do a multilevel grouping in the
> report?
>
> The scenario is ,
>
> I have multiple level department structure, ie,
>
> A - First level
> B - Second level
> C - Third level
> D - Fourth level
> E - Fifth level
>
> If the employees are assigned to only to the "Fifth Level" that means
> "E" then there will not be any issue, I can use simple group data
> window object. But here my challenge is, the employees will be
> assigned to any level. that is some employees will be assigned to
> level B and some will be under level C and Some under level E. The
> structure will be as shown below.
>
> Group A
> -----------------------------
>         Sub Group B
>         ---------------------------- Employees In Department B
>                 Sub Group C
>                 -----------------------------Employees In Department C
>                           Sub Group D
>                            -----------------------------
>                                   Sub Group E
>                                   -------------------------Employees
> In Department E
>                                   Group Total E
>                            -----------------------------
>                            Group Total D
>                  ----------------------------
>                  Group Total C
>         -----------------------------
>         Group Total B
> ---------------------------
> Group Total A
>
> Can anybody give me a suggestion how to incorporate this in the
> datawindow? or any other method to do this?

ah.... here's a hacky idea... use a single detail row, no normal
headers or summary bands, with an expression for the x position of
objects (eg label.x=indent * 150), and a flag to control which set of
objects are visible (eg ln_1.visible=if(row_type='line',1,0) ).

Then add unions to your query to return extra rows for your "headings"
and "summaries" with an order by clause that puts everything in the
order you want.


PascalB Posted on 2009-12-30 09:59:04.0Z
From: "PascalB" <test@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <3ab4e2c2-82ff-4f18-9e5e-0008e2d999f8@r5g2000yqb.googlegroups.com>
Subject: Re: Multi level Grouping
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b3b2468$1@forums-1-dub>
Date: 30 Dec 2009 01:59:04 -0800
X-Trace: forums-1-dub 1262167144 10.22.241.152 (30 Dec 2009 01:59:04 -0800)
X-Original-Trace: 30 Dec 2009 01:59:04 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90504
Article PK: 410112

Hi,

An solution would be to work with nested reports.
The main report should retrieve al departments, the nested reports retrieves
the employees of this department.

Layout should be

MAIN REPORT - retrieve departments
- NESTED REPORT (in detail) - retrieve employees for this department

In this case, say employee1, can be in department A, B and E.

"paleri" <jayadevpaleri@gmail.com> wrote in message
news:3ab4e2c2-82ff-4f18-9e5e-0008e2d999f8@r5g2000yqb.googlegroups.com...
> Hi,
>
> Is there is any way to in PB to do a multilevel grouping in the
> report?
>
> The scenario is ,
>
> I have multiple level department structure, ie,
>
> A - First level
> B - Second level
> C - Third level
> D - Fourth level
> E - Fifth level
>
> If the employees are assigned to only to the "Fifth Level" that means
> "E" then there will not be any issue, I can use simple group data
> window object. But here my challenge is, the employees will be
> assigned to any level. that is some employees will be assigned to
> level B and some will be under level C and Some under level E. The
> structure will be as shown below.
>
>
> Group A
> -----------------------------
> Sub Group B
> ---------------------------- Employees In Department B
> Sub Group C
> -----------------------------Employees In Department C
> Sub Group D
> -----------------------------
> Sub Group E
> -------------------------Employees
> In Department E
> Group Total E
> -----------------------------
> Group Total D
> ----------------------------
> Group Total C
> -----------------------------
> Group Total B
> ---------------------------
> Group Total A
>
> Can anybody give me a suggestion how to incorporate this in the
> datawindow? or any other method to do this?