Home » Developer & Programmer » Reports & Discoverer » Report Runtime Error (6i)
Report Runtime Error [message #529786] Thu, 03 November 2011 01:13 Go to next message
glmjoy
Messages: 166
Registered: September 2011
Location: KR
Senior Member
Dear All,
I am facing this problem in Report That when I run report
from Source RDF it shows me Column Data but when i run report from
run time it doesn't shows me two column data.

I have three Query Block Q1 which has columns
Invoice_No
Invoice_Date
Invoice_Amount
Igm_Auto_No

Another Query Block Q2 which has columns
Receipt_No
Document_No (Relation with Invoice No)Q1

Query Block Q3 which has columns
Deposit_No
Deposit_Date
SD_Amount
Igm_Auto_No (Relation with Igm_Auto_No)Q1

E.g

My Columns when I run RDF Shows Data which is correct
------------------------------------------
Inv No Inv Amt Receipt No Rpt_Amt Deposit No SD Amt
1 200 1 150 1 50
2 400 2 350 2 50 3 100 3 95 3 5

But when I run Rep Shows Data it hides column data Dep No Amount
------------------------------------------
Inv No Inv Amt Receipt No Rpt_Amt Deposit No SD Amt
1 200 1 150 (No Data Appearing)
2 400 2 350
3 100 3 95
Re: Report Runtime Error [message #529801 is a reply to message #529786] Thu, 03 November 2011 02:10 Go to previous messageGo to next message
Littlefoot
Messages: 21549
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are you sure you are executing the same report, in the same environment, connected to the same schema (database)?
Re: Report Runtime Error [message #529815 is a reply to message #529786] Thu, 03 November 2011 03:36 Go to previous messageGo to next message
glmjoy
Messages: 166
Registered: September 2011
Location: KR
Senior Member
Yes 100%
Re: Report Runtime Error [message #529816 is a reply to message #529815] Thu, 03 November 2011 03:39 Go to previous messageGo to next message
Littlefoot
Messages: 21549
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I thought you'll say so. Unfortunately, no further ideas.
Re: Report Runtime Error [message #529826 is a reply to message #529816] Thu, 03 November 2011 04:28 Go to previous messageGo to next message
cookiemonster
Messages: 13869
Registered: September 2008
Location: Rainy Manchester
Senior Member
Trace the session. Check it's executing the same query in the same way both times.
Re: Report Runtime Error [message #529830 is a reply to message #529826] Thu, 03 November 2011 04:57 Go to previous messageGo to next message
glmjoy
Messages: 166
Registered: September 2011
Location: KR
Senior Member
I have Trace the session and its executing both queries
Re: Report Runtime Error [message #529890 is a reply to message #529830] Thu, 03 November 2011 09:12 Go to previous messageGo to next message
cookiemonster
Messages: 13869
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do you really need 3 seperate query blocks? Based on your description I would have thought one would be enough.
Re: Report Runtime Error [message #530041 is a reply to message #529786] Fri, 04 November 2011 05:03 Go to previous messageGo to next message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

If any Parameter Value Passed 2 & 3 Query.
Re: Report Runtime Error [message #530043 is a reply to message #530041] Fri, 04 November 2011 05:08 Go to previous messageGo to next message
Littlefoot
Messages: 21549
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does that mean? /forum/fa/1580/0/
Re: Report Runtime Error [message #530146 is a reply to message #530043] Sat, 05 November 2011 00:13 Go to previous messageGo to next message
glmjoy
Messages: 166
Registered: September 2011
Location: KR
Senior Member
No Parameter is passing accurate cause I have only two parameter of dates. No I have to take three Query Block.
Re: Report Runtime Error [message #530738 is a reply to message #530146] Thu, 10 November 2011 01:38 Go to previous message
glmjoy
Messages: 166
Registered: September 2011
Location: KR
Senior Member
Thanks to all for supporting. I have redesign the report.


Previous Topic: convert mmatrix report in to xls
Next Topic: Oracle Reports Page Number Problem
Goto Forum:
  


Current Time: Wed Apr 08 23:46:32 CDT 2020