OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Output is blank (10g)

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

Output is blank [message #458891]

Wed, 02 June 2010 06:52

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

Report message to a moderator

Re: Output is blank [message #458895 is a reply to message #458891]

Wed, 02 June 2010 07:10

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

Senior Member
Account Moderator

Is there a format trigger somewhere (possibly in the outmost frame) that returns FALSE?

Report message to a moderator

Re: Output is blank [message #459009 is a reply to message #458895]

Wed, 02 June 2010 23:49

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.

Report message to a moderator

Re: Output is blank [message #459139 is a reply to message #459009]

Thu, 03 June 2010 09:35

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

Senior Member
Account Moderator

It is in the Property Inspector, somewhere at the bottom of the list.

Report message to a moderator

Re: Output is blank [message #459268 is a reply to message #459139]

Fri, 04 June 2010 04:32

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

Report message to a moderator

Re: Output is blank [message #459367 is a reply to message #459268]

Fri, 04 June 2010 09:19

Littlefoot
Messages: 21823
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')

Report message to a moderator

Previous Topic:	change value in run time
Next Topic:	Help with formatting html report output?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 05:37:19 CST 2024