Re: SQR Printing to Other Than Default Printer

["Ross, Steven" <sross@KCM.ORG>]

The SQR manual (page 307) says that sqrwp is looking for a *.spf file,
rather than an *.sqt file.  Perhaps you need to run SQRWT instead....?

HTH,

Steven Ross
Programmer/Analyst
sross@kcm.org


> -----Original Message-----
> From: Adams-1, Milancie [mailto:Milancie.Adams-1@KMAIL.KSC.NASA.GOV]
> Sent: Wednesday, March 01, 2000 2:20 PM
> To: SQR-USERS@list.iex.net
> Subject: Re: SQR Printing to Other Than Default Printer
>
>
> 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
> >
>