OraFAQ Forum: Forms » Character mode Reports in Oracle Reports 10g

Home » Developer & Programmer » Forms » Character mode Reports in Oracle Reports 10g ( Reports 10g)

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

Character mode Reports in Oracle Reports 10g [message #360062]

Wed, 19 November 2008 07:40

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

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #360183 is a reply to message #360062]

Thu, 20 November 2008 00:20

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

Senior Member
Account Moderator

What do you consider to be a 'character base report'?

David

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #360185 is a reply to message #360183]

Thu, 20 November 2008 00:25

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

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #360191 is a reply to message #360185]

Thu, 20 November 2008 00:49

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

Senior Member
Account Moderator

Please describe 'not working'. Please post the code you are using to run them.

David

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #360212 is a reply to message #360191]

Thu, 20 November 2008 01:32

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

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

Senior Member
Account Moderator

What happens if you don't specify the 'mode' parameter?

David

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #360776 is a reply to message #360759]

Mon, 24 November 2008 00:34

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.

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #360789 is a reply to message #360776]

Mon, 24 November 2008 00:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #362241 is a reply to message #360789]

Mon, 01 December 2008 07:39

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

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #413693 is a reply to message #362241]

Fri, 17 July 2009 01:55

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.

Report message to a moderator

Re: Character mode Reports in Oracle Reports 10g [message #414600 is a reply to message #362241]

Wed, 22 July 2009 20:57

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:33:07 CDT 2024