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.

Crosstab/Matrix data entry

5 posts in DataWindow Last posting was on 2009-05-19 14:54:06.0Z
MP Posted on 2009-05-18 19:01:08.0Z
Sender: 7849.4a1199d3.1804289383@sybase.com
From: MP
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Crosstab/Matrix data entry
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a119fcc.7c95.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 18 May 2009 10:50:04 -0700, forums-3-dub.sybase.com
Lines: 33
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 18 May 2009 12:01:08 -0700, forums-3-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 May 2009 12:01:08 -0700
X-Trace: forums-1-dub 1242673268 10.22.108.75 (18 May 2009 12:01:08 -0700)
X-Original-Trace: 18 May 2009 12:01:08 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89324
Article PK: 418567

I'm trying to develop a screen for entering a forecast for
each product for each customer.
I'd like the products to go down the left side with the
customers going across the top and each forecast being in
the intersect between the two. This lends itself perfectly
to a crosstab datawindow except it does not allow for
updates.

The main tables in my current DB design are:
*All Products
*All Customers
*All forecasts (where I make sure there is an entry for
every Product/Customer combination, initialized with a zero
forecast).
*All Reps. When a rep is selected it will change the
Customers going across the top of the matrix - This is why
the number of columns has to be dynamic.

The customers and Products can change every night but as
they change I can make sure I have every combination in the
forecast table.

I'm still just prototyping and it's early in the process, so
I can change everything I've done so far.

Since I don't seem to be able to use the crosstab datawindow
I'm just looking for any ideas as how to accomplish this.

Any help and suggestions are greatly appreciated.

Thanks

MP


Ajay Posted on 2009-05-18 21:23:16.0Z
Sender: 1542.4a11bf93.1804289383@sybase.com
From: Ajay
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Crosstab/Matrix data entry
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a11c0a5.1606.1681692777@sybase.com>
References: <4a119fcc.7c95.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 18 May 2009 13:10:13 -0700, forums-3-dub.sybase.com
Lines: 43
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 18 May 2009 14:21:17 -0700, forums-3-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 May 2009 14:23:16 -0700
X-Trace: forums-1-dub 1242681796 10.22.108.75 (18 May 2009 14:23:16 -0700)
X-Original-Trace: 18 May 2009 14:23:16 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89325
Article PK: 418570


> I'm trying to develop a screen for entering a forecast for
> each product for each customer.
> I'd like the products to go down the left side with the
> customers going across the top and each forecast being in
> the intersect between the two. This lends itself perfectly
> to a crosstab datawindow except it does not allow for
> updates.
>
> The main tables in my current DB design are:
> *All Products
> *All Customers
> *All forecasts (where I make sure there is an entry for
> every Product/Customer combination, initialized with a
> zero forecast).
> *All Reps. When a rep is selected it will change the
> Customers going across the top of the matrix - This is why
> the number of columns has to be dynamic.
>
> The customers and Products can change every night but as
> they change I can make sure I have every combination in
> the forecast table.
>
> I'm still just prototyping and it's early in the process,
> so I can change everything I've done so far.
>
> Since I don't seem to be able to use the crosstab
> datawindow I'm just looking for any ideas as how to
> accomplish this.
>
> Any help and suggestions are greatly appreciated.
>
> Thanks
>
> MP

1)Create a procedure which will do this and try to get this
information onto a datawindow object.
Here you may have to create a temporary table for storing
all information and propagate it using loops in procedure.
2) Create a tabular datawindow for reps,products,customers
and have a nested datawindow for forecast. Pass in
Reps,products to the nested datawindow to retrieve the right
result.


Ivaylo Ivanov Posted on 2009-05-19 09:54:53.0Z
From: "Ivaylo Ivanov" <NOSPAM_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a119fcc.7c95.1681692777@sybase.com>
Subject: Re: Crosstab/Matrix data entry
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a1270d3$1@forums-3-dub.sybase.com>
X-Original-Trace: 19 May 2009 01:41:55 -0700, vip152.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 19 May 2009 02:52:59 -0700, forums-3-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 May 2009 02:54:53 -0700
X-Trace: forums-1-dub 1242726893 10.22.108.75 (19 May 2009 02:54:53 -0700)
X-Original-Trace: 19 May 2009 02:54:53 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89329
Article PK: 418572

If the entering operation would not be repeated many times one after
another, then you could trap DW's DoubleClicked event. On this event you
could try to determine the doubleclicked row/column (respectively - product
ID/Customer ID) and pass the IDs to a simple response window for editing
forecast value associated with this pair of product ID/Customer ID. After
closing the response window with Save button you can refresh the crosstab.
After closing with Cancel button you could do nothing. A boring, but simple
solution.... :-) and don't forget to inform the user (through some
statictext) for the doubleclick capability :-)

