Hi,

I have a tabular report (dw_list) with in the detail band a nested report
(dw_nested).

How can I get a reference to the nested report??

In a composite report one can do something like:
    datawindowchild   ldwc
    dw_composite.getchild("nameNestedReport",ldwc)
    ldwc.SetTransObject(SQLCA)
    ldwc.insertrow(0)
    ... (or one can use sharedata to fill the nested report)

However, if dw_list is not a composite report,
    dw_list.getchild("nameNestedReport",ldwc)     DOES NOT WORK

Is there a way to get the reference to the nested report??
Is there a way to share or fill the nested report from script ??

any help is welcome !!

Dimitri

Dimitri,

You can't get a handle to a nested report unless its on a composite. For
other types of nested reports you can use dot notation to get at most
properties and set the data. The huge drawback is that without a handle you
can't call functions. Therefore ShareData can't be used. However, to set the
data you can use <dwmaster>.object.<nestedreport>.data = <an array which
matches the record type of the nested report DW>. To set just one cell you
can say data[x,y] where x is the row number and y is the column number

Regards,
John Olson [TeamSybase]
Developower, Inc.

Dimitri Van der Veken wrote in message
<39jSgSaw$GA.201@forums.sybase.com>...
>Hi,
>
>I have a tabular report (dw_list) with in the detail band a nested report
>(dw_nested).
>
>How can I get a reference to the nested report??
>
>In a composite report one can do something like:
>    datawindowchild   ldwc
>    dw_composite.getchild("nameNestedReport",ldwc)
>    ldwc.SetTransObject(SQLCA)
>    ldwc.insertrow(0)
>    ... (or one can use sharedata to fill the nested report)
>
>However, if dw_list is not a composite report,
>    dw_list.getchild("nameNestedReport",ldwc)     DOES NOT WORK
>
>Is there a way to get the reference to the nested report??
>Is there a way to share or fill the nested report from script ??
>
>any help is welcome !!
>
>Dimitri
>
>

Hi,

I am sorry to say that I did not succeed in inserting data in the nested
report .
Here is what I tried ("dw_list" with nested report  "dw_person" in detail
band)
   str_test lstr_test[]

   ll_rowindex = dw_1.insertrow(0)
   dw_1.object.name[ll_rowindex] = "DIMI"

      lstr_test[1].name="JAN"
      lstr_test[1].age=1
     dw_1.object.dw_person[ll_rowindex].data = lstr_test

   ll_rowindex = dw_1.insertrow(0)
   dw_1.object.name[ll_rowindex] = "GEERT"

       lstr_test[2].name="JAKE"
       lstr_test[2].age=2
       dw_1.object.dw_person[ll_rowindex].data = lstr_test

RESULT:
Instead inserting the data (JAN,1),(JAKE,2) in the nested report, the nested
reports stayed empty, and
the values "DIMI"and "GEERT" got overwritten by "JAN" and "JAKE".

Did I do something wrong??


John Olson [TeamSybase] <john.olson@developower_nospam.com> wrote in message
news:OdFJnc6w$GA.201@forums.sybase.com...
> Dimitri,
>
> You can't get a handle to a nested report unless its on a composite. For
> other types of nested reports you can use dot notation to get at most
> properties and set the data. The huge drawback is that without a handle
you
> can't call functions. Therefore ShareData can't be used. However, to set
the
> data you can use <dwmaster>.object.<nestedreport>.data = <an array which
> matches the record type of the nested report DW>. To set just one cell you
> can say data[x,y] where x is the row number and y is the column number
>
> Regards,
> John Olson [TeamSybase]
> Developower, Inc.
>
> Dimitri Van der Veken wrote in message
> <39jSgSaw$GA.201@forums.sybase.com>...
> >Hi,
> >
> >I have a tabular report (dw_list) with in the detail band a nested report
> >(dw_nested).
> >
> >How can I get a reference to the nested report??
> >
> >In a composite report one can do something like:
> >    datawindowchild   ldwc
> >    dw_composite.getchild("nameNestedReport",ldwc)
> >    ldwc.SetTransObject(SQLCA)
> >    ldwc.insertrow(0)
> >    ... (or one can use sharedata to fill the nested report)
> >
> >However, if dw_list is not a composite report,
> >    dw_list.getchild("nameNestedReport",ldwc)     DOES NOT WORK
> >
> >Is there a way to get the reference to the nested report??
> >Is there a way to share or fill the nested report from script ??
> >
> >any help is welcome !!
> >
> >Dimitri
> >
> >
>
>

hmmm. Your syntax looks correct except that your second data assignment
should insert two rows into the nested report while your first assignment
inserts one.

I don't see how you could overwrite the dw_1.name column by assigning the
array of structures to the nested report. Did you copy and paste the syntax
into your message or just rewrite it?

 Regards,
 John Olson [TeamSybase]
 Developower, Inc.

