I have trouble of extracting data from other table.
I'll try to link it between two table but failed.
It shows the message "field" should be of type REAL instead of type STRING.
Any advise?
"Still on learning progress"


detail.1:
before.layout:

select *
from cisli220
where cisli220._index1 = {:cisli305.msid}
selectdo
endselect

select *
from cisli225
where cisli225._index1 = {:cisli220.msid}
selectdo
endselect


Thanks, =)

Okay - if I get this right in a report you are trying to print data from another table into the report. It should be telling you which specific field is causing the issue. In the report script did you declare all the tables you are using? If the cisli305 and cisli220 fields are input fields to the report then those do not need to be declared. You might need to give more information.

I have trouble of extracting data from other table.
I'll try to link it between two table but failed.
It shows the message "field" should be of type REAL instead of type STRING.
Any advise?
"Still on learning progress"


detail.1:
before.layout:

select *
from cisli220
where cisli220._index1 = {:cisli305.msid}
selectdo
endselect

select *
from cisli225
where cisli225._index1 = {:cisli220.msid}
selectdo
endselect


Thanks, =)

Hi,

Your query is not correct. The index1 for cisli225 and cisli220 is company number i.e. cisli220.sfcp/cisli225.sfcp

Try this:-


detail.1:
before.layout:

select cisli220.*
from cisli220
where cisli220.msid = {:cisli305.msid}
selectdo
endselect

select cisli225.*
from cisli225
where cisli225.msid = {:cisli220.msid}
selectdo
endselect