Why I can't link from this field?
Hi,
I would like to know why I can't link two dataviews created in my report:
There are one dataview, called Contas_A_Pagar and another one called
Enumeracao.
The dataview Enumeracao gerenetes this following sql code:
SELECT S000ENU.CDOENU, S000ENU.DESENU,
S000IEN.CDOENU CDOENU_2, S000IEN.CODITN,
S000IEN.VLRENU
FROM S000ENU S000ENU
INNER JOIN S000IEN S000IEN ON
(S000IEN.CDOENU = S000ENU.CDOENU)
WHERE
( S000ENU.CDOENU = 'LISTASTATUSMOVIMENTOFINANCEIRO' )
From the work environment of the Data tab, when I try to drag a link
between the dataviews Contas_A_Pagar and Enumeracao, RBuilder just
doesn't allow to do it.
I need to link the field "CodItn" from the dataview Enumeracao to the
master dataview "Contas_A_Pagar", but RBuilder can't let me link these
dataviews. Curiously, If I try to drag the field "CdoEnu" from the
dataview "Enumeracao", RBuilder allows me. I just can't drag the field
CodItn.
I don't understand why this happen. Could someone explain it to me?
Thanks a lot.
I would like to know why I can't link two dataviews created in my report:
There are one dataview, called Contas_A_Pagar and another one called
Enumeracao.
The dataview Enumeracao gerenetes this following sql code:
SELECT S000ENU.CDOENU, S000ENU.DESENU,
S000IEN.CDOENU CDOENU_2, S000IEN.CODITN,
S000IEN.VLRENU
FROM S000ENU S000ENU
INNER JOIN S000IEN S000IEN ON
(S000IEN.CDOENU = S000ENU.CDOENU)
WHERE
( S000ENU.CDOENU = 'LISTASTATUSMOVIMENTOFINANCEIRO' )
From the work environment of the Data tab, when I try to drag a link
between the dataviews Contas_A_Pagar and Enumeracao, RBuilder just
doesn't allow to do it.
I need to link the field "CodItn" from the dataview Enumeracao to the
master dataview "Contas_A_Pagar", but RBuilder can't let me link these
dataviews. Curiously, If I try to drag the field "CdoEnu" from the
dataview "Enumeracao", RBuilder allows me. I just can't drag the field
CodItn.
I don't understand why this happen. Could someone explain it to me?
Thanks a lot.
This discussion has been closed.
Comments
This question has been answered in the general newsgroup.
Please do not cross post questions.
--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com