Home » Developer & Programmer » Reports & Discoverer » Output is blank (10g)
Output is blank [message #458891] Wed, 02 June 2010 06:52 Go to next message
shree_z
Messages: 75
Registered: February 2008
Member
Hi,

I am trying to run Cash receipt report in reports builder. But the output is always blank. It is not even giving any fields created in the layout. This report was developed by some other developer, and there is no documentation available.

I am able to run the query in TOAD and I am getting genuine rows.

Please help.


Thanks in advance

Re: Output is blank [message #458895 is a reply to message #458891] Wed, 02 June 2010 07:10 Go to previous messageGo to next message
Littlefoot
Messages: 21561
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is there a format trigger somewhere (possibly in the outmost frame) that returns FALSE?
Re: Output is blank [message #459009 is a reply to message #458895] Wed, 02 June 2010 23:49 Go to previous messageGo to next message
shree_z
Messages: 75
Registered: February 2008
Member
Thankyou so much for the reply.

Can you please halp me how to check whether there is a format trigger on the outer most frame?.. I checked the property inspector. But could not find any format triggers.

Thanks so much again.
Re: Output is blank [message #459139 is a reply to message #459009] Thu, 03 June 2010 09:35 Go to previous messageGo to next message
Littlefoot
Messages: 21561
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is in the Property Inspector, somewhere at the bottom of the list.
Re: Output is blank [message #459268 is a reply to message #459139] Fri, 04 June 2010 04:32 Go to previous messageGo to next message
shree_z
Messages: 75
Registered: February 2008
Member
Thanks again for the reply.

I could run the report if I give the "Receipt number" parameter alone and avoid giving the "From Date" and "To Date" parameters.

Now I tried registering this report in oracle apps. After registering the report and we run it from apps end, the output is blank. Is there any settings to be changed in the concurrent program/Executable?

Thanks again
Re: Output is blank [message #459367 is a reply to message #459268] Fri, 04 June 2010 09:19 Go to previous message
Littlefoot
Messages: 21561
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know Oracle Apps.

However: mentioning "from date" (and "to date") reminds me of one thing: did you use correct datatypes? Did you, perhaps, rely on implicit conversion between CHAR and DATE datatype? If so, well, you shouldn't have. When dealing with dates, use dates. It means that you might need to involve the TO_DATE function. Something like
... WHERE some_date_column BETWEEN TO_DATE(:from_date, 'dd.mm.yyyy') 
                               AND TO_DATE(:to_date  , 'dd.mm.yyyy')
Previous Topic: change value in run time
Next Topic: Help with formatting html report output?
Goto Forum:
  


Current Time: Wed May 27 15:56:47 CDT 2020