Ivaylo

<MP> wrote in message news:4a119fcc.7c95.1681692777@sybase.com...
> I'm trying to develop a screen for entering a forecast for
> each product for each customer.
> I'd like the products to go down the left side with the
> customers going across the top and each forecast being in
> the intersect between the two. This lends itself perfectly
> to a crosstab datawindow except it does not allow for
> updates.
>
> The main tables in my current DB design are:
> *All Products
> *All Customers
> *All forecasts (where I make sure there is an entry for
> every Product/Customer combination, initialized with a zero
> forecast).
> *All Reps. When a rep is selected it will change the
> Customers going across the top of the matrix - This is why
> the number of columns has to be dynamic.
>
> The customers and Products can change every night but as
> they change I can make sure I have every combination in the
> forecast table.
>
> I'm still just prototyping and it's early in the process, so
> I can change everything I've done so far.
>
> Since I don't seem to be able to use the crosstab datawindow
> I'm just looking for any ideas as how to accomplish this.
>
> Any help and suggestions are greatly appreciated.
>
> Thanks
>
> MP


Philip Salgannik Posted on 2009-05-19 14:54:06.0Z
From: "Philip Salgannik" <philip@MeMyselfAndI.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a119fcc.7c95.1681692777@sybase.com>
Subject: Re: Crosstab/Matrix data entry
Lines: 16
Organization: MeMyselfAndI
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
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a12b6ab$1@forums-3-dub.sybase.com>
X-Original-Trace: 19 May 2009 06:39:55 -0700, vip152.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 19 May 2009 07:51:00 -0700, forums-3-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 May 2009 07:54:06 -0700
X-Trace: forums-1-dub 1242744846 10.22.108.75 (19 May 2009 07:54:06 -0700)
X-Original-Trace: 19 May 2009 07:54:06 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89335
Article PK: 418576

Just for fun, take a look at this
http://www.wideopenwest.com/~rsizer/powerbuilder/source/editcrosstab.htm

Also if the number of "customers" is manageable (i.e. below 300) you can
easily dynamically create a grid...

<MP> wrote in message news:4a119fcc.7c95.1681692777@sybase.com...
> I'm trying to develop a screen for entering a forecast for
> each product for each customer.
> I'd like the products to go down the left side with the
> customers going across the top and each forecast being in
> the intersect between the two. This lends itself perfectly
> to a crosstab datawindow except it does not allow for
> updates.


"Paul Horan[Sybase]" <phoran_remove Posted on 2009-05-18 22:06:20.0Z
From: "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a119fcc.7c95.1681692777@sybase.com>
Subject: Re: Crosstab/Matrix data entry
Lines: 44
Organization: Sybase
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
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a11cb31@forums-3-dub.sybase.com>
X-Original-Trace: 18 May 2009 13:55:13 -0700, vip152.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-Trace: 18 May 2009 15:06:17 -0700, forums-3-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 May 2009 15:06:20 -0700
X-Trace: forums-1-dub 1242684380 10.22.108.75 (18 May 2009 15:06:20 -0700)
X-Original-Trace: 18 May 2009 15:06:20 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89326
Article PK: 418581

I would use a 3rd-party grid control - or even embed an Excel spreadsheet.
ComponentOne is one that I've used... Infragistics has a great reputation
as well

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

<MP> wrote in message news:4a119fcc.7c95.1681692777@sybase.com...
> I'm trying to develop a screen for entering a forecast for
> each product for each customer.
> I'd like the products to go down the left side with the
> customers going across the top and each forecast being in
> the intersect between the two. This lends itself perfectly
> to a crosstab datawindow except it does not allow for
> updates.
>
> The main tables in my current DB design are:
> *All Products
> *All Customers
> *All forecasts (where I make sure there is an entry for
> every Product/Customer combination, initialized with a zero
> forecast).
> *All Reps. When a rep is selected it will change the
> Customers going across the top of the matrix - This is why
> the number of columns has to be dynamic.
>
> The customers and Products can change every night but as
> they change I can make sure I have every combination in the
> forecast table.
>
> I'm still just prototyping and it's early in the process, so
> I can change everything I've done so far.
>
> Since I don't seem to be able to use the crosstab datawindow
> I'm just looking for any ideas as how to accomplish this.
>
> Any help and suggestions are greatly appreciated.
>
> Thanks
>
> MP