Report Printing through Network [message #449312] |
Mon, 29 March 2010 02:59 |
me_lucky
Messages: 22 Registered: June 2009
|
Junior Member |
|
|
Hi All,
I am using report 10g for generating report,
My requirement is to generate the report in pdf, but once report get generated it should directly go the printer in the network or the default printer attache to the client system.
I use destype as PRINTER but i didn't get the desire result.
Can anyone help me out in acheiving this requirement.
Thanks,
Lucky.
|
|
|
|
|
Re: Report Printing through Network [message #449476 is a reply to message #449312] |
Mon, 29 March 2010 21:05 |
Kaeluan
Messages: 179 Registered: May 2005 Location: Montreal, Quebec
|
Senior Member |
|
|
Maybe this is your problem,
Very often Oracle services in windows are running as system user so this mean Report server will have access only to printer directly connected on the server and will have no access to network.
To solve this problem you have to start Oracle services as domain user and when sending report to printer you need to specify the network path like \\servername\printername
|
|
|
Re: Report Printing through Network [message #449489 is a reply to message #449476] |
Mon, 29 March 2010 23:40 |
me_lucky
Messages: 22 Registered: June 2009
|
Junior Member |
|
|
Hi,
Thanks for the reply.
I have statred the Oracle service as administrator, and gave the path as u said.
but the problem is my Printer name is like 'HP colour Laser...." , when am passing this input, its taking till HP,
my doubt is
1) printer name should not contain space
2) the Printer has to be added on the application server or, if it in network, then it will be enough?
Pl clarify me.
Thank U,
Lucky.
|
|
|
Re: Report Printing through Network [message #449582 is a reply to message #449312] |
Tue, 30 March 2010 11:57 |
Kaeluan
Messages: 179 Registered: May 2005 Location: Montreal, Quebec
|
Senior Member |
|
|
Quote:1) printer name should not contain space
Not sure about this. I think it should work or maybe you can add double quote for you printer name like desname="\\server\printer"
Quote:2) the Printer has to be added on the application server or, if it in network, then it will be enough?
Actually we have no printer define on the application server, all our printer are on another printer server. Our application server is running on Win2003 and i think we at least add the printer driver on the server to allow printing.
To do this click on windows Start button and go in "Printers and faxes". Right click in the backgroud of the window and select the menu "Server Properties". Click on Drivers tab and add your printer. This will load the driver and i think create the printer also. But you can delete the printer after this and the driver will stay there.
Hope it help
|
|
|
Re: Report Printing through Network [message #449659 is a reply to message #449312] |
Wed, 31 March 2010 05:11 |
me_lucky
Messages: 22 Registered: June 2009
|
Junior Member |
|
|
Hi,
thanks for the reply.
it was quite helpfull;
i have given the printer name in double quotes, but still its not working.
with second approach its working.
And i need one more help, is it possible to get the print to the local PC's default Printer (if any default Printer exists).
Thanks in Advance,
Lucky.
|
|
|
Re: Report Printing through Network [message #449675 is a reply to message #449312] |
Wed, 31 March 2010 06:55 |
Kaeluan
Messages: 179 Registered: May 2005 Location: Montreal, Quebec
|
Senior Member |
|
|
Hi,
I don`t think it`s possible to print directly on the local printer. I think you may have to put the printer in Sharing mode and this will allow you to print on it using network path like \\client_machine\printer name
The other way to do it is to send your report in preview. From there the user can print it using the application that open the report and send it to local printer.
Hope it help
|
|
|
|
|
|