Home » Developer & Programmer » Forms » how to print csv report from (forms 6i)
icon1.gif  how to print csv report from [message #284912] Sun, 02 December 2007 19:31 Go to next message
bala_kumar
Messages: 4
Registered: December 2007
Location: sydney
Junior Member
hi every one.
i'm lookin for help as for how to create a report in csv file from forms 6i.
it is based on the dates i enter as parameters and it should be emailed to the user who enters the data.
could somebody help me with the code for this please
many thanks
bala
Re: how to print csv report from [message #285019 is a reply to message #284912] Mon, 03 December 2007 02:23 Go to previous messageGo to next message
pushpendra.tomar
Messages: 11
Registered: January 2007
Location: Hyderabad
Junior Member

Hi Bala,

I have tried this method in my project.

Hope it works for you also.

Use The Built-in HOST as given below:

HOST('c:\windows\system32\print /D:device_name D:\full_path\file_name.txt',NO_SCREEN);
Here "HOST" is a built-in procedure which executes any operating system command.

device_name is: Printer port name. Ex- LPT1 or LPT2

I am trying here to print a file at the given 'D:\full_path\file_name.txt' location by executing PRINT command present in operating system.

This command works well with the printer connected to LPT ports
but, I am not sure how it behaves with USB port printers.

Best of Luck

Pushpendra

Re: how to print csv report from [message #285154 is a reply to message #284912] Mon, 03 December 2007 14:48 Go to previous messageGo to next message
bala_kumar
Messages: 4
Registered: December 2007
Location: sydney
Junior Member
thanks for replying, but that was not what i was lookin for. i would like to know what procedure to be written to create this file from a from where we are passing parameter into the cursor to get the needed data.
Re: how to print csv report from [message #285249 is a reply to message #285154] Tue, 04 December 2007 01:37 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Here's what I would do: I'd use a server side stored procedure to write the file (through UTL_FILE or OWA_SYLK). Then you can decide whether you want to call the file with parameters or simply pass SYSTEM.LAST_QUERY to it.

Note: OWA_SYLK is not standard Oracle, but you'll find the source on the net. It offers a bit of formatting.

MHE
Previous Topic: how can i import ole library in forms developer 9i?
Next Topic: make HOST cmd
Goto Forum:
  


Current Time: Fri Dec 09 15:22:37 CST 2016

Total time taken to generate the page: 0.24236 seconds