Home » Developer & Programmer » Forms » Character mode Reports in Oracle Reports 10g ( Reports 10g)
Character mode Reports in Oracle Reports 10g [message #360062] Wed, 19 November 2008 07:40 Go to next message
manojbawage@gmail.com
Messages: 18
Registered: October 2008
Location: Mumbai
Junior Member

Dear All,
Can u please tell me that how could i call character base reports from form in oracle 10g.


Thank U
Manoj
Re: Character mode Reports in Oracle Reports 10g [message #360183 is a reply to message #360062] Thu, 20 November 2008 00:20 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What do you consider to be a 'character base report'?

David
Re: Character mode Reports in Oracle Reports 10g [message #360185 is a reply to message #360183] Thu, 20 November 2008 00:25 Go to previous messageGo to next message
manojbawage@gmail.com
Messages: 18
Registered: October 2008
Location: Mumbai
Junior Member

I am migrating my application from oracle 6i to 10g.
I have some reports which run in character mode format.
In web.show_documents the reports whose mode is CHARACTER are not working.
how to call these reports from form/menu.


Thank U
Manoj
Re: Character mode Reports in Oracle Reports 10g [message #360191 is a reply to message #360185] Thu, 20 November 2008 00:49 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please describe 'not working'. Please post the code you are using to run them.

David
Re: Character mode Reports in Oracle Reports 10g [message #360212 is a reply to message #360191] Thu, 20 November 2008 01:32 Go to previous messageGo to next message
manojbawage@gmail.com
Messages: 18
Registered: October 2008
Location: Mumbai
Junior Member

i am calling the report from form:
The code is
web.show_document('/reports/rwservlet?report='||mn||'
&userid='||'bar08'||'/'||'bar08'||'@'||'san48'||'
&desformat=pdf&destype=cache&mode=character
&P_BRANCH='||:PUR_HDR.BR_CODE||'
&PCOMP_CODE='||:PUR_HDR.COMP_CODE||'
&P_VNO='||:PUR_HDR.V_NO||'
&SHOW_DIFF_COMPARE_IN_GRN='||:SHOW_DIFF_IN_REPORT||'
&P_CAT_CODE='||:PUR_HDR.AC_CAT_CODE||'
&show_prod_cat_summary='||'Y'||'
&P_SHOW_ACT='||margin_markup||'
&server='||'rep_hpsrv13_OraBI'||'
&paramform=no','_blank');
END;
when i run the report i got the error

REP-1920: Character mode runtime incompatible with
DESFORMAT of PDF, HTML, HTMLCSS, SPREADSHEET or RTF.

I want to know that is there any way to call the character mode reports and view the output.

Thank U
Manoj
[EDITED by DJM: added code tags and removed superfluous blank lines]

[Updated on: Sun, 23 November 2008 23:49] by Moderator

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #360759 is a reply to message #360212] Sun, 23 November 2008 23:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What happens if you don't specify the 'mode' parameter?

David
Re: Character mode Reports in Oracle Reports 10g [message #360776 is a reply to message #360759] Mon, 24 November 2008 00:34 Go to previous messageGo to next message
manojbawage@gmail.com
Messages: 18
Registered: October 2008
Location: Mumbai
Junior Member

The same error.
I came to know that character base report cannot be called in pdf/html.
but one more thing that i want know is
how to use ORARRP ( ORAcle Reports Remote Printing) in web.show_documents for printing the report on node.


Thank U
Manoj.
Re: Character mode Reports in Oracle Reports 10g [message #360789 is a reply to message #360776] Mon, 24 November 2008 00:54 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Searching google for 'ORAcle Reports Remote Printing' returned http://www.oracle.com/technology/sample_code/products/reports/index.html

David
Re: Character mode Reports in Oracle Reports 10g [message #362241 is a reply to message #360789] Mon, 01 December 2008 07:39 Go to previous messageGo to next message
manojbawage@gmail.com
Messages: 18
Registered: October 2008
Location: Mumbai
Junior Member

is there any other way for direct printing of character mode reports to local printers.


Manoj
icon1.gif  Re: Character mode Reports in Oracle Reports 10g [message #413693 is a reply to message #362241] Fri, 17 July 2009 01:55 Go to previous messageGo to next message
rakitha
Messages: 1
Registered: August 2008
Location: Sri Lanka
Junior Member


Hi

If you use character mode reports in 10g then as you experienced you will face some problems. Best way you can overcome this issue is to install printers to server and send the character mode report with the help of a .prt file.

DESFORMAT = <name of the .prt file>
MODE = CHARACTER
DESTYPE = PRINTER
DESNAME = your printer name
.prt file you can copy into <your oracle home>/reports/printers location.

ORARRP is also a good solution that you can get the printout exactly the same way you did in 6i but the problem with ORARRP is you can't do that with network connected printers instead you have to share it to the local machine.

Re: Character mode Reports in Oracle Reports 10g [message #414600 is a reply to message #362241] Wed, 22 July 2009 20:57 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Produce the output as a text file and then use a 'prt' command via 'client_host' to output it.

David
Previous Topic: FRM-40735 ON -ERROR trigger raised unhandled exception ORA-04063
Next Topic: REP-51002: Bind to Reports Server repsrv01 failed
Goto Forum:
  


Current Time: Tue Dec 06 16:17:55 CST 2016

Total time taken to generate the page: 0.07415 seconds