Dimitri Van der Veken wrote in message ...
>Hi,
>
>I am sorry to say that I did not succeed in inserting data in the nested
>report .
>Here is what I tried ("dw_list" with nested report  "dw_person" in detail
>band)
>   str_test lstr_test[]
>
>   ll_rowindex = dw_1.insertrow(0)
>   dw_1.object.name[ll_rowindex] = "DIMI"
>
>      lstr_test[1].name="JAN"
>      lstr_test[1].age=1
>     dw_1.object.dw_person[ll_rowindex].data = lstr_test
>
>   ll_rowindex = dw_1.insertrow(0)
>   dw_1.object.name[ll_rowindex] = "GEERT"
>
>       lstr_test[2].name="JAKE"
>       lstr_test[2].age=2
>       dw_1.object.dw_person[ll_rowindex].data = lstr_test
>
>RESULT:
>Instead inserting the data (JAN,1),(JAKE,2) in the nested report, the
nested
>reports stayed empty, and
>the values "DIMI"and "GEERT" got overwritten by "JAN" and "JAKE".
>
>Did I do something wrong??
>
>
>John Olson [TeamSybase] <john.olson@developower_nospam.com> wrote in
message
>news:OdFJnc6w$GA.201@forums.sybase.com...
>> Dimitri,
>>
>> You can't get a handle to a nested report unless its on a composite. For
>> other types of nested reports you can use dot notation to get at most
>> properties and set the data. The huge drawback is that without a handle
>you
>> can't call functions. Therefore ShareData can't be used. However, to set
>the
>> data you can use <dwmaster>.object.<nestedreport>.data = <an array which
>> matches the record type of the nested report DW>. To set just one cell
you
>> can say data[x,y] where x is the row number and y is the column number
>>
>> Regards,
>> John Olson [TeamSybase]
>> Developower, Inc.
>>
>> Dimitri Van der Veken wrote in message
>> <39jSgSaw$GA.201@forums.sybase.com>...
>> >Hi,
>> >
>> >I have a tabular report (dw_list) with in the detail band a nested
report
>> >(dw_nested).
>> >
>> >How can I get a reference to the nested report??
>> >
>> >In a composite report one can do something like:
>> >    datawindowchild   ldwc
>> >    dw_composite.getchild("nameNestedReport",ldwc)
>> >    ldwc.SetTransObject(SQLCA)
>> >    ldwc.insertrow(0)
>> >    ... (or one can use sharedata to fill the nested report)
>> >
>> >However, if dw_list is not a composite report,
>> >    dw_list.getchild("nameNestedReport",ldwc)     DOES NOT WORK
>> >
>> >Is there a way to get the reference to the nested report??
>> >Is there a way to share or fill the nested report from script ??
>> >
>> >any help is welcome !!
>> >
>> >Dimitri
>> >
>> >
>>
>>
>
>

Hi ,

I found a way to make it work:
    str_test lstr_test

   dw_1.insertrow(0)
   dw_1.object.name[1] = "DIMI"
   dw_1.insertrow(0)
   dw_1.object.name[2] = "GEERT"

       lstr_test[1].name="JAN"
       lstr_test[1].age=1
       dw_1.object.dw_person[1].data = lstr_test

       lstr_test[2].name="JAKE"
       lstr_test[2].age=2
       dw_1.object.dw_person[2].data = lstr_test

When I first insert and edit all the rows in the primary report and after
that all the data in the nested report, then all works fine.

Thanks for the help!

Dimi


Dimitri Van der Veken <dimitri@servico.be> wrote in message
news:oQAYhbIx$GA.201@forums.sybase.com...
> Hi,
>
> I am sorry to say that I did not succeed in inserting data in the nested
> report .
> Here is what I tried ("dw_list" with nested report  "dw_person" in detail
> band)
>    str_test lstr_test[]
>
>    ll_rowindex = dw_1.insertrow(0)
>    dw_1.object.name[ll_rowindex] = "DIMI"
>
>       lstr_test[1].name="JAN"
>       lstr_test[1].age=1
>      dw_1.object.dw_person[ll_rowindex].data = lstr_test
>
>    ll_rowindex = dw_1.insertrow(0)
>    dw_1.object.name[ll_rowindex] = "GEERT"
>
>        lstr_test[2].name="JAKE"
>        lstr_test[2].age=2
>        dw_1.object.dw_person[ll_rowindex].data = lstr_test
>
> RESULT:
> Instead inserting the data (JAN,1),(JAKE,2) in the nested report, the
nested
> reports stayed empty, and
> the values "DIMI"and "GEERT" got overwritten by "JAN" and "JAKE".
>
> Did I do something wrong??
>
>
> John Olson [TeamSybase] <john.olson@developower_nospam.com> wrote in
message
> news:OdFJnc6w$GA.201@forums.sybase.com...
> > Dimitri,
> >
> > You can't get a handle to a nested report unless its on a composite. For
> > other types of nested reports you can use dot notation to get at most
> > properties and set the data. The huge drawback is that without a handle
> you
> > can't call functions. Therefore ShareData can't be used. However, to set
> the
> > data you can use <dwmaster>.object.<nestedreport>.data = <an array which
> > matches the record type of the nested report DW>. To set just one cell
you
> > can say data[x,y] where x is the row number and y is the column number
> >
> > Regards,
> > John Olson [TeamSybase]
> > Developower, Inc.
> >
> > Dimitri Van der Veken wrote in message
> > <39jSgSaw$GA.201@forums.sybase.com>...
> > >Hi,
> > >
> > >I have a tabular report (dw_list) with in the detail band a nested
report
> > >(dw_nested).
> > >
> > >How can I get a reference to the nested report??
> > >
> > >In a composite report one can do something like:
> > >    datawindowchild   ldwc
> > >    dw_composite.getchild("nameNestedReport",ldwc)
> > >    ldwc.SetTransObject(SQLCA)
> > >    ldwc.insertrow(0)
> > >    ... (or one can use sharedata to fill the nested report)
> > >
> > >However, if dw_list is not a composite report,
> > >    dw_list.getchild("nameNestedReport",ldwc)     DOES NOT WORK
> > >
> > >Is there a way to get the reference to the nested report??
> > >Is there a way to share or fill the nested report from script ??
> > >
> > >any help is welcome !!
> > >
> > >Dimitri
> > >
> > >
> >
> >
>
>