OraFAQ Forum: Reports & Discoverer » rep 1800 formatter error

Home » Developer & Programmer » Reports & Discoverer » rep 1800 formatter error (oracle 8i)

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

rep 1800 formatter error [message #402772]

Tue, 12 May 2009 07:40

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

Hi,

I am working in oracle 8i and have generated a report which when i try to save it pdf format

file >> generate to file >> pdf

it gives an error rep 1800 formatter error

i would like to know the solution for this

thanks in advance

narayan

Report message to a moderator

Re: rep 1800 formatter error [message #402776 is a reply to message #402772]

Tue, 12 May 2009 07:46

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

Senior Member
Account Moderator

REP-1800 indicates an abnormal condition.

Oracle

Sometimes you may encounter an error that is known as an abnormal condition, which may arise from one of the following causes:

Someone has done something that prevented your application from completing the requested task. For example, if someone bypassed the user interface and changed data in a database table, they might have typed an invalid value.
A software bug prevented the requested task from completing.

Action: First contact your system administrator to determine if the message was caused by something other than Oracle Reports. If you determine that the message was not the result of user error or a system problem, then contact Oracle Support Services.

Report message to a moderator

Re: rep 1800 formatter error [message #403339 is a reply to message #402776]

Thu, 14 May 2009 22:39

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

hi,
We don't have any system administrator in our office. I am the only person using oracle, so someone changing data does not ar
ise.

Pl suggest some solution and I don't face such problem in any of my other report

narayan

Report message to a moderator

Re: rep 1800 formatter error [message #403360 is a reply to message #403339]

Fri, 15 May 2009 01:04

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

Senior Member
Account Moderator

Does the report work OK when you don't try to generate it to a PDF file?

You might try to install one of (free) virtual PDF printers (such as PrimoPDF) and "print" to it.

Report message to a moderator

Re: rep 1800 formatter error [message #403707 is a reply to message #403360]

Mon, 18 May 2009 03:25

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

hi,

yes, it works perfectly fine .Only thing is i am unable to save it in pdf format

narayan

Report message to a moderator

Re: rep 1800 formatter error [message #663102 is a reply to message #403707]

Mon, 22 May 2017 07:38

shawaj
Messages: 89
Registered: January 2016

Member

hello everyone ,
I am getting same errore as rep 1800 formatter error
and my report version is
Report Builder 11.1.1.2.0
ORACLE Server Release 11.1.0.7.0
Oracle Procedure Builder 11.1.1.2.0
Oracle ORACLE PL/SQL V11.1.0.7.0 - 64bit Production
Oracle CORE 11.1.0.7.0 Production
Oracle Tools Integration Services 11.1.1.2.0

If i run my report for 01-jan-2016 to 31-dec-2016 in report builder,It run without any error but
while i run this report by application then i got error -rep-1800
I have increased my report builder buffer size to (1024) [Edit-preferences-runtime setting -buffurs=10224]

Please help me
Thanks in advance

Report message to a moderator

Re: rep 1800 formatter error [message #663105 is a reply to message #663102]

Mon, 22 May 2017 07:42

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

Senior Member
Account Moderator

Consider applying TO_DATE function with the appropriate format mask, such as

where my_date_column between to_date('01.01.2016', 'dd.mm.yyyy')
                         and to_date('31.12.2016', 'dd.mm.yyyy')

Report message to a moderator

Re: rep 1800 formatter error [message #663108 is a reply to message #663105]

Mon, 22 May 2017 07:58

shawaj
Messages: 89
Registered: January 2016

Member

Thanks for reply

All data and parameters are ok .

Report is running for 01-jan-2016 to 30-oct-2016

Report message to a moderator

Re: rep 1800 formatter error [message #663136 is a reply to message #663108]

Tue, 23 May 2017 06:07

shawaj
Messages: 89
Registered: January 2016

Member

Please anyone guide me ...

Report message to a moderator

Re: rep 1800 formatter error [message #663147 is a reply to message #663136]

Tue, 23 May 2017 10:31

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

How do you know the parameters are ok?
Does it work for any date range in report builder?
Does it not work for any date range from application?

If so the trouble may be due to different nls_date_formats.

Report message to a moderator

Re: rep 1800 formatter error [message #663157 is a reply to message #663147]

Wed, 24 May 2017 02:27

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

Senior Member
Account Moderator

... which might be avoided with the TO_DATE function.

Report message to a moderator

Re: rep 1800 formatter error [message #663246 is a reply to message #663157]

Fri, 26 May 2017 18:26

shawaj
Messages: 89
Registered: January 2016

Member

Dear Littlefoot,
Yes, It works fine for 01-jan-2016 to 31-dec-2016 in report builder.
And it works also for 01-jan-2016 to 30-oct-2016 from application
but does not work for 01-jan-2016 to 31-dec-2016 from application

Report message to a moderator

Re: rep 1800 formatter error [message #663273 is a reply to message #663246]

Sat, 27 May 2017 08:34

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

Senior Member
Account Moderator

I'm not sure whether you applied TO_DATE function or not. In any case, you should have.

Take (copy) query from the report and run it (paste) in a tool you use to access the database (such as SQL*Plus, SQL Developer, TOAD, ...), passing November and December as parameters. Make sure query returns ALL rows (i.e. not only the first 100 or so that GUI tools usually return). What happens?

Report message to a moderator

Previous Topic:	How to subtract previous row from current row in Oracle Report
Next Topic:	Function EAN 13 Oracle Forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 22:08:39 CST 2025