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.

set computed field value in datastore on nested report

2 posts in DataWindow Last posting was on 2008-07-23 23:11:35.0Z
RoseyG Posted on 2008-05-21 13:59:25.0Z
Sender: 18fd.48330a07.1804289383@sybase.com
From: RoseyG
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: set computed field value in datastore on nested report
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48342abd.3ba0.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 May 2008 06:59:25 -0700
X-Trace: forums-1-dub 1211378365 10.22.241.41 (21 May 2008 06:59:25 -0700)
X-Original-Trace: 21 May 2008 06:59:25 -0700, 10.22.241.41
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86913
Article PK: 416170

Hi....
I have a composite report with 3 nested reports. The 3rd
nested report has a nested report on it (a dw just for a
pagebreak). I am unable to GetChild on the 3rd report
because of the nesting....so I have to use dot notation. At
least this is what I have read from other people in the
NewGroup. I am having trouble with the correct syntax for
dot notation to set the text field.

I am using PB 10.5.2.

Here is my coding:
This.ids_labrpt_pdf = Create n_ds
This.ids_labrpt_pdf.dataobject =
'd_labptrpts_composite_bact'
li_rc = This.ids_labrpt_pdf.SetTransobject(SQLCA)

So now composite report is in a datastore. r_labresults is
the name of 'd_labptrpts_composite_bact' on the composite
report.

This is my dot notation that isn't working.
//set text fields on report
This.ids_labrpt_pdf.Object.r_labresults.Object.header_lab_id[1].text
= ls_header_lab_id

I keep getting System Error "Error Number 39...Error
accessing external object property header_lab_id ....."

Any help would be appreciated. I spent way too much time
trying to figure this out. Thank you.

RG


"John Olson [Team Sybase]" <john.olson Posted on 2008-07-23 23:11:35.0Z
From: "John Olson [Team Sybase]" <john.olson@nospam_teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48342abd.3ba0.1681692777@sybase.com>
Subject: Re: set computed field value in datastore on nested report
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4887baa7$1@forums-1-dub>
Date: 23 Jul 2008 16:11:35 -0700
X-Trace: forums-1-dub 1216854695 10.22.241.152 (23 Jul 2008 16:11:35 -0700)
X-Original-Trace: 23 Jul 2008 16:11:35 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87442
Article PK: 416698

It looks like you need to specify a row for r_labresults. Something like:

this.ids_labrpt_pdf.Object.r_labresults[1].Object.header_lab_id[1].text



Regards,
John

<RoseyG> wrote in message news:48342abd.3ba0.1681692777@sybase.com...
> Hi....
> I have a composite report with 3 nested reports. The 3rd
> nested report has a nested report on it (a dw just for a
> pagebreak). I am unable to GetChild on the 3rd report
> because of the nesting....so I have to use dot notation. At
> least this is what I have read from other people in the
> NewGroup. I am having trouble with the correct syntax for
> dot notation to set the text field.
>
> I am using PB 10.5.2.
>
> Here is my coding:
> This.ids_labrpt_pdf = Create n_ds
> This.ids_labrpt_pdf.dataobject =
> 'd_labptrpts_composite_bact'
> li_rc = This.ids_labrpt_pdf.SetTransobject(SQLCA)
>
> So now composite report is in a datastore. r_labresults is
> the name of 'd_labptrpts_composite_bact' on the composite
> report.
>
> This is my dot notation that isn't working.
> //set text fields on report
> This.ids_labrpt_pdf.Object.r_labresults.Object.header_lab_id[1].text
> = ls_header_lab_id
>
> I keep getting System Error "Error Number 39...Error
> accessing external object property header_lab_id ....."
>
> Any help would be appreciated. I spent way too much time
> trying to figure this out. Thank you.
>
> RG