View

[emuye]

Hi,
I created a view inorder to for me to generate a report using Cr 8.5 and oracle 9i.However, i do not get any data when i run my report.i do not know if i miss something when i create a view.if someone has an idea why i am getting a blank report...pls share ur priceless knowledge.

CREATE OR REPLACE VIEW USEDITEM AS
SELECT DISTINCT Q.IPLINENO,I.IDESCR , P.CPROJNUM
FROM LETPROP L, PROJECT R, PROPPROJ J, PROPOSAL P, PROPITEM Q, BIDLET B, BIDTABS C, ITEMLIST I

WHERE L.LETTING = B.LETTING
AND B.LETTING = C.LETTING
AND P.CSPECYR = I.ISPECYR
AND Q.PRPITEM = I.ITEM
AND L.LCONTID = P.CONTID
AND Q.CONTID = P.CONTID
AND C.VENDOR = L.AVENDOR
AND C.CALL = L.CALL
AND C.LINEFLAG = Q.LINEFLAG
AND C.IPLINENO = Q.IPLINENO
AND B.DATELET = '21-may-04'
AND R.PCN = J.PCN
AND L.LETSTAT = 'A'
GROUP BY I.IDESCR,P.CPROJNUM, Q.IPLINENO,I.ITEM, P.CPROJNUM
ORDER BY P.CPROJNUM
;

view created.

 

[emuye]

t

 

[Turkbear]

Hi,
Can you get data from that view directly in SqlPlus?

 

[emuye]

yes, i just used the query i created and got data directly from the database using sqlplus.It is a little bit outrageorus why i could not get data from cr