Report to file... and after to printer. 1

[Fabmoda]

A simple question for you form a beginner...

I send the output of a report to a file in this manner

****************************
select * from dbtest into curso cur_dbtest
select cur_dbtest
report form dbtest to file test.rep

****************************

Now I've produced this file TEST.REP; how can I print it by using a printer?

bye
fabiano

 

[Mike Gagnon]

fabiano

DECLARE INTEGER ShellExecute IN "Shell32.dll" ;
    INTEGER hwnd, ;
    STRING lpVerb, ;
    STRING lpFile, ;
    STRING lpParameters, ;
    STRING lpDirectory, ;
    LONG nShowCmd
=Shellexecute(0,"Print","c:\TEST.REP","","",0)

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Fabmoda]

Sorry Mike,
I've try to run it but i've obtained nothing from my printer! Something about enviroment settings that I probably forgot to verify?

tnx

fabiano

 

[rgbean]

Fabiano,
I believe Mike's code assumes that the .REP extention is associated with a specific application. If it's NotePad, for example, then NotePad would fire up and print it. Since .REP isn't a standard extension, why not change it to .TXT, then all should work without other changes.

Note: Without the additional option of ASCII in your REPORT command, that file is going to have a lot of control characters that will be dependent on the current printer's Windows printer driver. NotePad, or any other application isn't going to intrpret these as expected!

Rick