OraFAQ Forum: Forms » Reports does nt show any any value

Home » Developer & Programmer » Forms » Reports does nt show any any value

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reports does nt show any any value [message #494917]

Thu, 17 February 2011 08:45

COUNT KHAN
Messages: 6
Registered: February 2011
Location: PESHAWAR

Junior Member

Dear Friends !
i am using oracle 10 forms !
in report i have used form Query "select sum(sale_price) from (table) expense.
i attached it to oracle forms but at that time it does nt show any value!

Report message to a moderator

Re: Reports does nt show any any value [message #495059 is a reply to message #494917]

Thu, 17 February 2011 12:26

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

COUNT KHAN wrote on Thu, 17 February 2011 09:45

Dear Friends !
i am using oracle 10 forms !
in report i have used form Query "select sum(sale_price) from (table) expense.
i attached it to oracle forms but at that time it does nt show any value!

This is an incomplete post to say the least, or your query is invalid syntax for Oracle.

Report message to a moderator

Re: Reports does nt show any any value [message #495098 is a reply to message #495059]

Thu, 17 February 2011 13:24

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Many possible reasons - table is empty, sale_price is empty, you connected to a schema different from one you thought you did, etc.

Report message to a moderator

Re: Reports does nt show any any value [message #495326 is a reply to message #495098]

Fri, 18 February 2011 02:30

COUNT KHAN
Messages: 6
Registered: February 2011
Location: PESHAWAR

Junior Member

Dear table field is not empty it works when i run it on oralce report editor at there it works pretty well!
but when i call that .jsp file from forms at run time it show no value?????
i need your further help please
regards

Report message to a moderator

Previous Topic:	Oracle Forms Errors on Startup
Next Topic:	Export to Excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 13:05:55 CDT 2024