Re: SQR Printing to Other Than Default Printer

["Adams-1, Milancie" <Milancie.Adams-1@KMAIL.KSC.NASA.GOV>]

Deepak,  Thankyou for your help

I including the SQRDIR as you suggested

and in my VB program I have

   CommandStr = "c:\sqr\ora\binw\sqrwp.exe
p:\Milancie\testingprinting\note_qa.sqt -printer:wp"
   RetVal = Shell(CommandStr)

Now the command executes with no error but nothing prints

So I tried the following:

CommandStr = "c:\sqr\ora\binw\sqrwp.exe"
RetVal = Shell(CommandStr)

which successfussly launches sqr program in a window.

So for some reason it is not accepting the passing of the program parameter

Any other ideas?

Thanks

Milancie




> ----------
> From:         Deepak Joshi[SMTP:djoshi@ERAC.COM]
> Sent:         Wednesday, March 01, 2000 1:45 PM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: SQR Printing to Other Than Default Printer
>
> Add the environment variable to the sqr.ini file
> as given below
> [Environment:Common]
> SQRDIR={Path Name} which I think should be "c:\sqr\ora\binw\"
>
> The sqr.ini file will be located in the same folder.
>
> Deepak
>
> -----Original Message-----
> From: Discussion of SQR, Brio Technology's database reporting language
> [mailto:SQR-USERS@list.iex.net]On Behalf Of Adams-1, Milancie
> Sent: Wednesday, March 01, 2000 11:22 AM
> To: SQR-USERS@list.iex.net
> Subject: SQR Printing to Other Than Default Printer
>
>
> We have a need to alter the printer to which a sqr report will be printed
> to
> something other than the default printer without user manual intervention.
> We have several printers at various locations and need to print reports on
> these printers at various intervals.
>
> Our solution that we tried
>
> Was to have a Visual Basic Program to control the printing of these
> reports
> by first altering the default printer by launching a Visual Basic Script.
> This part works but then when we try to execute the following command
> after
> this in VB to print the sqr report to the printer
>
> CommandStr = "c:\sqr\ora\binw\sqrwp
> p:\Milancie\testingprinting\qa_note.spf"
> RetVal = Shell(CommandStr)
>
>
> We qet the following error
>
> SQR 14  SQRDIR not defined
>
> Has anyone successfully done something similar and have a solution you
> willing to share?
>
> Thanks
> Milancie
>