OraFAQ Forum: Forms » how to print csv report from

Home » Developer & Programmer » Forms » how to print csv report from (forms 6i)

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

how to print csv report from [message #284912]

Sun, 02 December 2007 19:31

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

Report message to a moderator

Re: how to print csv report from [message #285019 is a reply to message #284912]

Mon, 03 December 2007 02:23

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

Report message to a moderator

Re: how to print csv report from [message #285154 is a reply to message #284912]

Mon, 03 December 2007 14:48

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.

Report message to a moderator

Re: how to print csv report from [message #285249 is a reply to message #285154]

Tue, 04 December 2007 01:37

Maaher
Messages: 7065
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 12:26:58 CST 2024