Home » Developer & Programmer » Reports & Discoverer » REP-1219 with text file (Oracle Reports Developer 10.1.2.0.2, Unix, 10 G database)
REP-1219 with text file [message #565495] Tue, 04 September 2012 13:55 Go to next message
TX_developer
Messages: 46
Registered: July 2011
Member
Hi,

I have a report that runs fine if I run it from the developer whether to preview or to file. The users are running this report from an Oracle Forms app and have a drop down for the destination format. If they run it to PDF for example, the report runs fine. If they run it to TXT132, TXT180, or TXT they get a "REP-1219 'FIELD_NAME' has no size -- length or width is zero".

Of course I am unable to get into the test application right now and as I mentioned above, I am unable to duplicate the error when I run the report from the developer. Has anybody encountered this problem before? I am not sure why I would get a REP-1219 only when running to a TXT file.

Any suggestions are appreciated.

Thank you,
~k
Re: REP-1219 with text file [message #565499 is a reply to message #565495] Tue, 04 September 2012 15:15 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Huh, that's really stupid error and I hate it (I'm glad YOU got it, not me). It says that - if you open a Paper Layout Editor - there's a field whose length or width are zero and you can't even see it on the screen. It helps if you know which field it is - then, you'd delete it from Object Navigator or from the query itself, recompile the report, run it (to make sure it works OK), and then create that field again.

Perhaps you could try to recompile the report as it is (Compile All: Ctrl + Shift + K) before taking other steps.
Re: REP-1219 with text file [message #565502 is a reply to message #565499] Tue, 04 September 2012 15:41 Go to previous messageGo to next message
TX_developer
Messages: 46
Registered: July 2011
Member
Hi Littlefoot,

Thank you for the reply. The problem is, I CAN see the field and it works fine for everything BUT when the user runs it to a TXT file. I can't even duplicate the error.

Thoughts?

Kristina
Re: REP-1219 with text file [message #565503 is a reply to message #565502] Tue, 04 September 2012 15:43 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As I said:
a) try to Ctrl + Shift + K
b) delete the field, recompile, recreate the field

I can't promise either of these will actually help; sorry.
Re: REP-1219 with text file [message #565639 is a reply to message #565503] Wed, 05 September 2012 14:57 Go to previous messageGo to next message
TX_developer
Messages: 46
Registered: July 2011
Member
Thanks - that worked. And now I am getting the same error on another field. I assume this is one of those quirky Oracle Reports issues and all I can do is to keep deleting and recreating fields?

Thank you...
Re: REP-1219 with text file [message #565640 is a reply to message #565639] Wed, 05 September 2012 15:01 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unfortunately, that's the only way I know. Hopefully, someone will know better (I'd be happy if he/she posts the solution here!).
Re: REP-1219 with text file [message #565641 is a reply to message #565639] Wed, 05 September 2012 15:01 Go to previous messageGo to next message
TX_developer
Messages: 46
Registered: July 2011
Member
Oh, and now it's on a text field that is just a dotted line under the report total! Do I just need to delete every single field and recreate it?
Re: REP-1219 with text file [message #565642 is a reply to message #565640] Wed, 05 September 2012 15:03 Go to previous messageGo to next message
TX_developer
Messages: 46
Registered: July 2011
Member
Thanks - and this IS an Oracle Reports issue, right? I think my boss thinks I am crazy!
Re: REP-1219 with text file [message #565643 is a reply to message #565642] Wed, 05 September 2012 15:12 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe it is Reports; out of all Oracle software I've worked with, Reports seems to be the most unstable and unpredictable. For example, I can't remember Forms ever crashed. But Reports ... whoa, number of reports that were lost because they were sorry for the inconvenience is huge. "Save frequently" is Reports' mantra.
Re: REP-1219 with text file [message #565644 is a reply to message #565643] Wed, 05 September 2012 15:14 Go to previous message
TX_developer
Messages: 46
Registered: July 2011
Member
I appreciate the feedback. I am still so new to all this that it's nice to get reassurance that I am not just crazy. LOL
Previous Topic: how to call report automatically
Next Topic: List Discoverer Calculations used in EUL
Goto Forum:
  


Current Time: Thu Mar 28 03:58:43 CDT 2024