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.

Nested DW with Graph - can I set properties per row?

3 posts in DataWindow Last posting was on 2009-03-04 15:39:42.0Z
Brian Posted on 2009-03-03 14:14:02.0Z
Reply-To: "Brian" <info@infotechnics.co.uk>
From: "Brian" <info@infotechnics.co.uk>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Nested DW with Graph - can I set properties per row?
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49ad3b2a@forums-1-dub>
Date: 3 Mar 2009 06:14:02 -0800
X-Trace: forums-1-dub 1236089642 10.22.241.152 (3 Mar 2009 06:14:02 -0800)
X-Original-Trace: 3 Mar 2009 06:14:02 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88899
Article PK: 418151

Hi there

I have a DW with a nested DW that has a graph. Each row in the main DW can
potentially have different attributes for its graph; things like fonts for x
y axis, point size, title, graph labels, legend position and size etc etc

For example the graph for row 1 may have legend at the right whereas the
graph for row 2 may have the legend defined at the bottom etc. I hold all
the values for the attributes in a database and then at run time I want to
set these.

Problem is it doesnt work ...

Here's an example. Say for row 1 the graph legend is defined as 'top' and
for row 2 the legend is defined as 'right', here's essentially what I do

dw_report.Object.dw_graph[1].Object.gr_1.legend = 3 // set the graph in
the nested DW for row 1 to have legend at top
dw_report.Object.dw_graph[2].Object.gr_1.legend = 2 // set the graph in
the nested DW for row 2 to have legend at top

What happens is that the graphs in all rows gets set to whatever was last
set. In the above example the graph for row 1 is displayed with its legend
at right even though it was set to top for row 1. The same goes for other
attributes e.g. if the last row has its x-axis pointsize set to 20point
that's what all graphs will show.

So, is it not possible to control graph attributes for nested DW
individually for each row. Is each rows's graph not treated individually
even though i am referencing each row's graph individually?

Hope this is clear. If anyone out there has any experience it would be much
appreciated.

Thanks
Brian


Jeremy Lakeman Posted on 2009-03-03 23:33:56.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Nested DW with Graph - can I set properties per row?
Date: Tue, 3 Mar 2009 15:33:56 -0800 (PST)
Organization: http://groups.google.com
Lines: 50
Message-ID: <46281920-ce41-4330-960b-172694230450@v1g2000prd.googlegroups.com>
References: <49ad3b2a@forums-1-dub>
NNTP-Posting-Host: 203.122.242.105
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1236123236 15132 127.0.0.1 (3 Mar 2009 23:33:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 3 Mar 2009 23:33:56 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v1g2000prd.googlegroups.com; posting-host=203.122.242.105; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.6) Gecko/2009011913 Firefox/3.0.6 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 fly.essential.com.au:3128 (squid/2.5.STABLE8), 1.0 asp.essential.intranet:3128 (squid/2.5.STABLE8)
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!v1g2000prd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88903
Article PK: 418155


On Mar 4, 12:14 am, "Brian" <i...@infotechnics.co.uk> wrote:
> Hi there
>
> I have a DW with a nested DW that has a graph. Each row in the main DW can
> potentially have different attributes for its graph; things like fonts for x
> y axis, point size, title, graph labels, legend position and size etc etc
>
> For example the graph for row 1 may have legend at the right whereas the
> graph for row 2 may have the legend defined at the bottom etc. I hold all
> the values for the attributes  in a database and then at run time I want to
> set these.
>
> Problem is it doesnt work ...
>
> Here's an example. Say for row 1 the graph legend is defined as 'top' and
> for row 2 the legend is defined as 'right', here's essentially what I do
>
> dw_report.Object.dw_graph[1].Object.gr_1.legend = 3   // set the graph in
> the nested DW for row 1 to have legend at top
> dw_report.Object.dw_graph[2].Object.gr_1.legend = 2   // set the graph in
> the nested DW for row 2 to have legend at top
>
> What happens is that the graphs in all rows gets set to whatever was last
> set. In the above example the graph for row 1 is displayed with its legend
> at right even though it was set to top for row 1. The same goes for other
> attributes e.g. if the last row has its x-axis pointsize set to 20point
> that's what all graphs will show.
>
> So, is it not possible to control graph attributes for nested DW
> individually for each row. Is each rows's graph not treated individually
> even though i am referencing each row's graph individually?
>
> Hope this is clear. If anyone out there has any experience it would be much
> appreciated.
>
> Thanks
> Brian

If you can put an expression on the property, then you can supply the
value for the expression in the result set or arguments of the nested
report. Otherwise, you could create multiple graphs with different
styles, include them all in the composite datawindow, but only
display / retrieve one of them per detail row.


Brian Posted on 2009-03-04 15:39:42.0Z
Reply-To: "Brian" <info@infotechnics.co.uk>
From: "Brian" <info@infotechnics.co.uk>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49ad3b2a@forums-1-dub> <46281920-ce41-4330-960b-172694230450@v1g2000prd.googlegroups.com>
Subject: Re: Nested DW with Graph - can I set properties per row?
Lines: 61
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49aea0be@forums-1-dub>
Date: 4 Mar 2009 07:39:42 -0800
X-Trace: forums-1-dub 1236181182 10.22.241.152 (4 Mar 2009 07:39:42 -0800)
X-Original-Trace: 4 Mar 2009 07:39:42 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88904
Article PK: 418157

Thanks for the reply Jeremy

Unfortunately most of the properties do not have the option to specify an
expression. Also, I am changing loads of aspects of the graph so its not
really an option to 'hard-code' multiple graphs.

So, does anyone know if what I am trying to do is possible or am I coming up
against a PB limitation?

Regards
Brian

"Jeremy Lakeman" <jeremy.lakeman@gmail.com> wrote in message
news:46281920-ce41-4330-960b-172694230450@v1g2000prd.googlegroups.com...

On Mar 4, 12:14 am, "Brian" <i...@infotechnics.co.uk> wrote:
> Hi there
>
> I have a DW with a nested DW that has a graph. Each row in the main DW can
> potentially have different attributes for its graph; things like fonts for
> x
> y axis, point size, title, graph labels, legend position and size etc etc
>
> For example the graph for row 1 may have legend at the right whereas the
> graph for row 2 may have the legend defined at the bottom etc. I hold all
> the values for the attributes in a database and then at run time I want to
> set these.
>
> Problem is it doesnt work ...
>
> Here's an example. Say for row 1 the graph legend is defined as 'top' and
> for row 2 the legend is defined as 'right', here's essentially what I do
>
> dw_report.Object.dw_graph[1].Object.gr_1.legend = 3 // set the graph in
> the nested DW for row 1 to have legend at top
> dw_report.Object.dw_graph[2].Object.gr_1.legend = 2 // set the graph in
> the nested DW for row 2 to have legend at top
>
> What happens is that the graphs in all rows gets set to whatever was last
> set. In the above example the graph for row 1 is displayed with its legend
> at right even though it was set to top for row 1. The same goes for other
> attributes e.g. if the last row has its x-axis pointsize set to 20point
> that's what all graphs will show.
>
> So, is it not possible to control graph attributes for nested DW
> individually for each row. Is each rows's graph not treated individually
> even though i am referencing each row's graph individually?
>
> Hope this is clear. If anyone out there has any experience it would be
> much
> appreciated.
>
> Thanks
> Brian

If you can put an expression on the property, then you can supply the
value for the expression in the result set or arguments of the nested
report. Otherwise, you could create multiple graphs with different
styles, include them all in the composite datawindow, but only
display / retrieve one of them per detail row.