OraFAQ Forum: Forms » reports behaving differently

Home » Developer & Programmer » Forms » reports behaving differently

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

reports behaving differently [message #259162]

Tue, 14 August 2007 09:48

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

Whenever i open the old report ,it asks me to compile everytime
even if i don't change the code.
when i run it pop ups a message saying uncompiled program unit exists.

Please can somebody tell me why its behaving like this.

Thanks
Srinivas

Report message to a moderator

Re: reports behaving differently [message #259235 is a reply to message #259162]

Tue, 14 August 2007 15:44

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

Senior Member
Account Moderator

Try to (always!) use the COMPILE ALL (<Shift> + <Ctrl> + K) instead of (usual) INCREMENTAL (<Ctrl> + K). It will probably not help, but that's the best I can do at the moment.

Report message to a moderator

Re: reports behaving differently [message #259253 is a reply to message #259162]

Tue, 14 August 2007 19:36

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do you have both the 'rdf' and the 'rep' files? If so, get rid of the generated report and never generate them again.

David

Report message to a moderator

Re: reports behaving differently [message #261997 is a reply to message #259162]

Fri, 24 August 2007 05:47

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

I have both rdf and rep files.Do you mean i should remove rep files permanently and use only rdf.
And i got some thing on this.
When i remove all formula columns from report then it is working fine.
Any idea how to solve this.
Why it ask for compilation everytime when i add a small fromula column but when i remove it will not ask for compilation.

Any idea.

Report message to a moderator

Re: reports behaving differently [message #262388 is a reply to message #261997]

Sun, 26 August 2007 21:59

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Concerning your question "Do you mean i should remove rep files permanently and use only rdf." Yes! When I said "get rid of the generated report and never generate them again" I meant 'get rid of the generated report and never generate them again'.

Have you used Ctrl-Shft-K on your report and then saved them?

David

Report message to a moderator

Re: reports behaving differently [message #263144 is a reply to message #259162]

Wed, 29 August 2007 03:51

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi thanks for your solutions.
I got the solution.
In the procedure which call the report.
The report was refering different schema which does not have permission to select the tables.
So it was giving uncompiled error.But once i changed that to the present working schema its working fine.

Report message to a moderator

Previous Topic:	Search form
Next Topic:	How can I display data in Excel Sheet

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 12:32:54 CDT 2025