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.

hide values in crosstab dw.

2 posts in DataWindow Last posting was on 2009-07-07 07:24:16.0Z
Josep Posted on 2009-07-06 14:12:09.0Z
Sender: 22c4.4a52058b.1804289383@sybase.com
From: Josep
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: hide values in crosstab dw.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a520639.233d.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 6 Jul 2009 07:12:09 -0700
X-Trace: forums-3-dub.sybase.com 1246889529 10.22.241.188 (6 Jul 2009 07:12:09 -0700)
X-Original-Trace: 6 Jul 2009 07:12:09 -0700, forums-3-dub.sybase.com
Lines: 9
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89594
Article PK: 418782

Hi,

in a crosstab datawindow with 1 column and 3 values for each
column. Is it possible to hide 2 of the 3 values in the
first and the last column?


Thanks,
Josep.


Ivaylo Ivanov Posted on 2009-07-07 07:24:16.0Z
From: "Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a520639.233d.1681692777@sybase.com>
Subject: Re: hide values in crosstab dw.
Lines: 33
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: <4a52f820$3@forums-3-dub.sybase.com>
Date: 7 Jul 2009 00:24:16 -0700
X-Trace: forums-3-dub.sybase.com 1246951456 10.22.241.152 (7 Jul 2009 00:24:16 -0700)
X-Original-Trace: 7 Jul 2009 00:24:16 -0700, vip152.sybase.com
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89596
Article PK: 418784

Try switching crosstab to static mode by modifying
Datawindow.Crosstab.Staticmode property:

string ls_orig_mode
ls_orig_mode = Lower(dw_my.Describe("DataWindow.Crosstab.StaticMode")) //
save current crosstab mode
if ls_orig_mode <> "yes" then
dw_my.Modify("Datawindow.Crosstab.StaticMode='yes'") // switch the crosstab
to static mode

then observe the tab-separated list returned by
dw_my.Describe("Datawindow.Objects") and modify the Visible property for the
desired columns. At the end, restore your original crosstab mode:

if ls_orig_mode <> "yes" then
dw_my.Modify("Datawindow.Crosstab.StaticMode='" + ls_orig_mode + "'") //
restore original crosstab mode

Good luck!
Ivaylo

<Josep> wrote in message news:4a520639.233d.1681692777@sybase.com...
> Hi,
>
> in a crosstab datawindow with 1 column and 3 values for each
> column. Is it possible to hide 2 of the 3 values in the
> first and the last column?
>
>
> Thanks,
> Josep.