Re: [sqr-users] Eliminate printer specific character from SQR report

["PeterG Clark" <PeterG.Clark@vac-acc.gc.ca>]

Yes, there are other sqc's (and if there isn't, it is no big deal to create 
your own). But don't lose sight of the fact that by using "print" aspects 
(PRINT commands, printer declarations, page setup declarations, etc) you cannot 
expect SQR to *not* prepare your output for actual printing (in any of the many 
print mediums available in SQR). If you want a file that contains no printer 
control characters in it (and don't want to pass it through a subsequent 
process to strip the print control characters), it seems to me that you would 
have to create a flat file (with sufficient formatting to replicate your report 
layout) using OPEN, WRITE, CLOSE statements.

>>> yarlagaddacs@gmail.com 2005/07/05 10:55:43 >>>
I use setup32.sqc to produce the report. It has Printer-init command
in it. Is there another sqc to produce a landscape layout and not
produce the printer characters.

Chandra.

On 7/1/05, Steve Cavill <steve.cavill@infoclarity.com.au> wrote:
> That doesn't look like printer:lp that looks like PCL (printer:hp)
> Printer:lp should be plain text.
> You should check if you have a priner-init command in your sqr code which 
>looks like it may be incorrect.
> Steve.
> 
> -----Original Message-----
> From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org 
> [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On 
>Behalf Of Alexander, Steve
> Sent: Saturday, 2 July 2005 6:16 AM
> To: 'This list is for discussion about the SQR database reportinglanguagefrom 
>Hyperion Solutions.'
> Subject: RE: [sqr-users] Eliminate printer specific character from SQR report
> 
> I think those codes are specified in a "printer-init" command.  In the 
>Peoplesoft world, that command is part of the SETUPxxx.SQC
> include files.
> 
> -----Original Message-----
> From: Turner, Ivan [mailto:Ivan.Turner@qwest.com] 
> Sent: Friday, July 01, 2005 10:59 AM
> To: This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions.
> Subject: RE: [sqr-users] Eliminate printer specific character from SQR report
> 
> 
> The purpose of that line is to send control charachers to the printer for 
>things such as paper orientation, center, bold, etc.
> There is no way I know of to remove them.  If you copy the file to windows, 
>you can then COPY it to a printer path and it will give
> you the orientation specified by the control characters.
> 
> Fron the command line of windows,
> copy abc.lis //device/printer/abc.lis
> 
> -----Original Message-----
> From: sqr-users-bounces+ivan.turner=qwest.com@sqrug.org 
> [mailto:sqr-users-bounces+ivan.turner=qwest.com@sqrug.org] On Behalf Of 
>Chandra Yarlagadda
> Sent: Friday, July 01, 2005 1:13 PM
> To: sqr-users@sqrug.org 
> Subject: [sqr-users] Eliminate printer specific character from SQR report
> 
> Hi,
> 
> I am trying to produce an SQR report from an Unix machine in .lis format. I 
>am using the option of printer:lp. The report looks fine
> when I view in VI editor except for the first line which looks like
> 
> ^[E^[(0N^[&l1O^[&l6C^[&l0E^[&l60F^[(s17.60H^[&k2G
> 
> I know this are printer specific character. But I need to send the report 
>output to mainframe and viewed from there. So I need an
> option to eliminate these characters.
> 
> Can anyone help me in eliminating these character using any options.
> 
> Thanks,
> Chandra
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org 
> http://www.sqrug.org/mailman/listinfo/sqr-users 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org 
> http://www.sqrug.org/mailman/listinfo/sqr-users 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org 
> http://www.sqrug.org/mailman/listinfo/sqr-users 
> 
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org 
> http://www.sqrug.org/mailman/listinfo/sqr-users 
>

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users