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.

Problem in crosstab datawindow

2 posts in DataWindow Last posting was on 2010-05-21 11:29:50.0Z
Anshu Posted on 2009-12-01 08:14:03.0Z
From: Anshu <anshu2678@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Problem in crosstab datawindow
Date: Tue, 1 Dec 2009 00:14:03 -0800 (PST)
Organization: http://groups.google.com
Lines: 17
Message-ID: <16ab5fd7-1b9a-4b85-ae43-1d05f3905f30@b36g2000prf.googlegroups.com>
NNTP-Posting-Host: 86.96.160.6
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1259655244 16546 127.0.0.1 (1 Dec 2009 08:14:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 1 Dec 2009 08:14:04 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b36g2000prf.googlegroups.com; posting-host=86.96.160.6; posting-account=mhW73woAAAAcb9rRWwmFCLUGWfrM-y97
User-Agent: G2/1.0
X-HTTP-Via: 1.1 ISA
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; .NET CLR 2.0.50727),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!news-out.readnews.com!transit4.readnews.com!postnews.google.com!b36g2000prf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90377
Article PK: 409982

Hello,

I have a problem, I have created a cross tab dw, and i have created
some computed fields. Now my problem is i want to change the color of
that computed fields based on some condition.
Example. i want to change the color of compute_1 field
I have given the condition like "If(column1>column2,rgb(128,0,0),if(mod
(getrow(),2) = 1,rgb(238,238,238),rgb(255,255,255)))"

But its not working. Even suppose for compute_1 i am using the
condition and in that conditon i am using the same compute_1 then PB
is shutting down.

Example. "If(column1>compute_1,rgb(128,0,0),if(mod(getrow(),2) = 1,rgb
(238,238,238),rgb(255,255,255)))".

Can any 1 help me to fix this


O Steine Posted on 2010-05-21 11:29:50.0Z
From: "O Steine" <osteine@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <16ab5fd7-1b9a-4b85-ae43-1d05f3905f30@b36g2000prf.googlegroups.com>
In-Reply-To: <16ab5fd7-1b9a-4b85-ae43-1d05f3905f30@b36g2000prf.googlegroups.com>
Subject: Re: Problem in crosstab datawindow
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.2.2583.119
X-MimeOLE: Produced By Microsoft MimeOLE V15.2.2583.119
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bf66eae$1@forums-1-dub>
Date: 21 May 2010 04:29:50 -0700
X-Trace: forums-1-dub 1274441390 10.22.241.152 (21 May 2010 04:29:50 -0700)
X-Original-Trace: 21 May 2010 04:29:50 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:91166
Article PK: 410770

Anshu,

Try and write your datawindow expression in the design painter, and do a
'Check Syntax'.
Or post your complete expression (most likely it's due to a error in the
string)

"Anshu" wrote in message
news:16ab5fd7-1b9a-4b85-ae43-1d05f3905f30@b36g2000prf.googlegroups.com...


Hello,


I have a problem, I have created a cross tab dw, and i have created
some computed fields. Now my problem is i want to change the color of
that computed fields based on some condition.
Example. i want to change the color of compute_1 field
I have given the condition like "If(column1>column2,rgb(128,0,0),if(mod
(getrow(),2) = 1,rgb(238,238,238),rgb(255,255,255)))"


But its not working. Even suppose for compute_1 i am using the
condition and in that conditon i am using the same compute_1 then PB
is shutting down.


Example. "If(column1>compute_1,rgb(128,0,0),if(mod(getrow(),2) = 1,rgb
(238,238,238),rgb(255,255,255)))".


Can any 1 help me to fix this