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.

Getting a reference to a nested report object.

3 posts in DataWindow Last posting was on 2009-12-01 12:46:04.0Z
alexis.coles Posted on 2009-11-13 17:40:15.0Z
Sender: 2791.4afd97af.1804289383@sybase.com
From: alexis.coles
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Getting a reference to a nested report object.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4afd99ff.2937.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Nov 2009 09:40:15 -0800
X-Trace: forums-1-dub 1258134015 10.22.241.41 (13 Nov 2009 09:40:15 -0800)
X-Original-Trace: 13 Nov 2009 09:40:15 -0800, 10.22.241.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90271
Article PK: 409875

Hi guys,

Anyone know a way of getting a reference to a nested report
object.

I almost want to do something like

reportObjectDataType reportObject

for i = rows to 0 step -1
reportObect = dw_main.GetItemReport('nested_report_name',
rownumber)
var = reportObject.value
if var = 'this' then
dw_main.deleteRow(i)
end if
next

I realise that this won't work but hope it shows what I am
trying to do...

Could really use some help, it will be a mission to change
the report to to return the rows I dont' want in the first
place (belive it or not).

Many thanks.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-11-13 19:11:00.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4afd99ff.2937.1681692777@sybase.com>
Subject: Re: Getting a reference to a nested report object.
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4afdaf44@forums-1-dub>
Date: 13 Nov 2009 11:11:00 -0800
X-Trace: forums-1-dub 1258139460 10.22.241.152 (13 Nov 2009 11:11:00 -0800)
X-Original-Trace: 13 Nov 2009 11:11:00 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90272
Article PK: 409876

Search Help for "nested objects, property expressions"
It sounds to me like you would be better off with a WHERE NOT EXISTS clause
in the SQL.
Or maybe joining the test value as an invisible field and filtering.

--
Report Bugs to Sybase: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<alexis.coles> wrote in message news:4afd99ff.2937.1681692777@sybase.com...
> Hi guys,
>
> Anyone know a way of getting a reference to a nested report
> object.
>
> I almost want to do something like
>
> reportObjectDataType reportObject
>
> for i = rows to 0 step -1
> reportObect = dw_main.GetItemReport('nested_report_name',
> rownumber)
> var = reportObject.value
> if var = 'this' then
> dw_main.deleteRow(i)
> end if
> next
>
> I realise that this won't work but hope it shows what I am
> trying to do...
>
> Could really use some help, it will be a mission to change
> the report to to return the rows I dont' want in the first
> place (belive it or not).
>
> Many thanks.


O Steine Posted on 2009-12-01 12:46:04.0Z
From: "O Steine" <osteine@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4afd99ff.2937.1681692777@sybase.com>
In-Reply-To: <4afd99ff.2937.1681692777@sybase.com>
Subject: Re: Getting a reference to a nested report object.
Lines: 1
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 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b15100c$1@forums-1-dub>
Date: 1 Dec 2009 04:46:04 -0800
X-Trace: forums-1-dub 1259671564 10.22.241.152 (1 Dec 2009 04:46:04 -0800)
X-Original-Trace: 1 Dec 2009 04:46:04 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90379
Article PK: 409984

Check out this article : http://pbdj.sys-con.com/node/42518
"Restore and Retrieve Algorithms for a DataWindow with Nested Reports"

I've used this 'method' to 'retrieve' on a nested report (retrieve on a
local ds and using rowscopy to populate the neste report)



"alexis.coles" skrev i nyhetsmeldingen: 4afd99ff.2937.1681692777@sybase.com
...

> Hi guys,
>
> Anyone know a way of getting a reference to a nested report
> object.
>
> I almost want to do something like
>
> reportObjectDataType reportObject
>
> for i = rows to 0 step -1
> reportObect = dw_main.GetItemReport('nested_report_name',
> rownumber)
> var = reportObject.value
> if var = 'this' then
> dw_main.deleteRow(i)
> end if
> next
>
> I realise that this won't work but hope it shows what I am
> trying to do...
>
> Could really use some help, it will be a mission to change
> the report to to return the rows I dont' want in the first
> place (belive it or not).
>
> Many thanks.