From owner-sqr-users@list.iex.net Sat Jul 1 01:06:25 2000 Date: Sat, 1 Jul 2000 00:00:00 -0500 From: Nathan Stratton Treadway Subject: Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathant@ontko.com) $Revision: 1.5 $ $Date: 1999-08-31 18:59:00-04 $ This document gathers in one location information about the sqr-users mail list. Directions for common list-server commands (including unsubscribing) are given, as are guidelines for list usage. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Basic List Server Commands 3.1 Subscribing to the List 3.2 Unsubscribing from the List 3.3 Digests 3.4 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 1999/04/30: o Reflected the takeover of SQRIBE Technologies by Brio Technology and the resulting new product names (throughout document). o Added additional hints to the "Posting to the sqr-users List" section. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Brio Technology (and to other products in the Brio.Report line). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. The Brio website has more information on the merger. The mailing list is provided as a service of Ray Ontko & Co. . A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 2.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.com/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is (C)Copyright 1999 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). To join, follow the link above, or send any message to "psusers-subscribe@egroups.com" . rm-users : ReportMart Users List for discussion of Brio.Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.com". 3. Basic List Server Commands Note: The list used to be hosted on usa.net , but the list-hosting service was moved to list.iex.net . The old addresses for the list, list server, and list owner no longer work. A few basic list server commands are listed below. Send these commands as the only line in the body (not the subject line) of an e- mail message sent to "listserv@list.iex.net". 3.1. Subscribing to the List To subscribe to the mailing list, the command is subscribe sqr-users Your Name Note that you do not need to provide your e-mail address as it is taken from your message's header. You will be e-mailed a confirmation number, which you must then send back to the list server software before the command goes into effect. 3.2. Unsubscribing from the List To unsubscribe, the command is simply unsubscribe sqr-users Once again, you will need to confirm your command before it goes into effect. 3.3. Digests Once you are subscribed, you can request to get your messages in digest form (one large message containing all of the posts made each day) by sending the command set sqr-users digests If you use digests you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. Use "nodigests" instead of "digests" to restore normal distribution. 3.4. Problems If the above commands do not work, please contact the list manager at "sqr-users-request@list.iex.net". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a copy of the error message you received from the list server. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list in reply from other subscribers.) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@list.iex.net". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o Brio product and version number o Operating system and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. To find out your version of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system version number listed here is the one under which this copy of SQR was compiled, so you'll still need to include your own information. 4.3. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the original question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) In particular, in order to prevent mail loops, the list server will not accept messages that contain From:, Sender:, etc. lines pointing back to the sqr-users list, even if these lines are quoted (i.e. with ">" characters). Be sure to delete these from your reply message before sending it. 5. Job Announcements SQR-related job announcements are currently allowed on the list, subject to the following restrictions: o The subject line must begin with the words "JOB ANNOUNCEMENT:". o The message should be very short (fewer than 20 lines), giving brief details of the job and a way for those interested to get more information directly (i.e. web page or phone number). o The message should specifically remind people interested in the job to respond directly to the message author (and not to use their mailer's "reply" function, since that would send the reply out on the list). o Post job announcements as infrequently as possible. From owner-sqr-users@list.iex.net Wed Jul 5 08:28:17 2000 Date: Wed, 5 Jul 2000 12:39:05 +0100 From: "Slattery, Chad" Subject: Paper size This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFE675.A2A1FB70 Content-Type: text/plain; charset="iso-8859-1" Hi all, Im using an IBM line printer and have been printing an spf on to US standard fanfold. Our printer suppliers have now decided they cant produce that size paper any more (dont ask!!) and have supplied us with paper an inch longer. Although I can set the paper size in several different ways manually in my report and from the preferences in visual sqribe the spf is still printing with the old paper size. I know its because Im choosing US standard Fanfold as my paper type when Im printing but I thought (hopefully and foolishly) setting the paper as longer in sqribe might have overrided it. The new paper size is 14.5 x 12 inches. Anybody got any ideas? I increased my page-size in my sqr from 60 132 to 68 132, but it still prints as tho the paper is 11 inches high. The printer driver is IBM proprinter XL III tia. Chad. ------_=_NextPart_001_01BFE675.A2A1FB70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Paper size

Hi all,
Im using an IBM line printer and have been printing = an spf on to US standard fanfold.  Our printer suppliers have now = decided they cant produce that size paper any more (dont ask!!) and = have supplied us with paper an inch longer.  Although I can set = the paper size in several different ways manually in my report and from = the preferences in visual sqribe the spf is still  printing with = the old paper size.  I know its because Im choosing US standard = Fanfold as my paper type when Im printing but I thought (hopefully and = foolishly) setting the paper as longer in sqribe might have overrided = it. 

The new paper size is 14.5 x 12 inches.  Anybody = got any ideas?
I increased my page-size in my sqr from 60 132  = to  68 132, but it still prints as tho the paper is 11 inches = high.
The printer driver is IBM proprinter XL III

tia.

Chad.

------_=_NextPart_001_01BFE675.A2A1FB70-- From owner-sqr-users@list.iex.net Wed Jul 5 08:50:21 2000 Date: Wed, 5 Jul 2000 09:39:32 -0300 From: Peter Clark Subject: Re: Paper size Chad, Don't specify paper type. Using a predefined paper type will establish width and depth settings that will overide whatever you specify in those parameters. Instead, let the paper-size parameter in your declare-layout specify the actual dimensions, i.e. paper-size=(14.5in, 12in). Also, don't use the page-size command. HTH, Peter >>> "Slattery, Chad" 2000/07/05 8:39:05 am >>> Hi all, Im using an IBM line printer and have been printing an spf on to US standard fanfold. Our printer suppliers have now decided they cant produce that size paper any more (dont ask!!) and have supplied us with paper an inch longer. Although I can set the paper size in several different ways manually in my report and from the preferences in visual sqribe the spf is still printing with the old paper size. I know its because Im choosing US standard Fanfold as my paper type when Im printing but I thought (hopefully and foolishly) setting the paper as longer in sqribe might have overrided it. The new paper size is 14.5 x 12 inches. Anybody got any ideas? I increased my page-size in my sqr from 60 132 to 68 132, but it still prints as tho the paper is 11 inches high. The printer driver is IBM proprinter XL III tia. Chad. From owner-sqr-users@list.iex.net Wed Jul 5 09:38:09 2000 Date: Wed, 5 Jul 2000 14:29:00 +0100 From: "Slattery, Chad" Subject: Re: Paper size This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFE684.FC18CDBE Content-Type: text/plain; charset="iso-8859-1" Peter, Thanks for the reply, Im printing from NT, when I go to print I _have_ to pick a paper type from the print properties, we had been using the US fanfold, so I suppose my question should really be is there any way to bypass the NT printer driver, or the paper selection of the driver? Previously I had been using page-size 68 132, but it wasnt working so I changed to the below setup with no change. Ive mucked about with all of the variables below with no effect either. begin-setup declare-report chad layout=page printer-type=LINEPRINTER end-declare declare-layout page max-columns=132 max-lines=68 paper-size = (14.5,12) end-declare end-setup -----Original Message----- From: Peter Clark [mailto:PGCLARK@VAC-ACC.GC.CA] Sent: Wednesday, July 05, 2000 1:40 PM To: SQR-USERS@LIST.IEX.NET Subject: Re: Paper size Chad, Don't specify paper type. Using a predefined paper type will establish width and depth settings that will overide whatever you specify in those parameters. Instead, let the paper-size parameter in your declare-layout specify the actual dimensions, i.e. paper-size=(14.5in, 12in). Also, don't use the page-size command. HTH, Peter >>> "Slattery, Chad" 2000/07/05 8:39:05 am >>> Hi all, Im using an IBM line printer and have been printing an spf on to US standard fanfold. Our printer suppliers have now decided they cant produce that size paper any more (dont ask!!) and have supplied us with paper an inch longer. Although I can set the paper size in several different ways manually in my report and from the preferences in visual sqribe the spf is still printing with the old paper size. I know its because Im choosing US standard Fanfold as my paper type when Im printing but I thought (hopefully and foolishly) setting the paper as longer in sqribe might have overrided it. The new paper size is 14.5 x 12 inches. Anybody got any ideas? I increased my page-size in my sqr from 60 132 to 68 132, but it still prints as tho the paper is 11 inches high. The printer driver is IBM proprinter XL III tia. Chad. ------_=_NextPart_001_01BFE684.FC18CDBE Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Paper size

Peter,
Thanks for the reply,
Im printing from NT, when I go to print I _have_ to = pick a paper type from the print properties, we had been using the US = fanfold, so I suppose my question should really be is there any way to = bypass the NT printer driver, or the paper selection of the = driver?

Previously I had been using page-size 68 132, but it = wasnt working so I changed to the below setup with no change.  Ive = mucked about with all of the variables below with no effect = either.


begin-setup
 declare-report chad
     layout=3Dpage
     = printer-type=3DLINEPRINTER
 end-declare

 declare-layout page
    max-columns=3D132
    max-lines=3D68
    paper-size =3D (14.5,12)
  end-declare
end-setup



-----Original Message-----
From: Peter Clark [mailto:PGCLARK@VAC-ACC.GC.CA]<= /FONT>
Sent: Wednesday, July 05, 2000 1:40 PM
To: SQR-USERS@LIST.IEX.NET
Subject: Re: Paper size


Chad,

Don't specify paper type. Using a predefined paper = type will establish width and depth settings that will overide whatever = you specify in those parameters. Instead, let the paper-size parameter = in your declare-layout specify the actual dimensions, i.e. = paper-size=3D(14.5in, 12in). Also, don't use the page-size = command.

HTH,
Peter

>>> "Slattery, Chad" = <Chad.Slattery@CSCLAC.IRLGOV.IE> 2000/07/05 8:39:05 am = >>>
Hi all,
Im using an IBM line printer and have been printing = an spf on to US standard
fanfold.  Our printer suppliers have now = decided they cant produce that size
paper any more (dont ask!!) and have supplied us = with paper an inch longer.
Although I can set the paper size in several = different ways manually in my
report and from the preferences in visual sqribe the = spf is still  printing
with the old paper size.  I know its because Im = choosing US standard Fanfold
as my paper type when Im printing but I thought = (hopefully and foolishly)
setting the paper as longer in sqribe might have = overrided it.
The new paper size is 14.5 x 12 inches.  = Anybody got any ideas?
I increased my page-size in my sqr from 60 132  = to  68 132, but it still
prints as tho the paper is 11 inches high.
The printer driver is IBM proprinter XL III

tia.

Chad.

------_=_NextPart_001_01BFE684.FC18CDBE-- From owner-sqr-users@list.iex.net Wed Jul 5 10:04:20 2000 Date: Wed, 5 Jul 2000 10:53:38 -0300 From: Peter Clark Subject: Re: Paper size Hi Chad, Not working in the NT environment, I don't know what I can offer. In W95, we only have to choose from Windows print properties when we are using -printer:wp or using SQRV. In those cases, our print dialogue box allows us to create a "custom" paper size definition where you can define your own paper dimensions (i.e. special forms, etc). Are you not able to do that in NT? Beyond that feable advice, I can offer no other suggestions. Sorry. Peter >>> "Slattery, Chad" 2000/07/05 10:29:00 am >>> Peter, Thanks for the reply, Im printing from NT, when I go to print I _have_ to pick a paper type from the print properties, we had been using the US fanfold, so I suppose my question should really be is there any way to bypass the NT printer driver, or the paper selection of the driver? Previously I had been using page-size 68 132, but it wasnt working so I changed to the below setup with no change. Ive mucked about with all of the variables below with no effect either. begin-setup declare-report chad layout=page printer-type=LINEPRINTER end-declare declare-layout page max-columns=132 max-lines=68 paper-size = (14.5,12) end-declare end-setup -----Original Message----- From: Peter Clark [mailto:PGCLARK@VAC-ACC.GC.CA] Sent: Wednesday, July 05, 2000 1:40 PM To: SQR-USERS@LIST.IEX.NET Subject: Re: Paper size Chad, Don't specify paper type. Using a predefined paper type will establish width and depth settings that will overide whatever you specify in those parameters. Instead, let the paper-size parameter in your declare-layout specify the actual dimensions, i.e. paper-size=(14.5in, 12in). Also, don't use the page-size command. HTH, Peter >>> "Slattery, Chad" 2000/07/05 8:39:05 am >>> Hi all, Im using an IBM line printer and have been printing an spf on to US standard fanfold. Our printer suppliers have now decided they cant produce that size paper any more (dont ask!!) and have supplied us with paper an inch longer. Although I can set the paper size in several different ways manually in my report and from the preferences in visual sqribe the spf is still printing with the old paper size. I know its because Im choosing US standard Fanfold as my paper type when Im printing but I thought (hopefully and foolishly) setting the paper as longer in sqribe might have overrided it. The new paper size is 14.5 x 12 inches. Anybody got any ideas? I increased my page-size in my sqr from 60 132 to 68 132, but it still prints as tho the paper is 11 inches high. The printer driver is IBM proprinter XL III tia. Chad. From owner-sqr-users@list.iex.net Wed Jul 5 14:09:18 2000 Date: Wed, 5 Jul 2000 17:34:49 GMT From: Ragu Sadasivam Subject: Re: HTML Output - Help !!!

Hi,

I have an sqr program which produces an SPF file as output.  Now we have to provide a HTML output and also split the files for each department.

  • I am using the new-report feature for splitting the files for each department.  This is working, but the extension for the file names are lost.  Only one file has the extension .htm.  I am using the -Printer:HT in the SQR Flags.  It is also automatically generating the TOC.  How do I suppress this?
  • What is the simplest way to do generate a HTML output from the existing sqr ? [The SQR guide mentions a command line that is supposed to convert SPF files to HTML output, which is not working;  So is the "Save As" command within the SQR Viewer - no clue as to where the HTML output goes].  I am receiving html output, but the output is not similar to what we receive in the SPF files.  For instance, we have condensed output and I am not able to get this.  I do get the smallest font, but when I print this, the right most columns are dropped.  Any idea how I can solve this problem?  Is there any setting in the .ini file that I need to take care of?  If anyone has a sample sqr, it would help me very much.

Any help in this matter would be appreciated very much.

Thanks in advance.

LKR.

 

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
From owner-sqr-users@list.iex.net Wed Jul 5 14:17:36 2000 Date: Wed, 5 Jul 2000 15:04:39 -0300 From: Peter Clark Subject: Re: HTML Output - Help !!! Ragu, The probability of receiving an answer to your question would be greatly enhanced if you would use text format for those of us whose office email systems do not support html format e-mail. Peter Of course, those of us without html support in our corporate email software would likely have little to contribute on a question about html :-) >>> Ragu Sadasivam 2000/07/05 2:34:49 pm >>> wrote: [indecipherable - non text format] From owner-sqr-users@list.iex.net Wed Jul 5 14:20:47 2000 Date: Wed, 5 Jul 2000 14:09:37 -0400 From: Michael Phillips Subject: Re: HTML Output - Help !!! I did something like this let $FileName2 = 'c:\temp\File1.htm' NEW-REPORT $FileName1 ...Processing to create the report... NEW-REPORT "temp.htm" !This will close the current report. Don't worry, it you never write to this report, then it won't be saved Then I delete the frame file that is automatically created because I had no need for it. The report has to be closed first. let $FrameFileName = 'c:\temp\file1_frm.htm' let #DelStatus = delete($FrameFileName) I would loop through this process until I have no more reports to create. In the process scheduler, I set this up to run on the client. It would not run on the server; the job would finish with no errors, but no output would be created. I also used -PRINTER:EH instead of -PRINTER:HT as the flag. -----Original Message----- From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] Sent: Wednesday, July 05, 2000 1:35 PM To: SQR-USERS@list.iex.net Subject: Re: HTML Output - Help !!! Hi, I have an sqr program which produces an SPF file as output. Now we have to provide a HTML output and also split the files for each department. * I am using the new-report feature for splitting the files for each department. This is working, but the extension for the file names are lost. Only one file has the extension .htm. I am using the -Printer:HT in the SQR Flags. It is also automatically generating the TOC. How do I suppress this? * What is the simplest way to do generate a HTML output from the existing sqr ? [The SQR guide mentions a command line that is supposed to convert SPF files to HTML output, which is not working; So is the "Save As" command within the SQR Viewer - no clue as to where the HTML output goes]. I am receiving html output, but the output is not similar to what we receive in the SPF files. For instance, we have condensed output and I am not able to get this. I do get the smallest font, but when I print this, the right most columns are dropped. Any idea how I can solve this problem? Is there any setting in the .ini file that I need to take care of? If anyone has a sample sqr, it would help me very much. Any help in this matter would be appreciated very much. Thanks in advance. LKR. _____ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 5 15:08:02 2000 Date: Wed, 5 Jul 2000 18:50:42 GMT From: Ragu Sadasivam Subject: Re: HTML Output - Help !!! Sorry about that - Here it is... Hi, I have an sqr program which produces an SPF file as output. Now we have to provide a HTML output and also split the files for each department. * I am using the new-report feature for splitting the files for each department. This is working, but the extension for the file names are lost. Only one file has the extension .htm. I am using the -Printer:HT in the SQR Flags. It is also automatically generating the TOC. How do I suppress this? * What is the simplest way to do generate a HTML output from the existing sqr ? [The SQR guide mentions a command line that is supposed to convert SPF files to HTML output, which is not working; So is the "Save As" command within the SQR Viewer - no clue as to where the HTML output goes]. I am receiving html output, but the output is not similar to what we receive in the SPF files. For instance, we have condensed output and I am not able to get this. I do get the smallest font, but when I print this, the right most columns are dropped. Any idea how I can solve this problem? Is there any setting in the .ini file that I need to take care of? If anyone has a sample sqr, it would help me very much. Any help in this matter would be appreciated very much. Thanks in advance. LKR. >From: Peter Clark >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: HTML Output - Help !!! >Date: Wed, 5 Jul 2000 15:04:39 -0300 > >Ragu, > >The probability of receiving an answer to your question would be greatly >enhanced if you would use text format for those of us whose office email >systems do not support html format e-mail. > >Peter > >Of course, those of us without html support in our corporate email software >would likely have little to contribute on a question about html :-) > > >>> Ragu Sadasivam 2000/07/05 2:34:49 pm >>> >wrote: > >[indecipherable - non text format] ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 5 15:32:51 2000 Date: Wed, 5 Jul 2000 19:16:30 GMT From: Ragu Sadasivam Subject: Re: HTML Output - Help !!! Thanks for the suggestion - I tried using -Printer:EH without any luck. It does not generate any HTML output. It was working one day and now does not. I enclosed the -Printer:EH within tick marks. When I bring it up in Process Monitor, the flag does not even show up. Any guesses??? >From: Michael Phillips >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: HTML Output - Help !!! >Date: Wed, 5 Jul 2000 14:09:37 -0400 > >I did something like this > >let $FileName2 = 'c:\temp\File1.htm' > >NEW-REPORT $FileName1 > >...Processing to create the report... > >NEW-REPORT "temp.htm" !This will close the current report. Don't >worry, >it you never write to this report, then it won't be saved > >Then I delete the frame file that is automatically created because I had no >need for it. The report has to be closed first. > >let $FrameFileName = 'c:\temp\file1_frm.htm' >let #DelStatus = delete($FrameFileName) > >I would loop through this process until I have no more reports to create. > >In the process scheduler, I set this up to run on the client. It would not >run on the server; the job would finish with no errors, but no output would >be created. I also used -PRINTER:EH instead of -PRINTER:HT as the flag. > > > > >-----Original Message----- >From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] >Sent: Wednesday, July 05, 2000 1:35 PM >To: SQR-USERS@list.iex.net >Subject: Re: HTML Output - Help !!! > > > > > >Hi, > >I have an sqr program which produces an SPF file as output. Now we have to >provide a HTML output and also split the files for each department. > >* I am using the new-report feature for splitting the files for each >department. This is working, but the extension for the file names are >lost. >Only one file has the extension .htm. I am using the -Printer:HT in the >SQR >Flags. It is also automatically generating the TOC. How do I suppress >this? > >* What is the simplest way to do generate a HTML output from the >existing sqr ? [The SQR guide mentions a command line that is supposed to >convert SPF files to HTML output, which is not working; So is the "Save >As" >command within the SQR Viewer - no clue as to where the HTML output goes]. >I am receiving html output, but the output is not similar to what we >receive >in the SPF files. For instance, we have condensed output and I am not able >to get this. I do get the smallest font, but when I print this, the right >most columns are dropped. Any idea how I can solve this problem? Is there >any setting in the .ini file that I need to take care of? If anyone has a >sample sqr, it would help me very much. > >Any help in this matter would be appreciated very much. > >Thanks in advance. > >LKR. > > > > > > _____ > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 5 15:47:17 2000 Date: Wed, 5 Jul 2000 15:31:21 -0400 From: Michael Phillips Subject: Re: HTML Output - Help !!! Make sure the run location is the client and, in the overrides section, '-PRINTER:EH' is appended to the SQR Flags. -----Original Message----- From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] Sent: Wednesday, July 05, 2000 3:17 PM To: SQR-USERS@list.iex.net Subject: Re: HTML Output - Help !!! Thanks for the suggestion - I tried using -Printer:EH without any luck. It does not generate any HTML output. It was working one day and now does not. I enclosed the -Printer:EH within tick marks. When I bring it up in Process Monitor, the flag does not even show up. Any guesses??? >From: Michael Phillips >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: HTML Output - Help !!! >Date: Wed, 5 Jul 2000 14:09:37 -0400 > >I did something like this > >let $FileName2 = 'c:\temp\File1.htm' > >NEW-REPORT $FileName1 > >...Processing to create the report... > >NEW-REPORT "temp.htm" !This will close the current report. Don't >worry, >it you never write to this report, then it won't be saved > >Then I delete the frame file that is automatically created because I had no >need for it. The report has to be closed first. > >let $FrameFileName = 'c:\temp\file1_frm.htm' >let #DelStatus = delete($FrameFileName) > >I would loop through this process until I have no more reports to create. > >In the process scheduler, I set this up to run on the client. It would not >run on the server; the job would finish with no errors, but no output would >be created. I also used -PRINTER:EH instead of -PRINTER:HT as the flag. > > > > >-----Original Message----- >From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] >Sent: Wednesday, July 05, 2000 1:35 PM >To: SQR-USERS@list.iex.net >Subject: Re: HTML Output - Help !!! > > > > > >Hi, > >I have an sqr program which produces an SPF file as output. Now we have to >provide a HTML output and also split the files for each department. > >* I am using the new-report feature for splitting the files for each >department. This is working, but the extension for the file names are >lost. >Only one file has the extension .htm. I am using the -Printer:HT in the >SQR >Flags. It is also automatically generating the TOC. How do I suppress >this? > >* What is the simplest way to do generate a HTML output from the >existing sqr ? [The SQR guide mentions a command line that is supposed to >convert SPF files to HTML output, which is not working; So is the "Save >As" >command within the SQR Viewer - no clue as to where the HTML output goes]. >I am receiving html output, but the output is not similar to what we >receive >in the SPF files. For instance, we have condensed output and I am not able >to get this. I do get the smallest font, but when I print this, the right >most columns are dropped. Any idea how I can solve this problem? Is there >any setting in the .ini file that I need to take care of? If anyone has a >sample sqr, it would help me very much. > >Any help in this matter would be appreciated very much. > >Thanks in advance. > >LKR. > > > > > > _____ > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Thu Jul 6 09:52:11 2000 Date: Thu, 6 Jul 2000 13:39:12 GMT From: Ragu Sadasivam Subject: Re: HTML Output - Help !!! Hi - It is not working!!! We are on SQR version 4.3.4 and PeopleSoft 7.02 [Appl.version]. I saw one of your earlier emails about enclosing the printer:EH within tick marks, and I haven't had any luck!! I do have the -ZIV and -keep which generates the SPF files also. Do you think this could be the reason, why it is not working? And we always run our sqr's on the client. Thanks for your input!! LKR >From: Michael Phillips >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: HTML Output - Help !!! >Date: Wed, 5 Jul 2000 15:31:21 -0400 > >Make sure the run location is the client and, in the overrides section, >'-PRINTER:EH' is appended to the SQR Flags. > >-----Original Message----- >From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] >Sent: Wednesday, July 05, 2000 3:17 PM >To: SQR-USERS@list.iex.net >Subject: Re: HTML Output - Help !!! > > >Thanks for the suggestion - > >I tried using -Printer:EH without any luck. It does not generate any HTML >output. It was working one day and now does not. I enclosed the >-Printer:EH within tick marks. When I bring it up in Process Monitor, the >flag does not even show up. > >Any guesses??? > > > >From: Michael Phillips > >Reply-To: sqr-users@list.iex.net > >To: SQR-USERS@list.iex.net > >Subject: Re: HTML Output - Help !!! > >Date: Wed, 5 Jul 2000 14:09:37 -0400 > > > >I did something like this > > > >let $FileName2 = 'c:\temp\File1.htm' > > > >NEW-REPORT $FileName1 > > > >...Processing to create the report... > > > >NEW-REPORT "temp.htm" !This will close the current report. Don't > >worry, > >it you never write to this report, then it won't be saved > > > >Then I delete the frame file that is automatically created because I had >no > >need for it. The report has to be closed first. > > > >let $FrameFileName = 'c:\temp\file1_frm.htm' > >let #DelStatus = delete($FrameFileName) > > > >I would loop through this process until I have no more reports to create. > > > >In the process scheduler, I set this up to run on the client. It would >not > >run on the server; the job would finish with no errors, but no output >would > >be created. I also used -PRINTER:EH instead of -PRINTER:HT as the flag. > > > > > > > > > >-----Original Message----- > >From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] > >Sent: Wednesday, July 05, 2000 1:35 PM > >To: SQR-USERS@list.iex.net > >Subject: Re: HTML Output - Help !!! > > > > > > > > > > > >Hi, > > > >I have an sqr program which produces an SPF file as output. Now we have >to > >provide a HTML output and also split the files for each department. > > > >* I am using the new-report feature for splitting the files for >each > >department. This is working, but the extension for the file names are > >lost. > >Only one file has the extension .htm. I am using the -Printer:HT in the > >SQR > >Flags. It is also automatically generating the TOC. How do I suppress > >this? > > > >* What is the simplest way to do generate a HTML output from the > >existing sqr ? [The SQR guide mentions a command line that is supposed to > >convert SPF files to HTML output, which is not working; So is the "Save > >As" > >command within the SQR Viewer - no clue as to where the HTML output >goes]. > >I am receiving html output, but the output is not similar to what we > >receive > >in the SPF files. For instance, we have condensed output and I am not >able > >to get this. I do get the smallest font, but when I print this, the >right > >most columns are dropped. Any idea how I can solve this problem? Is >there > >any setting in the .ini file that I need to take care of? If anyone has >a > >sample sqr, it would help me very much. > > > >Any help in this matter would be appreciated very much. > > > >Thanks in advance. > > > >LKR. > > > > > > > > > > > > _____ > > > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 5 17:57:50 2000 Date: Wed, 5 Jul 2000 18:35:08 -0300 From: "Ronaldo Delmar M. Fernandes" Subject: Help !! I dont understanding on break in my report. look the follow code. Begin-Program Begin-Select codgrupo codproduto produto print &codgrupo (,10) On-Break procedure = q_grupo print &codproduto (,15) print &produto (,28) next-listing >From produtos where coddepartamento = 1 and codsecao = 8 and codclasse = 168 order by codgrupo End-Select End-Program begin-procedure q_grupo print 'Grupo' (+1,1) end-procedure and look the result 1 189 cerveja tipo1 502 cerveja brahma 924 cerveja skol 1223 cerveja polar grupo 5 242105 cerveja nortenha 6423 cerveja itaipava grupo 10 131484 cerveja kroneibier 2368 cerveja tipo 2 4525 cerveja tipo 3 1568 cerveja tipo 99 why in the first time the string grupo not printed if &codgrupo printed ? From owner-sqr-users@list.iex.net Wed Jul 5 18:06:10 2000 Date: Wed, 5 Jul 2000 16:56:49 -0500 From: Kathy Anderson Subject: Re: Help !! I dont understanding on break in my report. The "procedure" option with On-break is like an "After" option (I think). The procedure will only kick off after the value changes. Maybe you should try the "before" option instead. Begin-Program Begin-Select codgrupo codproduto produto print &codgrupo (,10) On-Break before =q_grupo print &codproduto (,15) print &produto (,28) next-listing From produtos where coddepartamento = 1 and codsecao = 8 and codclasse = 168 order by codgrupo End-Select End-Program > -----Original Message----- > From: Ronaldo Delmar M. Fernandes [SMTP:ronaldo@ZAFFARI.COM.BR] > Sent: 5 July 2000 4:35 PM > To: SQR-USERS@list.iex.net > Subject: Help !! I dont understanding on break in my report. > > look the follow code. > > Begin-Program > Begin-Select > codgrupo > codproduto > produto > print &codgrupo (,10) On-Break procedure > = > q_grupo > print &codproduto (,15) > print &produto (,28) > > next-listing > > From produtos > where coddepartamento = 1 > and codsecao = 8 > and codclasse = 168 > order by codgrupo > End-Select > End-Program > > begin-procedure q_grupo > print 'Grupo' (+1,1) > end-procedure > > and look the result > > 1 189 cerveja tipo1 > 502 cerveja brahma > 924 cerveja skol > 1223 cerveja polar > > grupo 5 242105 cerveja nortenha > 6423 cerveja itaipava > > grupo 10 131484 cerveja kroneibier > 2368 cerveja tipo 2 > 4525 cerveja tipo 3 > 1568 cerveja tipo 99 > > > why in the first time the string grupo not printed if &codgrupo printed ? From owner-sqr-users@list.iex.net Wed Jul 5 18:12:29 2000 Date: Wed, 5 Jul 2000 17:58:10 -0400 From: "Risman, Mark" Subject: Re: Help !! I dont understanding on break in my report. Ronaldo, Instead of using "procedure=...", consider using "before=". The procedure you designate with "before=" should execute once at the beginning of your query. - Mark -----Original Message----- From: Ronaldo Delmar M. Fernandes [mailto:ronaldo@ZAFFARI.COM.BR] Sent: Wednesday, July 05, 2000 5:35 PM To: SQR-USERS@list.iex.net Subject: Help !! I dont understanding on break in my report. look the follow code. Begin-Program Begin-Select codgrupo codproduto produto print &codgrupo (,10) On-Break procedure = q_grupo print &codproduto (,15) print &produto (,28) next-listing From produtos where coddepartamento = 1 and codsecao = 8 and codclasse = 168 order by codgrupo End-Select End-Program begin-procedure q_grupo print 'Grupo' (+1,1) end-procedure and look the result 1 189 cerveja tipo1 502 cerveja brahma 924 cerveja skol 1223 cerveja polar grupo 5 242105 cerveja nortenha 6423 cerveja itaipava grupo 10 131484 cerveja kroneibier 2368 cerveja tipo 2 4525 cerveja tipo 3 1568 cerveja tipo 99 why in the first time the string grupo not printed if &codgrupo printed ? From owner-sqr-users@list.iex.net Wed Jul 5 18:29:59 2000 Date: Wed, 5 Jul 2000 17:07:25 -0500 From: "Aguirre, Jose' A" Subject: Re: Help !! I dont understanding on break in my report. Ronaldo, Kathy is correct, if you have a procedure to call or it has been declared, it will be invoked. An after or before will work in order to invoke either after or before the value changes. José A. Aguirre -----Original Message----- From: Kathy Anderson [mailto:AndersoK@ROTARYINTL.ORG] Sent: Wednesday, July 05, 2000 4:57 PM To: SQR-USERS@LIST.IEX.NET Subject: Re: Help !! I dont understanding on break in my report. The "procedure" option with On-break is like an "After" option (I think). The procedure will only kick off after the value changes. Maybe you should try the "before" option instead. Begin-Program Begin-Select codgrupo codproduto produto print &codgrupo (,10) On-Break before =q_grupo print &codproduto (,15) print &produto (,28) next-listing From produtos where coddepartamento = 1 and codsecao = 8 and codclasse = 168 order by codgrupo End-Select End-Program > -----Original Message----- > From: Ronaldo Delmar M. Fernandes [SMTP:ronaldo@ZAFFARI.COM.BR] > Sent: 5 July 2000 4:35 PM > To: SQR-USERS@list.iex.net > Subject: Help !! I dont understanding on break in my report. > > look the follow code. > > Begin-Program > Begin-Select > codgrupo > codproduto > produto > print &codgrupo (,10) On-Break procedure > = > q_grupo > print &codproduto (,15) > print &produto (,28) > > next-listing > > From produtos > where coddepartamento = 1 > and codsecao = 8 > and codclasse = 168 > order by codgrupo > End-Select > End-Program > > begin-procedure q_grupo > print 'Grupo' (+1,1) > end-procedure > > and look the result > > 1 189 cerveja tipo1 > 502 cerveja brahma > 924 cerveja skol > 1223 cerveja polar > > grupo 5 242105 cerveja nortenha > 6423 cerveja itaipava > > grupo 10 131484 cerveja kroneibier > 2368 cerveja tipo 2 > 4525 cerveja tipo 3 > 1568 cerveja tipo 99 > > > why in the first time the string grupo not printed if &codgrupo printed ? From owner-sqr-users@list.iex.net Wed Jul 5 18:21:25 2000 Date: Wed, 5 Jul 2000 18:08:47 -0400 From: John Milardovic Subject: Re: Help !! I dont understanding on break in my report. Use: Begin-Program Begin-Select codgrupo () on-break print=never before=q_grupo codproduto (,15) produto (,28) position (+1) >From produtos where coddepartamento = 1 and codsecao = 8 and codclasse = 168 order by codgrupo End-Select End-Program begin-procedure q_grupo print 'Grupo' (+1,1) print &codgrupo (,10) end-procedure > -----Original Message----- > From: Ronaldo Delmar M. Fernandes [SMTP:ronaldo@ZAFFARI.COM.BR] > Sent: Wednesday, July 05, 2000 5:35 PM > To: SQR-USERS@list.iex.net > Subject: Help !! I dont understanding on break in my report. > > look the follow code. > > Begin-Program > Begin-Select > codgrupo > codproduto > produto > print &codgrupo (,10) On-Break procedure > = > q_grupo > print &codproduto (,15) > print &produto (,28) > > next-listing > > From produtos > where coddepartamento = 1 > and codsecao = 8 > and codclasse = 168 > order by codgrupo > End-Select > End-Program > > begin-procedure q_grupo > print 'Grupo' (+1,1) > end-procedure > > and look the result > > 1 189 cerveja tipo1 > 502 cerveja brahma > 924 cerveja skol > 1223 cerveja polar > > grupo 5 242105 cerveja nortenha > 6423 cerveja itaipava > > grupo 10 131484 cerveja kroneibier > 2368 cerveja tipo 2 > 4525 cerveja tipo 3 > 1568 cerveja tipo 99 > > > why in the first time the string grupo not printed if &codgrupo printed ? From owner-sqr-users@list.iex.net Wed Jul 5 18:21:41 2000 Date: Wed, 5 Jul 2000 17:15:01 -0500 From: "Arosemena, Efrain" Subject: Re: Help !! I dont understanding on break in my report. Buenas Ronaldo, prueba con before=q_grupo -----Mensaje original----- De: Ronaldo Delmar M. Fernandes [mailto:ronaldo@ZAFFARI.COM.BR] Enviado el: Wednesday, July 05, 2000 4:35 PM Para: SQR-USERS@list.iex.net Asunto: Help !! I dont understanding on break in my report. look the follow code. Begin-Program Begin-Select codgrupo codproduto produto print &codgrupo (,10) On-Break procedure = q_grupo print &codproduto (,15) print &produto (,28) next-listing >From produtos where coddepartamento = 1 and codsecao = 8 and codclasse = 168 order by codgrupo End-Select End-Program begin-procedure q_grupo print 'Grupo' (+1,1) end-procedure and look the result 1 189 cerveja tipo1 502 cerveja brahma 924 cerveja skol 1223 cerveja polar grupo 5 242105 cerveja nortenha 6423 cerveja itaipava grupo 10 131484 cerveja kroneibier 2368 cerveja tipo 2 4525 cerveja tipo 3 1568 cerveja tipo 99 why in the first time the string grupo not printed if &codgrupo printed ? From owner-sqr-users@list.iex.net Wed Jul 5 18:40:51 2000 Date: Wed, 5 Jul 2000 15:26:46 -0700 From: Dave Thorburn Subject: Re: Help !! I dont understanding on break in my report. Kathy's answer is correct. Use the 'Before' procedure to print group headings. This way you will have a group heading for each group encountered during the run instead of only when the group has changed. The Manning Press book SQR FOR PEOPLESOFT AND OTHER APPLICATIONS has a nice example of this logic. Regards, Dave ---------------------------------------------------------- >--- Original Message --- >From: Kathy Anderson >To: SQR-USERS@list.iex.net >Date: 7/5/00 9:56:49 PM > >The "procedure" option with On-break is like an "After" option (I think). >The procedure will only kick off after the value changes. Maybe you should >try the "before" option instead. > > Begin-Program > Begin-Select > codgrupo > codproduto > produto > print &codgrupo (,10) On-Break >before =q_grupo > print &codproduto (,15) > print &produto (,28) > > next-listing > > From produtos > where coddepartamento = 1 > and codsecao = 8 > and codclasse = 168 > order by codgrupo > End-Select > End-Program > > > >> -----Original Message----- >> From: Ronaldo Delmar M. Fernandes [SMTP:ronaldo@ZAFFARI.COM.BR] >> Sent: 5 July 2000 4:35 PM >> To: SQR-USERS@list.iex.net >> Subject: Help !! I dont understanding on break in my report. >> >> look the follow code. >> >> Begin-Program >> Begin-Select >> codgrupo >> codproduto >> produto >> print &codgrupo (,10) On-Break procedure >> = >> q_grupo >> print &codproduto (,15) >> print &produto (,28) >> >> next-listing >> >> From produtos >> where coddepartamento = 1 >> and codsecao = 8 >> and codclasse = 168 >> order by codgrupo >> End-Select >> End-Program >> >> begin-procedure q_grupo >> print 'Grupo' (+1,1) >> end-procedure >> >> and look the result >> >> 1 189 cerveja tipo1 >> 502 cerveja brahma >> 924 cerveja skol >> 1223 cerveja polar >> >> grupo 5 242105 cerveja nortenha >> 6423 cerveja itaipava >> >> grupo 10 131484 cerveja kroneibier >> 2368 cerveja tipo 2 >> 4525 cerveja tipo 3 >> 1568 cerveja tipo 99 >> >> >> why in the first time the string grupo not printed if &codgrupo printed ? > > ---------------- Sent from a WebBox - http://www.webbox.com FREE Web based Email, Files, Bookmarks, Calendar, People and Great Ways to Share them with Others! From owner-sqr-users@list.iex.net Wed Jul 5 18:20:32 2000 Date: Wed, 5 Jul 2000 18:03:14 -0400 From: "Risman, Mark" Subject: Re: Headings question??? All, Haven't seen a solution to this problem posted yet. I'd like to throw my issue into the ring. I have a batch of SQR reports that I run nightly, and every report seems to always skip one line between the report heading and the report body, but only on every page AFTER the first page. Has anyone else seen this happen? I have tried adjusting both the page width and page length, but this didn't seem to help. I am using SQR V4.0.2 under Solaris (SunOS 5.6), and printing to PostScript printer type and then distilling to PDF. - Mark -----Original Message----- From: Matt Matthiessen [mailto:mmatthiessen@ASSISTED.COM] Sent: Wednesday, April 26, 2000 5:58 PM To: SQR-USERS@list.iex.net Subject: Re: Headings question??? Here's a bit more on my problem: Example: Here is my page one: Line 1: Heading info Line 2: Heading info Line 3: Heading info Line 4: Heading info Line 5: Heading info Line 6: Heading info Line 7: Heading info Line 8: Heading info Line 9: Heading info Line 10: blank line Line 11: ??? Line 12: ??? Line 13: ??? Line 14: ??? Line 15: My first "non-heading" print statement ( example: print &itemnum (, 1) ) Here is my page2(or higher): Line 1: Heading info Line 2: Heading info Line 3: Heading info Line 4: Heading info Line 5: Heading info Line 6: Heading info Line 7: Heading info Line 8: Heading info Line 9: Heading info Line 10: blank line Line 11: My first "non-heading" print statement ( example: print &itemnum (, 1) ) My question is why do I have blank lines after my heading is done and the data starts, on ONLY my first page... Thanks for your help... Matt Matt Matthiessen Programmer Analyst Alterra HealthCare Voice: 414-918-5677 Email: mmatthiessen@assisted.com -----Original Message----- From: Love, Kristin [SMTP:KLove@MSA.COM] Sent: Wednesday, April 26, 2000 3:49 PM To: SQR-USERS@list.iex.net Subject: Re: Headings question??? I think I've been bitten by this in the past... If you try to print past the page length, SQR will break the page on its own but not redo the headings. We always have to check if the current line > page length. (If I understand what you're asking) :) Kristin > -----Original Message----- > From: Matt Matthiessen [SMTP:mmatthiessen@ASSISTED.COM] > Sent: Wednesday, April 26, 2000 3:55 PM > To: SQR-USERS@list.iex.net > Subject: Headings question??? > > I have an SQR generating one report. I have a "begin-heading 10" block of > code within my SQR. My question is why is it that these "reserved 10 > lines" > only are so on pages 2 or higher within my report. Page one actually > starts > my first "non-heading" print statement on line 15. But, then, pages 2 and > higher actually conform to the 10 line heading. I made sure that there > are > no specific "print $whatevers (+1,1)" or any other line increased prints > tied to just the first page. It seems to be just how SQR is formatting > that > first page. Please help...thanks... > > SQR Matt From owner-sqr-users@list.iex.net Wed Jul 5 19:11:28 2000 Date: Wed, 5 Jul 2000 19:51:23 -0300 From: Davi Cabral Subject: RES: Help !! I dont understanding on break in my report. For what a On-Break and a Procedure to a so simple query? Try a group by and simply write "Grupo" beside &codgrupo: Return me what happens. By the way, what SQR version are you using? Do you write the code manually or you have a graphic interface? Davi Begin-Program Begin-Select codgrupo codproduto produto print 'Grupo' (+1,1) print &codgrupo (,10) print &codproduto (,15) print &produto (,28) next-listing From produtos where coddepartamento = 1 and codsecao = 8 and codclasse = 168 group by codgrupo order by codgrupo End-Select End-Program ----- Mensagem original ----- De: Ronaldo Delmar M. Fernandes [SMTP:ronaldo@ZAFFARI.COM.BR] Enviada em: quarta-feira, 5 de julho de 2000 18:35 Para: SQR-USERS@list.iex.net Assunto: Help !! I dont understanding on break in my report. look the follow code. Begin-Program Begin-Select codgrupo codproduto produto print &codgrupo (,10) On-Break procedure = q_grupo print &codproduto (,15) print &produto (,28) next-listing >From produtos where coddepartamento = 1 and codsecao = 8 and codclasse = 168 order by codgrupo End-Select End-Program begin-procedure q_grupo print 'Grupo' (+1,1) end-procedure and look the result 1 189 cerveja tipo1 502 cerveja brahma 924 cerveja skol 1223 cerveja polar grupo 5 242105 cerveja nortenha 6423 cerveja itaipava grupo 10 131484 cerveja kroneibier 2368 cerveja tipo 2 4525 cerveja tipo 3 1568 cerveja tipo 99 why in the first time the string grupo not printed if &codgrupo printed ? From owner-sqr-users@list.iex.net Thu Jul 6 09:51:20 2000 Date: Thu, 6 Jul 2000 10:32:44 -0300 From: "Ronaldo Delmar M. Fernandes" Subject: RES: Help !! I dont understanding on break in my report. The example just is to understand because procedure doesn't execute on first time. > ----- Mensagem original ----- > De: Davi Cabral [SMTP:dcabral@RECSA.COM.BR] > Enviada em: Quarta-feira, 5 de Julho de 2000 19:51 > Para: SQR-USERS@list.iex.net > Assunto: RES: Help !! I dont understanding on break in my > report. > > For what a On-Break and a Procedure to a so simple query? Try a group by > and simply write "Grupo" beside &codgrupo: > Return me what happens. > By the way, what SQR version are you using? Do you write the code manually > or you have a graphic interface? > > Davi > > Begin-Program > Begin-Select > codgrupo > codproduto > produto > print 'Grupo' (+1,1) > print &codgrupo (,10) > print &codproduto (,15) > print &produto (,28) > next-listing > From produtos > where coddepartamento = 1 > and codsecao = 8 > and codclasse = 168 > group by codgrupo > order by codgrupo > End-Select > End-Program > > > > > ----- Mensagem original ----- > De: Ronaldo Delmar M. Fernandes [SMTP:ronaldo@ZAFFARI.COM.BR] > Enviada em: quarta-feira, 5 de julho de 2000 18:35 > Para: SQR-USERS@list.iex.net > Assunto: Help !! I dont understanding on break in my > report. > > look the follow code. > > Begin-Program > Begin-Select > codgrupo > codproduto > produto > print &codgrupo (,10) On-Break procedure > = > q_grupo > print &codproduto (,15) > print &produto (,28) > > next-listing > > From produtos > where coddepartamento = 1 > and codsecao = 8 > and codclasse = 168 > order by codgrupo > End-Select > End-Program > > begin-procedure q_grupo > print 'Grupo' (+1,1) > end-procedure > > and look the result > > 1 189 cerveja tipo1 > 502 cerveja brahma > 924 cerveja skol > 1223 cerveja polar > > grupo 5 242105 cerveja nortenha > 6423 cerveja itaipava > > grupo 10 131484 cerveja kroneibier > 2368 cerveja tipo 2 > 4525 cerveja tipo 3 > 1568 cerveja tipo 99 > > > why in the first time the string grupo not printed if &codgrupo printed ? From owner-sqr-users@list.iex.net Thu Jul 6 14:05:39 2000 Date: Thu, 6 Jul 2000 10:48:52 -0700 From: Dave Thorburn Subject: SQR and MVS - Communicating with Op. System All, I have a problem with SQR and MVS JCL. The output dataset from the SQR has been defined in the JCL and works perfectly. The Problem is that when the SQR creates no output records I am left with an empty dataset cataloged on MVS. Is there a way to pass information from the SQR to MVS that could be used to trigger a subsequent Job Step to delete the dataset -or- Can someone suggest a way to resolve this situation without writing a COBOL program to check for a null dataset? How about MVS Utilities - Has any one used any of the 'IEB' or 'IEH' utilities to determine if a dataset is empty? Thanks, Dave ---------------- Sent from a WebBox - http://www.webbox.com FREE Web based Email, Files, Bookmarks, Calendar, People and Great Ways to Share them with Others! From owner-sqr-users@list.iex.net Thu Jul 6 14:30:06 2000 Date: Thu, 6 Jul 2000 14:16:30 -0400 From: "Joshi, Pradeep" Subject: Re: SQR and MVS - Communicating with Op. System You can use SQR reserved variable #return-status to pass info to operating system.. You can set the value of #return-status in your SQR and check that value in your O/S script. I hope this helps to solve your problem. Thanks, Pradeep > -----Original Message----- > From: Dave Thorburn [SMTP:thorburn@CONL.NET] > Sent: Thursday, July 06, 2000 1:49 PM > To: SQR-USERS@list.iex.net > Subject: SQR and MVS - Communicating with Op. System > > All, > > I have a problem with SQR and MVS JCL. The output dataset > from the SQR has been defined in the JCL and works perfectly. > > The Problem is that when the SQR creates no output records > I am left with an empty dataset cataloged on MVS. > > Is there a way to pass information from the SQR to MVS that > could be used to trigger a subsequent Job Step to delete the > dataset -or- > > Can someone suggest a way to resolve this situation without > writing a COBOL program to check for a null dataset? > > How about MVS Utilities - Has any one used any of the 'IEB' > or 'IEH' utilities to determine if a dataset is empty? > > Thanks, > > Dave > > > ---------------- > Sent from a WebBox - http://www.webbox.com > FREE Web based Email, Files, Bookmarks, Calendar, People and > Great Ways to Share them with Others! From owner-sqr-users@list.iex.net Fri Jul 7 15:11:03 2000 Date: Fri, 7 Jul 2000 14:56:10 -0400 From: Steve Schelske Subject: Re: SQR and MVS - Communicating with Op. System If you have access to FileAid, it gives a return code 8 if the input (DD01) file is empty. A subsequent job step could then run to delete the output dataset if the FileAid job returns 8. Just out of curiosity, is there a pressing reason that you need to delete these datasets? -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Dave Thorburn Sent: Thursday, July 06, 2000 1:49 PM To: SQR-USERS@list.iex.net Subject: SQR and MVS - Communicating with Op. System All, I have a problem with SQR and MVS JCL. The output dataset from the SQR has been defined in the JCL and works perfectly. The Problem is that when the SQR creates no output records I am left with an empty dataset cataloged on MVS. Is there a way to pass information from the SQR to MVS that could be used to trigger a subsequent Job Step to delete the dataset -or- Can someone suggest a way to resolve this situation without writing a COBOL program to check for a null dataset? How about MVS Utilities - Has any one used any of the 'IEB' or 'IEH' utilities to determine if a dataset is empty? Thanks, Dave ---------------- Sent from a WebBox - http://www.webbox.com FREE Web based Email, Files, Bookmarks, Calendar, People and Great Ways to Share them with Others! From owner-sqr-users@list.iex.net Fri Jul 7 15:21:29 2000 Date: Fri, 7 Jul 2000 15:08:49 -0400 From: Jerry Coleman Subject: Re: SQR and MVS - Communicating with Op. System Pasted from the SQR Manual: #return-status - Value to be returned to the operating system when SQR exits. May be set in your report. #return-status is initialized to the "success" return value for the operating system. Steve Schelske cc: Sent by: Subject: Re: SQR and MVS - Communicating with Op. System "Discussion of SQR, Brio Technology's database reporting language" 07/07/00 02:56 PM Please respond to sqr-users If you have access to FileAid, it gives a return code 8 if the input (DD01) file is empty. A subsequent job step could then run to delete the output dataset if the FileAid job returns 8. Just out of curiosity, is there a pressing reason that you need to delete these datasets? -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Dave Thorburn Sent: Thursday, July 06, 2000 1:49 PM To: SQR-USERS@list.iex.net Subject: SQR and MVS - Communicating with Op. System All, I have a problem with SQR and MVS JCL. The output dataset from the SQR has been defined in the JCL and works perfectly. The Problem is that when the SQR creates no output records I am left with an empty dataset cataloged on MVS. Is there a way to pass information from the SQR to MVS that could be used to trigger a subsequent Job Step to delete the dataset -or- Can someone suggest a way to resolve this situation without writing a COBOL program to check for a null dataset? How about MVS Utilities - Has any one used any of the 'IEB' or 'IEH' utilities to determine if a dataset is empty? Thanks, Dave ---------------- Sent from a WebBox - http://www.webbox.com FREE Web based Email, Files, Bookmarks, Calendar, People and Great Ways to Share them with Others! From owner-sqr-users@list.iex.net Thu Jul 6 16:56:26 2000 Date: Thu, 6 Jul 2000 16:45:08 -0400 From: Anne-Marie Matula Subject: Load-Lookup and return_values of long datatype Hi there SQR gurus and geeks, I was hoping to use LOAD-LOOKUP to return a value stored in a LONG datatype (field=comments). We are using Oracle 8.0.3 database last I checked. Unfortunately LOAD-LOOKUP selects the value using the distinct command which is illegal with LONG datatypes: ORA-00997: illegal use of LONG datatype SQL: select distinct Emplid, Comments from PS_PERSON_COMMENT umexgtrm1 where umexgtrm1.CMNT_CATEGORY='GSOL' and umexgtrm1.COMMENT_DTTM = (select MAX(COMMENT_DTTM) from PS_PERSON_COMMENT umexgtrm2 where umexgtrm1.EMPLID = umexgtrm2.EMPLID and umexgtrm2.CMNT_CATEGORY='GSOL') Error at: Comments My Load-Lookup command is: LET $where = 'umexgtrm1.CMNT_CATEGORY=''GSOL'' and '|| 'umexgtrm1.COMMENT_DTTM = (select MAX(COMMENT_DTTM) from PS_PERSON_COMMENT umexgtrm2 where '|| 'umexgtrm1.EMPLID = umexgtrm2.EMPLID and umexgtrm2.CMNT_CATEGORY=''GSOL'')' LOAD-LOOKUP Name=Um-SOL-Comments Table='PS_PERSON_COMMENT umexgtrm1' Key=Emplid Return_value=Comments where=$where ---------------- Does anyone have any suggestions on how to get what I want (the first 60 characters or so from the LONG field) using LOAD-LOOKUP? I guess I could link this query with my main one using an outer join but I wanted to see if I could get this to work first. Thanks! Have a good one, Anne-Marie PS: I get SQR-Users in digest format so if you could cc me in on any response I'd greatly appreciate it ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Anne-Marie Matula Student Information System Project Office of Information Technologies University of Massachusetts 161 Whitmore Administration Building Amherst Massachusetts, 01003-8165 Phone: 413/577-0685 Fax: 413/545-2150 From owner-sqr-users@list.iex.net Thu Jul 6 18:19:18 2000 Date: Thu, 6 Jul 2000 14:52:09 PDT From: Scott Hitchcock Subject: Re: Load-Lookup and return_values of long datatype Anne-Marie, You might try using the function below from Ken Atkins' Oracle tip page. Change the varchar2(2000) to varchar2(60) and substitute your columns/tables. I use it often...works great. Is also great for searching a long data type, first 2000 characters anyway, without the oracle context package. CREATE OR REPLACE FUNCTION comments (employee_id IN NUMBER) RETURN VARCHAR2 IS c_desc VARCHAR2(2000); c_Long LONG; BEGIN SELECT comments INTO c_Long FROM comment_table WHERE long_id = employee_id; v_Desc := substr(c_long,1,2000); RETURN(c_desc); END; Usage..... SELECT comments(emplid) FROM comment_table where.... >From: Anne-Marie Matula >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Load-Lookup and return_values of long datatype >Date: Thu, 6 Jul 2000 16:45:08 -0400 > >Hi there SQR gurus and geeks, > >I was hoping to use LOAD-LOOKUP to return a value stored in a LONG datatype >(field=comments). We are using Oracle 8.0.3 database last I checked. >Unfortunately LOAD-LOOKUP selects the value using the distinct command >which >is illegal with LONG datatypes: > >ORA-00997: illegal use of LONG datatype >SQL: select distinct Emplid, Comments from PS_PERSON_COMMENT umexgtrm1 >where > umexgtrm1.CMNT_CATEGORY='GSOL' and umexgtrm1.COMMENT_DTTM = (select > MAX(COMMENT_DTTM) from PS_PERSON_COMMENT umexgtrm2 where > umexgtrm1.EMPLID = umexgtrm2.EMPLID and >umexgtrm2.CMNT_CATEGORY='GSOL') >Error at: Comments > >My Load-Lookup command is: > >LET $where = 'umexgtrm1.CMNT_CATEGORY=''GSOL'' and '|| > 'umexgtrm1.COMMENT_DTTM = (select MAX(COMMENT_DTTM) from >PS_PERSON_COMMENT umexgtrm2 where '|| > 'umexgtrm1.EMPLID = umexgtrm2.EMPLID and >umexgtrm2.CMNT_CATEGORY=''GSOL'')' > >LOAD-LOOKUP > Name=Um-SOL-Comments > Table='PS_PERSON_COMMENT umexgtrm1' > Key=Emplid > Return_value=Comments > where=$where > >---------------- >Does anyone have any suggestions on how to get what I want (the first 60 >characters or so from the LONG field) using LOAD-LOOKUP? I guess I could >link this query with my main one using an outer join but I wanted to see if >I could get this to work first. > >Thanks! > >Have a good one, > >Anne-Marie > >PS: I get SQR-Users in digest format so if you could cc me in on any >response I'd greatly appreciate it > > > > > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Anne-Marie Matula >Student Information System Project >Office of Information Technologies >University of Massachusetts >161 Whitmore Administration Building >Amherst Massachusetts, 01003-8165 >Phone: 413/577-0685 >Fax: 413/545-2150 ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Fri Jul 7 17:49:31 2000 Date: Fri, 7 Jul 2000 15:38:27 -0600 From: Randy Kirkpatrick Subject: SQR 7501 Can anyone tell me why I'm getting this error and how I can fix it? (SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) Randy K. From owner-sqr-users@list.iex.net Fri Jul 7 19:32:26 2000 Date: Fri, 7 Jul 2000 17:51:53 -0400 From: "Risman, Mark" Subject: Re: SQR 7501 Randy, This is a warning, not an error. It means SQR thinks you might be trying to compare a two-digit year against a four-digit year. If these warnings are errant and come up frequently, you can disable this message by setting "OutputTwoDIgitYearWarningMsg" in your sqr.ini file to false. - Mark -----Original Message----- From: Randy Kirkpatrick [mailto:randyk@MESSAGEMEDIA.COM] Sent: Friday, July 07, 2000 5:38 PM To: SQR-USERS@list.iex.net Subject: SQR 7501 Can anyone tell me why I'm getting this error and how I can fix it? (SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) Randy K. From owner-sqr-users@list.iex.net Fri Jul 7 19:33:50 2000 Date: Fri, 7 Jul 2000 16:07:21 -0600 From: Randy Kirkpatrick Subject: Re: SQR 7501 Mark, I guess I should have asked why a strtodate function is returning a two digit year (DD-MM-YY). Randy -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Risman, Mark Sent: Friday, July 07, 2000 3:52 PM To: SQR-USERS@list.iex.net Subject: Re: SQR 7501 Randy, This is a warning, not an error. It means SQR thinks you might be trying to compare a two-digit year against a four-digit year. If these warnings are errant and come up frequently, you can disable this message by setting "OutputTwoDIgitYearWarningMsg" in your sqr.ini file to false. - Mark -----Original Message----- From: Randy Kirkpatrick [mailto:randyk@MESSAGEMEDIA.COM] Sent: Friday, July 07, 2000 5:38 PM To: SQR-USERS@list.iex.net Subject: SQR 7501 Can anyone tell me why I'm getting this error and how I can fix it? (SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) Randy K. From owner-sqr-users@list.iex.net Fri Jul 7 20:44:44 2000 Date: Fri, 7 Jul 2000 18:13:08 -0600 From: Jim Vanderpool Subject: Re: SQR 7501 Randy, It's likely your SQR.INI (or PSSQR.INI in Peoplesoft) is driving the two digit year format. We're on Oracle and have set up the following code in PSSQR.INI (actually, just modified what was delivered) to get around the problem: [Environment:Oracle] SQR_DB_DATE_FORMAT=MM-DD-YYYY That should fix it. Jim Vanderpool University of Colorado Administrative Streamlining Project At 04:07 PM 7/7/00 -0600, you wrote: >Mark, > >I guess I should have asked why a strtodate function is returning a two >digit year (DD-MM-YY). > >Randy > > > >-----Original Message----- >From: Discussion of SQR, Brio Technology's database reporting language >[mailto:SQR-USERS@list.iex.net]On Behalf Of Risman, Mark >Sent: Friday, July 07, 2000 3:52 PM >To: SQR-USERS@list.iex.net >Subject: Re: SQR 7501 > > >Randy, > >This is a warning, not an error. It means SQR thinks you might be trying to >compare a two-digit year against a four-digit year. If these warnings are >errant and come up frequently, you can disable this message by setting >"OutputTwoDIgitYearWarningMsg" in your sqr.ini file to false. > >- Mark > > > -----Original Message----- > From: Randy Kirkpatrick [mailto:randyk@MESSAGEMEDIA.COM] > Sent: Friday, July 07, 2000 5:38 PM > To: SQR-USERS@list.iex.net > Subject: SQR 7501 > > Can anyone tell me why I'm getting this error and how I can >fix it? > > (SQR 7501) Using YY edit mask from (DD-MON-YY) against >(2000) > > > Randy K. From owner-sqr-users@list.iex.net Fri Jul 7 20:09:09 2000 Date: Fri, 7 Jul 2000 17:18:20 -0500 From: Don Mellen Subject: Re: SQR 7501 On Fri, 7 Jul 2000, Randy Kirkpatrick wrote: > Can anyone tell me why I'm getting this error and how I can fix it? > (SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) Actually, it's a warning message (Y2K and all), not an error message. It can be disabled by setting "OutputTwoDigitYearWarningMsg=FALSE" in the [Default-Settings] section of your sqr.ini file. ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" From owner-sqr-users@list.iex.net Sat Jul 8 09:40:28 2000 Date: Sat, 8 Jul 2000 08:19:43 -0500 From: "Aguirre, Jose' A" Subject: Re: SQR 7501 Need to use YYYY. Thanks, José A. Aguirre -----Original Message----- From: Randy Kirkpatrick [mailto:randyk@MESSAGEMEDIA.COM] Sent: Friday, July 07, 2000 4:38 PM To: SQR-USERS@LIST.IEX.NET Subject: SQR 7501 Can anyone tell me why I'm getting this error and how I can fix it? (SQR 7501) Using YY edit mask from (DD-MON-YY) against (2000) Randy K. From owner-sqr-users@list.iex.net Thu Jul 6 20:17:38 2000 Date: Thu, 6 Jul 2000 17:09:31 -0700 From: Sayre John Subject: Scratch tables I am attempting to do a really complicated sales and inventory SQR on Informix. The sales table for a week is ~ 4.5 million rows. In order to ease the load on the box , I want to load "Scratch" tables. I'm just curious how SQR or informix deals with this. Does the table load into memory on the Unix box? Does it manipulate disk storage somehow? Are there any practical limitations as to the size? Thanks John Sayre From owner-sqr-users@list.iex.net Fri Jul 7 12:43:24 2000 Date: Fri, 7 Jul 2000 12:23:10 -0400 From: "Noonan, Marybeth" Subject: Process Scheduler ques else delete Hi, Environ: Oracle 8.05, Sqr 4.2.3,ptolls 7.54, psapps 7.52,2 tier,server unix I want to schedule 2 sqr programs to run automatically m-f at a designated time, there ae no control arguments that need to be entered. The first SQR selects rows from ()NON-PEOPLESOFT) Oracle Tables , the 2nd sqr inserts rows into a PSOFT Oracle table & must run after 1st prog. My question can we run an SQR within process scheduler that reads NON psoft tables followed by a 2nd prog that will use PSOFT tables? I just reread ptools process scheduler & am confused whether this is possible and/or difficult to setup? MaryBeth Noonan Financial Systems Ext. 57467 mnoonan@mfs.com From owner-sqr-users@list.iex.net Fri Jul 7 13:02:14 2000 Date: Fri, 7 Jul 2000 12:39:48 -0400 From: Pamela Lantzy Subject: Re: Process Scheduler ques else delete Yes you can, you must setup a process definition for the 1st SQR just like the 2nd SQR regardless of what database its running against. Then you can create a job definition that contains both process defintions. -----Original Message----- From: Noonan, Marybeth [mailto:MNoonan@MFS.COM] Sent: Friday, July 07, 2000 12:23 PM To: SQR-USERS@LIST.IEX.NET Subject: Process Scheduler ques else delete Hi, Environ: Oracle 8.05, Sqr 4.2.3,ptolls 7.54, psapps 7.52,2 tier,server unix I want to schedule 2 sqr programs to run automatically m-f at a designated time, there ae no control arguments that need to be entered. The first SQR selects rows from ()NON-PEOPLESOFT) Oracle Tables , the 2nd sqr inserts rows into a PSOFT Oracle table & must run after 1st prog. My question can we run an SQR within process scheduler that reads NON psoft tables followed by a 2nd prog that will use PSOFT tables? I just reread ptools process scheduler & am confused whether this is possible and/or difficult to setup? MaryBeth Noonan Financial Systems Ext. 57467 mnoonan@mfs.com From owner-sqr-users@list.iex.net Fri Jul 7 12:50:31 2000 Date: Fri, 7 Jul 2000 11:28:07 -0500 From: Robert Richley Subject: Printing from a Mac We are not having any success print SQR's from PeopleSoft on a Mac. Has anyone out there been able to do this? Thanks for your help. - Bob From owner-sqr-users@list.iex.net Fri Jul 7 13:02:14 2000 Date: Fri, 7 Jul 2000 12:51:16 -0400 From: Sam Spritzer Subject: Re: Printing from a Mac What exactly is the problem? Sam >>> rrichley@POPMAIL.COLUM.EDU 07/07 12:28 PM >>> We are not having any success print SQR's from PeopleSoft on a Mac. Has anyone out there been able to do this? Thanks for your help. - Bob From owner-sqr-users@list.iex.net Fri Jul 7 13:50:00 2000 Date: Fri, 7 Jul 2000 12:34:15 -0500 From: Robert Richley Subject: Re: Printing from a Mac The .lis file gets created but doesn't go to the printer. We don't know how to specify the printer in PeopleSoft so that the mac sends to a printer. On a PC we can specify LPT1 or a printer name on our server. - Bob Sam Spritzer wrote: > What exactly is the problem? > Sam > > >>> rrichley@POPMAIL.COLUM.EDU 07/07 12:28 PM >>> > We are not having any success print SQR's from PeopleSoft on a Mac. Has anyone out > there been able to do this? > > Thanks for your help. > > - Bob From owner-sqr-users@list.iex.net Fri Jul 7 12:55:18 2000 Date: Fri, 7 Jul 2000 09:38:42 -0700 From: Michael Prodor Subject: Error Message in SQR Hello SQRers. I am getting an error message in an SQR when I try to insert a char value into a table.

The table column that causes the problem is defined as Varchar2(47) and the data I am trying to place into it is a string.

Here is the error message:

(SQR 5528) ORACLE OEXEC error -1461 in cursor 3:
   ORA-01461: can bind a LONG value only for insert into a LONG column

Error on line 94:
   (SQR 3735) Could not execute SQL.


Here is the statement:

    94        begin-sql
    95        insert into qc_acc_cf values (
    96  !Add name and replace funky values  - MLP
    97  !               nvl($nmc_acct_id,0) ,NULL, nvl($nmc_srvc_provider,0),
    98                 nvl($nmc_acct_id,0),replace(replace(replace(rtrim($nmc_name),chr(9),''),chr(10),''),chr(13),''),
    99                 nvl($nmc_srvc_provider,0), $region, $state ,to_number(nvl($super_acct,0)) , $clean_yymm )
   100       end-sql
   101        show (10, 2 ) 'Record: ' #rec_count
   102            !--  nvl($nmc_name,' ')
   103    end-if


and  here is the data that causes the problem (obviously not a long):

SECURITY CONSULTANTS GRP1 (SYS4)

Finally, here is the statement where we assign a value to the variable (from a read buffer):

let $nmc_name = ltrim( rtrim( substr( $readbuf, 14,43),' '),' ')

The statement works fine when I insert NULL. Initially I was receiving the error and I thought it was due to embedded tabs / returns, so I am using  the REPLACE statement on the value.


Any help would be greatly appreciated.


--
Michael Prodor
<mprodor@qualcomm.com>

Qualcomm - QWBS Info Systems From owner-sqr-users@list.iex.net Fri Jul 7 13:23:07 2000 Date: Fri, 7 Jul 2000 12:50:44 -0400 From: Jerry Coleman Subject: Re: Error Message in SQR I wonder if there could be another binary value that's not being captured in your replace statements. Maybe isblank() would capture it. You might also inspect the data with an editor in hex mode. Michael Prodor cc: Sent by: Subject: Error Message in SQR "Discussion of SQR, Brio Technology's database reporting language" 07/07/00 12:38 PM Please respond to sqr-users Hello SQRers. I am getting an error message in an SQR when I try to insert a char value into a table. The table column that causes the problem is defined as Varchar2(47) and the data I am trying to place into it is a string. Here is the error message: (SQR 5528) ORACLE OEXEC error -1461 in cursor 3: ORA-01461: can bind a LONG value only for insert into a LONG column Error on line 94: (SQR 3735) Could not execute SQL. Here is the statement: 94 begin-sql 95 insert into qc_acc_cf values ( 96 !Add name and replace funky values - MLP 97 ! nvl($nmc_acct_id,0) ,NULL, nvl ($nmc_srvc_provider,0), 98 nvl($nmc_acct_id,0),replace(replace(replace(rtrim ($nmc_name),chr(9),''),chr(10),''),chr(13),''), 99 nvl($nmc_srvc_provider,0), $region, $state ,to_number(nvl($super_acct,0)) , $clean_yymm ) 100 end-sql 101 show (10, 2 ) 'Record: ' #rec_count 102 !-- nvl($nmc_name,' ') 103 end-if and here is the data that causes the problem (obviously not a long): SECURITY CONSULTANTS GRP1 (SYS4) Finally, here is the statement where we assign a value to the variable (from a read buffer): let $nmc_name = ltrim( rtrim( substr( $readbuf, 14,43),' '),' ') The statement works fine when I insert NULL. Initially I was receiving the error and I thought it was due to embedded tabs / returns, so I am using the REPLACE statement on the value. Any help would be greatly appreciated. -- Michael Prodor Qualcomm - QWBS Info Systems From owner-sqr-users@list.iex.net Mon Jul 10 11:14:33 2000 Date: Mon, 10 Jul 2000 11:37:12 -0300 From: Davi Cabral Subject: Contact ID: 122561 - Is it possible to call an SQR program from another SQR program? Dear Sirs, Is it possible to call an SQR program from another SQR program? I didn`t find anything about this on the manuals. Thank you, Davi Cabral From owner-sqr-users@list.iex.net Mon Jul 10 12:06:31 2000 Date: Mon, 10 Jul 2000 17:19:46 +0200 From: Franck Masson Subject: Re: Contact ID: 122561 - Is it possible to call an SQR program from another SQR program? This is a multi-part message in MIME format. --------------50803910693D69E94AA7DF85 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Yes, Use the call system command and example is provided in the faq.txt file. ---------------------------- Example code ends here ---------------------------- ================================================================================ Q: Can I use 'dynamic column names' in Begin-Select (versions prior to v3.0)? A: Yes, see following workaround. This SQR report will actually write another SQR code with column names supplied by the user and execute it. Note that in SQR Version 3.0, dynamic columns are directly supported. ---------------------------- Example code begins here -------------------------- begin-report do main end-report begin-procedure main move 'DEPTNO' to $col1 ! You might use INPUT here to prompt the user move 'ENAME' to $col2 ! to enter the column and table names instead. move 'EMP' to $tab move 'sqrout.sqr' to $sqrpgmnam let $syscmd = 'sqr '||$sqrpgmnam||' user/password' move 100 to #flatfileid open $sqrpgmnam as #flatfileid for-writing record=132 write #flatfileid from 'BEGIN-REPORT' write #flatfileid from ' DO MAIN' write #flatfileid from 'END-REPORT' write #flatfileid from 'BEGIN-PROCEDURE MAIN' write #flatfileid from 'BEGIN-SELECT' write #flatfileid from $col1 ' (+1,1)' write #flatfileid from $col2 ' (,30)' write #flatfileid from 'from ' $tab write #flatfileid from 'END-SELECT' write #flatfileid from 'END-PROCEDURE MAIN' close #flatfileid call system using $syscmd #status display 'Status of call is ' noline display #status end-procedure Davi Cabral wrote: > > Dear Sirs, > > Is it possible to call an SQR program from another SQR program? > I didn`t find anything about this on the manuals. > > Thank you, > > Davi Cabral --------------50803910693D69E94AA7DF85 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Franck Masson Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Franck Masson n: ;Franck Masson org: Brio Technology EMEA adr;dom: Le capitol;;55 av. des champs Pierreux;Nanterre;92000;; email;internet: franck.masson@brio.com title: Sales Manager Northern Europe tel;work: 33 1 55 69 36 00 tel;fax: 33 1 47 25 02 59 tel;home: Mobile : 33 6 84 80 17 05 x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------50803910693D69E94AA7DF85-- From owner-sqr-users@list.iex.net Mon Jul 10 11:39:00 2000 Date: Mon, 10 Jul 2000 11:13:17 -0400 From: John Milardovic Subject: Re: Contact ID: 122561 - Is it possible to call an SQR program fr om another SQR program? Read up on "Call System Using" or search the archives. HTH John Milardovic > -----Original Message----- > From: Davi Cabral [SMTP:dcabral@RECSA.COM.BR] > Sent: Monday, July 10, 2000 10:37 AM > To: SQR-USERS@list.iex.net > Subject: Contact ID: 122561 - Is it possible to call an SQR program > from another SQR program? > > Dear Sirs, > > Is it possible to call an SQR program from another SQR program? > I didn`t find anything about this on the manuals. > > Thank you, > > Davi Cabral From owner-sqr-users@list.iex.net Mon Jul 10 12:56:33 2000 Date: Mon, 10 Jul 2000 12:01:50 -0400 From: "Stein, Steve" Subject: Tricky SQL I need to do a query where it takes the latest dated row from one table (PS_VOUCHER_LINE) and the latest dated row from an effective dated table (PS_CM_PRODCOST). It is probably very simple but I'm having no luck. Anyone can help? So far I used psquery tool to get this SQL: SELECT B.MERCHANDISE_AMT, B.INV_ITEM_ID, C.TL_COST, C.BUSINESS_UNIT, C.INV_ITEM_ID, TO_CHAR(A.INVOICE_DT,'YYYY-MM-DD') FROM PS_VOUCHER A, PS_VOUCHER_LINE B, PS_CM_PRODCOST C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND C.EFFDT = (SELECT MAX(C_ED.EFFDT) FROM PS_CM_PRODCOST C_ED WHERE C.BUSINESS_UNIT = C_ED.BUSINESS_UNIT AND C.INV_ITEM_ID = C_ED.INV_ITEM_ID AND C.CONFIG_CODE = C_ED.CONFIG_CODE AND C_ED.EFFDT <= SYSDATE) AND C.INV_ITEM_ID = B.INV_ITEM_ID AND EXISTS (SELECT MAX( D.INVOICE_DT) FROM PS_VOUCHER D, PS_VOUCHER_LINE E WHERE D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.VOUCHER_ID = E.VOUCHER_ID) AND B.INV_ITEM_ID = 'A039901100' but it was returning all the PS_VOUCHER_LINE rows 11.52 A039901100 10.0000 I0005 A039901100 1999-08-26 17.28 A039901100 10.0000 I0005 A039901100 1999-10-06 12.96 A039901100 10.0000 I0005 A039901100 1999-10-21 23.04 A039901100 10.0000 I0005 A039901100 1999-12-01 17.28 A039901100 10.0000 I0005 A039901100 1999-12-10 17.28 A039901100 10.0000 I0005 A039901100 1999-12-10. From owner-sqr-users@list.iex.net Mon Jul 10 13:14:04 2000 Date: Mon, 10 Jul 2000 11:23:54 -0500 From: "Aguirre, Jose' A" Subject: Re: Tricky SQL select FIELD from TABLE where FIELD A= FIELD B AND L.EFFDT = (select max(EFFDT) from PS_VENDOR_LOC l2 where l2.VENDOR_ID = L.VENDOR_ID and l2.VNDR_LOC = L.VNDR_LOC and l2.EFFDT <= GETDATE()) José A. Aguirre -----Original Message----- From: Stein, Steve [mailto:Steve.Stein@ISACS.COM] Sent: Monday, July 10, 2000 11:02 AM To: SQR-USERS@LIST.IEX.NET Subject: Tricky SQL I need to do a query where it takes the latest dated row from one table (PS_VOUCHER_LINE) and the latest dated row from an effective dated table (PS_CM_PRODCOST). It is probably very simple but I'm having no luck. Anyone can help? So far I used psquery tool to get this SQL: SELECT B.MERCHANDISE_AMT, B.INV_ITEM_ID, C.TL_COST, C.BUSINESS_UNIT, C.INV_ITEM_ID, TO_CHAR(A.INVOICE_DT,'YYYY-MM-DD') FROM PS_VOUCHER A, PS_VOUCHER_LINE B, PS_CM_PRODCOST C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND C.EFFDT = (SELECT MAX(C_ED.EFFDT) FROM PS_CM_PRODCOST C_ED WHERE C.BUSINESS_UNIT = C_ED.BUSINESS_UNIT AND C.INV_ITEM_ID = C_ED.INV_ITEM_ID AND C.CONFIG_CODE = C_ED.CONFIG_CODE AND C_ED.EFFDT <= SYSDATE) AND C.INV_ITEM_ID = B.INV_ITEM_ID AND EXISTS (SELECT MAX( D.INVOICE_DT) FROM PS_VOUCHER D, PS_VOUCHER_LINE E WHERE D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.VOUCHER_ID = E.VOUCHER_ID) AND B.INV_ITEM_ID = 'A039901100' but it was returning all the PS_VOUCHER_LINE rows 11.52 A039901100 10.0000 I0005 A039901100 1999-08-26 17.28 A039901100 10.0000 I0005 A039901100 1999-10-06 12.96 A039901100 10.0000 I0005 A039901100 1999-10-21 23.04 A039901100 10.0000 I0005 A039901100 1999-12-01 17.28 A039901100 10.0000 I0005 A039901100 1999-12-10 17.28 A039901100 10.0000 I0005 A039901100 1999-12-10. From owner-sqr-users@list.iex.net Mon Jul 10 18:49:41 2000 Date: Mon, 10 Jul 2000 15:31:24 -0700 From: Bob Lang Subject: Re: Tricky SQL Steve. Check the format of Sysdate against the format of C_ED.EFFDT. That might be where the problem lies. Everything else looks ok to me. By the way, your name seems familiar to me, do I know you? Access Number: (877) 453-8931 From owner-sqr-users@list.iex.net Tue Jul 11 05:00:31 2000 Date: Tue, 11 Jul 2000 02:16:47 -0700 From: Arjan Hoornstra Subject: Re: Tricky SQL Steve, The exists sub-query is not correlated. The tables D and E are not used in another part of the query (each aliassed table is another one). There must lie your problem... I think the last subquery must be instead of: > AND EXISTS (SELECT MAX( D.INVOICE_DT) you need: > AND A.INVOICE_DT = (SELECT MAX( D.INVOICE_DT) Arjan --- "Stein, Steve" wrote: > I need to do a query where it takes the latest dated > row from one table > (PS_VOUCHER_LINE) and the latest dated row from an > effective dated table > (PS_CM_PRODCOST). It is probably very simple but > I'm having no luck. > Anyone can help? > > So far I used psquery tool to get this SQL: > > SELECT B.MERCHANDISE_AMT, B.INV_ITEM_ID, C.TL_COST, > C.BUSINESS_UNIT, > C.INV_ITEM_ID, TO_CHAR(A.INVOICE_DT,'YYYY-MM-DD') > FROM PS_VOUCHER A, PS_VOUCHER_LINE B, > PS_CM_PRODCOST C > WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT > AND A.VOUCHER_ID = B.VOUCHER_ID > AND C.EFFDT = > (SELECT MAX(C_ED.EFFDT) FROM PS_CM_PRODCOST > C_ED > WHERE C.BUSINESS_UNIT = C_ED.BUSINESS_UNIT > AND C.INV_ITEM_ID = C_ED.INV_ITEM_ID > AND C.CONFIG_CODE = C_ED.CONFIG_CODE > AND C_ED.EFFDT <= SYSDATE) > AND C.INV_ITEM_ID = B.INV_ITEM_ID > AND EXISTS (SELECT MAX( D.INVOICE_DT) > FROM PS_VOUCHER D, PS_VOUCHER_LINE E > WHERE D.BUSINESS_UNIT = E.BUSINESS_UNIT > AND D.VOUCHER_ID = E.VOUCHER_ID) > AND B.INV_ITEM_ID = 'A039901100' > > but it was returning all the PS_VOUCHER_LINE rows > > 11.52 A039901100 > 10.0000 I0005 > A039901100 1999-08-26 > 17.28 A039901100 > 10.0000 I0005 > A039901100 1999-10-06 > 12.96 A039901100 > 10.0000 I0005 > A039901100 1999-10-21 > 23.04 A039901100 > 10.0000 I0005 > A039901100 1999-12-01 > 17.28 A039901100 > 10.0000 I0005 > A039901100 1999-12-10 > 17.28 A039901100 > 10.0000 I0005 > A039901100 1999-12-10. __________________________________________________ Do You Yahoo!? Get Yahoo! Mail – Free email you can access from anywhere! http://mail.yahoo.com/ From owner-sqr-users@list.iex.net Mon Jul 10 14:26:26 2000 Date: Mon, 10 Jul 2000 17:53:52 GMT From: Ragu Sadasivam Subject: Page breaks in HTML Hi Everyone, I have an sqr that generates a report in HTML format using the -PRINTER:HT feature. * Even though there are page breaks in the output, when I print from within IE it ignores the breaks. In the sense, if one page has 10 lines and so does the next page, it prints both on one page with the break. How do I get IE to recognize the breaks? Appreciate your help. Thanks. LKR ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Jul 10 18:29:23 2000 Date: Mon, 10 Jul 2000 17:06:54 +0100 From: Enrique =?iso-8859-1?Q?Mu=F1oz?= Subject: Re: Page breaks in HTML You can do this: -printer:ep Now, This flag you cag get html file and pdf file... And the breaks Ragu Sadasivam wrote: > Hi Everyone, > > I have an sqr that generates a report in HTML format using the -PRINTER:HT > feature. > > * Even though there are page breaks in the output, when I print from within > IE it ignores the breaks. In the sense, if one page has 10 lines and so > does the next page, it prints both on one page with the break. How do I get > IE to recognize the breaks? > > Appreciate your help. > > Thanks. > > LKR > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 12 14:05:56 2000 Date: Wed, 12 Jul 2000 17:40:07 GMT From: Ragu Sadasivam Subject: Re: Page breaks in HTML I tried this and ended with an error for the PDF file. I'll try again. Does anyone know what triggers the FONT BASESIZE in the HTML document. My sqr generates multiple reports and on every report the first page the headings and the columns are off. It is introducing a FONT BASESIZE 4 eventhough I have reduced it to 2. But then there is FONT size 2 and the output is ok. Any thoughts on this one.... >From: Enrique Muñoz >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Page breaks in HTML >Date: Mon, 10 Jul 2000 17:06:54 +0100 > >You can do this: > >-printer:ep > >Now, This flag you cag get html file and pdf file... And the breaks > >Ragu Sadasivam wrote: > > > Hi Everyone, > > > > I have an sqr that generates a report in HTML format using the >-PRINTER:HT > > feature. > > > > * Even though there are page breaks in the output, when I print from >within > > IE it ignores the breaks. In the sense, if one page has 10 lines and so > > does the next page, it prints both on one page with the break. How do I >get > > IE to recognize the breaks? > > > > Appreciate your help. > > > > Thanks. > > > > LKR > > > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 12 15:35:26 2000 Date: Wed, 12 Jul 2000 15:11:42 -0400 From: "Dombrowski, Dave F" Subject: Re: Page breaks in HTML I could be wrong, but I've never heard of page breaks in HTML. Don't confuse separate web pages from a single web page with page breaking. Using SQR printer options will yield separate web pages. A three page 'document' is actually three separate web pages (HTML files). A browser has no capabilities to interpret printer commands like page breaks, carriage returns or tabbing. How could it? Even if you 'space out' things so that a page 'appears' to break where intended, what would happen when the user alters the text size through the browser? I'm not talking about .PDF or .DOC or .RPT files, just .HTM/.HTML files. The advantage you gain with straight HTML is that you are truly browser independent - no third party server software or browser plugins needed - and that you can do other things like edit data and more easily pull data dynamically. The advantage you gain from a .PDF or other file is full control over formatting. In the end, it's a matter of knowing who your clients are and what software they have. For 'pure' internet apps, you usually end up using server-side processing with as little JavaScript as possible and send out straight HTML to the client. For reporting purposes, use HTML tables to format things as best as possible. If you get concerned with page breks, split the output into separate web pages and provide navigation to move from one to another. Finally, if you absolutely must use something like .PDF files, always always always provide a prominent link for users to download the software needed to open it. -----Original Message----- From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] Sent: Wednesday, July 12, 2000 1:40 PM To: SQR-USERS@list.iex.net Subject: Re: Page breaks in HTML I tried this and ended with an error for the PDF file. I'll try again. Does anyone know what triggers the FONT BASESIZE in the HTML document. My sqr generates multiple reports and on every report the first page the headings and the columns are off. It is introducing a FONT BASESIZE 4 eventhough I have reduced it to 2. But then there is FONT size 2 and the output is ok. Any thoughts on this one.... >From: Enrique Muñoz >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Page breaks in HTML >Date: Mon, 10 Jul 2000 17:06:54 +0100 > >You can do this: > >-printer:ep > >Now, This flag you cag get html file and pdf file... And the breaks > >Ragu Sadasivam wrote: > > > Hi Everyone, > > > > I have an sqr that generates a report in HTML format using the >-PRINTER:HT > > feature. > > > > * Even though there are page breaks in the output, when I print from >within > > IE it ignores the breaks. In the sense, if one page has 10 lines and so > > does the next page, it prints both on one page with the break. How do I >get > > IE to recognize the breaks? > > > > Appreciate your help. > > > > Thanks. > > > > LKR > > > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 12 16:49:12 2000 Date: Wed, 12 Jul 2000 20:28:21 GMT From: Ragu Sadasivam Subject: Re: Page breaks in HTML The reason I am even concerned about page breaks is b'cos, the report originally was designed that way per customer's request. Right now, it can be viewed with the SQR Viewer and printed. [It is a lengthy document - 1800 pages]. The reason we want it on the web is for distribution and also the licensing issues with SQR Viewer. Only y'day I found out about the page breaks not being possible in HTML. If people are looking to put their reports out in the web, for the ease of distribution and viewing [since IE or Netscape is on everyone's desktop], should it not be able to recognize page breaks. What is the use of publishing these reports online and go through the trouble of trying to fit them logically, if HTML is going to do its own thing? Any thoughts on the FONT BASESIZE [mentioned below]- what triggers this? Appreciate your help... >From: "Dombrowski, Dave F" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Page breaks in HTML >Date: Wed, 12 Jul 2000 15:11:42 -0400 > >I could be wrong, but I've never heard of page breaks in HTML. Don't >confuse >separate web pages from a single web page with page breaking. Using SQR >printer options will yield separate web pages. A three page 'document' is >actually three separate web pages (HTML files). A browser has no >capabilities to interpret printer commands like page breaks, carriage >returns or tabbing. How could it? Even if you 'space out' things so that a >page 'appears' to break where intended, what would happen when the user >alters the text size through the browser? > >I'm not talking about .PDF or .DOC or .RPT files, just .HTM/.HTML files. >The >advantage you gain with straight HTML is that you are truly browser >independent - no third party server software or browser plugins needed - >and >that you can do other things like edit data and more easily pull data >dynamically. The advantage you gain from a .PDF or other file is full >control over formatting. > >In the end, it's a matter of knowing who your clients are and what software >they have. For 'pure' internet apps, you usually end up using server-side >processing with as little JavaScript as possible and send out straight HTML >to the client. For reporting purposes, use HTML tables to format things as >best as possible. If you get concerned with page breks, split the output >into separate web pages and provide navigation to move from one to another. >Finally, if you absolutely must use something like .PDF files, always >always >always provide a prominent link for users to download the software needed >to >open it. > >-----Original Message----- >From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] >Sent: Wednesday, July 12, 2000 1:40 PM >To: SQR-USERS@list.iex.net >Subject: Re: Page breaks in HTML > > >I tried this and ended with an error for the PDF file. I'll try again. > >Does anyone know what triggers the FONT BASESIZE in the HTML document. My >sqr generates multiple reports and on every report the first page the >headings and the columns are off. It is introducing a FONT BASESIZE 4 >eventhough I have reduced it to 2. But then there is FONT size 2 and the >output is ok. > >Any thoughts on this one.... > > > >From: Enrique Muñoz > >Reply-To: sqr-users@list.iex.net > >To: SQR-USERS@list.iex.net > >Subject: Re: Page breaks in HTML > >Date: Mon, 10 Jul 2000 17:06:54 +0100 > > > >You can do this: > > > >-printer:ep > > > >Now, This flag you cag get html file and pdf file... And the breaks > > > >Ragu Sadasivam wrote: > > > > > Hi Everyone, > > > > > > I have an sqr that generates a report in HTML format using the > >-PRINTER:HT > > > feature. > > > > > > * Even though there are page breaks in the output, when I print from > >within > > > IE it ignores the breaks. In the sense, if one page has 10 lines and >so > > > does the next page, it prints both on one page with the break. How do >I > >get > > > IE to recognize the breaks? > > > > > > Appreciate your help. > > > > > > Thanks. > > > > > > LKR > > > > > > >________________________________________________________________________ > > > Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 12 18:39:52 2000 Date: Wed, 12 Jul 2000 17:23:07 -0500 From: Don Mellen Subject: Re: Page breaks in HTML On Wed, 12 Jul 2000, Ragu Sadasivam wrote: > The reason I am even concerned about page breaks is b'cos, the report > originally was designed that way per customer's request. Right now, it can > be viewed with the SQR Viewer and printed. [It is a lengthy document - 1800 > pages]. The reason we want it on the web is for distribution and also the > licensing issues with SQR Viewer. If you're wanting to create seperate HTML files for an 1800 page report, (which most browsers would take a while with), check out the -Burst command line flag (discussions of which are in the archives at www.scrug.com and in the books). It will make many HTML files instead of one based on various criteria. ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" From owner-sqr-users@list.iex.net Wed Jul 12 21:49:54 2000 Date: Thu, 13 Jul 2000 13:24:11 +1200 From: Anthony J Vesey Subject: Re: Page breaks in HTML Ragu, Page breaks are possible in HTML, although not necessarily 'on-screen' breaks. HTML is a structural markup language, defining elements (i.e this is a paragraph, a title etc). It is not designed for layout (i.e. page break here). The WWW consortium who define HTML and like standards have developed the CSS (Cascading Style Sheets) stanard for this very purpose. It allows you to specify how elements on a page (of HTML) should be laid out, what colour etc. CSS2 is the latest recommendation and includes the ability to target output for different media. Therefore is is possible to produce an HTML file that looks like one page onscreen and when printed has the authors defined page breaks. To use these elements with SQR would require more effort however. And you would need to make sure that the customers browsers supported the standard. Sadly many current generation browsers do not support the standard properly, if only partially, and many are buggy to boot. And purists will argue that you can't force people to use a particular browser just to get page breaks. In summary , you might be able to implement page breaks but the results will be browser dependent anyway. The relevant standards can be found on the W3C page http://www.w3c.org http://www.w3.org/Style/CSS/ for Cascading Style Sheets and http://www.w3.org/MarkUp/ for HTML Hope this helps Anthony Vesey -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Ragu Sadasivam Sent: Thursday, 13 July 2000 08:28 To: SQR-USERS@list.iex.net Subject: Re: Page breaks in HTML The reason I am even concerned about page breaks is b'cos, the report originally was designed that way per customer's request. Right now, it can be viewed with the SQR Viewer and printed. [It is a lengthy document - 1800 pages]. The reason we want it on the web is for distribution and also the licensing issues with SQR Viewer. Only y'day I found out about the page breaks not being possible in HTML. If people are looking to put their reports out in the web, for the ease of distribution and viewing [since IE or Netscape is on everyone's desktop], should it not be able to recognize page breaks. What is the use of publishing these reports online and go through the trouble of trying to fit them logically, if HTML is going to do its own thing? Any thoughts on the FONT BASESIZE [mentioned below]- what triggers this? Appreciate your help... >From: "Dombrowski, Dave F" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Page breaks in HTML >Date: Wed, 12 Jul 2000 15:11:42 -0400 > >I could be wrong, but I've never heard of page breaks in HTML. Don't >confuse >separate web pages from a single web page with page breaking. Using SQR >printer options will yield separate web pages. A three page 'document' is >actually three separate web pages (HTML files). A browser has no >capabilities to interpret printer commands like page breaks, carriage >returns or tabbing. How could it? Even if you 'space out' things so that a >page 'appears' to break where intended, what would happen when the user >alters the text size through the browser? > >I'm not talking about .PDF or .DOC or .RPT files, just .HTM/.HTML files. >The >advantage you gain with straight HTML is that you are truly browser >independent - no third party server software or browser plugins needed - >and >that you can do other things like edit data and more easily pull data >dynamically. The advantage you gain from a .PDF or other file is full >control over formatting. > >In the end, it's a matter of knowing who your clients are and what software >they have. For 'pure' internet apps, you usually end up using server-side >processing with as little JavaScript as possible and send out straight HTML >to the client. For reporting purposes, use HTML tables to format things as >best as possible. If you get concerned with page breks, split the output >into separate web pages and provide navigation to move from one to another. >Finally, if you absolutely must use something like .PDF files, always >always >always provide a prominent link for users to download the software needed >to >open it. > >-----Original Message----- >From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] >Sent: Wednesday, July 12, 2000 1:40 PM >To: SQR-USERS@list.iex.net >Subject: Re: Page breaks in HTML > > >I tried this and ended with an error for the PDF file. I'll try again. > >Does anyone know what triggers the FONT BASESIZE in the HTML document. My >sqr generates multiple reports and on every report the first page the >headings and the columns are off. It is introducing a FONT BASESIZE 4 >eventhough I have reduced it to 2. But then there is FONT size 2 and the >output is ok. > >Any thoughts on this one.... > > > >From: Enrique Muñoz > >Reply-To: sqr-users@list.iex.net > >To: SQR-USERS@list.iex.net > >Subject: Re: Page breaks in HTML > >Date: Mon, 10 Jul 2000 17:06:54 +0100 > > > >You can do this: > > > >-printer:ep > > > >Now, This flag you cag get html file and pdf file... And the breaks > > > >Ragu Sadasivam wrote: > > > > > Hi Everyone, > > > > > > I have an sqr that generates a report in HTML format using the > >-PRINTER:HT > > > feature. > > > > > > * Even though there are page breaks in the output, when I print from > >within > > > IE it ignores the breaks. In the sense, if one page has 10 lines and >so > > > does the next page, it prints both on one page with the break. How do >I > >get > > > IE to recognize the breaks? > > > > > > Appreciate your help. > > > > > > Thanks. > > > > > > LKR > > > > > > >________________________________________________________________________ > > > Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jul 12 16:58:37 2000 Date: Wed, 12 Jul 2000 16:37:07 -0400 From: "Dray, Adam" Subject: Re: Page breaks in HTML Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] said: > The reason I am even concerned about page breaks is b'cos, the report > originally was designed that way per customer's request. Right now, it can > be viewed with the SQR Viewer and printed. [It is a lengthy document - 1800 > pages]. The reason we want it on the web is for distribution and also the > licensing issues with SQR Viewer. Only y'day I found out about the page > breaks not being possible in HTML. If people are looking to put their > reports out in the web, for the ease of distribution and viewing [since IE > or Netscape is on everyone's desktop], should it not be able to recognize > page breaks. What is the use of publishing these reports online and go > through the trouble of trying to fit them logically, if HTML is going to do > its own thing? The web is a browser display medium, not a print medium. The concept of "pages" (a la pieces of paper) with page breaks does not exist in HTML. Those who require fine web-to-paper control tend to use Adobe Acrobat (PDF) format files. With PDF ("Portable Display Format", I believe), you get the page-level control you need, plus fine control over fonts and text placement. Doesn't SQR offer PDF output? Adam From owner-sqr-users@list.iex.net Wed Jul 12 17:34:44 2000 Date: Wed, 12 Jul 2000 17:12:35 -0400 From: "Dombrowski, Dave F" Subject: Re: Page breaks in HTML I understand your thoughts regarding page breaks. I didn't mean to slam you - hope you didn't take it that way. The internet is the most generic platform ever devised. HTML is the most generic language ever devised (if you want to call markup commands a language - but that's a debate for another time) that is controlled by the W3C. The idea was to be generic. To be platform independent. There are a couple of concepts to grasp any time you develop for the web. These concepts are inherently different than Windows programming. First, understand what asynchronous modes of communicating between the client and server mean. Understand how precious bandwidth is. How to provide as much _perceived_ interaction and validation as possible while actually coding as little _actual_ interaction (read:bandwidth) as humanly possible. Second, understand that pure _internet_ (as opposed to _intranet_) apps have very little demands on any client. No software platforms, no minimum bandwidths, no browser versions. John Doe on his Mac may browse from NYC. Jane Doe with her Pentium III and IE5.5 may browse from Asia. Your boss may want to pull of info from his Palm Pilot! Pure internet apps try to work to the largest possible audience. Like someone just posted, if you desire good printing capabilities use a third party like Adobe/PDF or Crystal/RPT. Just don't expect to do it through HTML. As for BASESIZE... that may be an SQR option that you can change somehow. I'm new to SQR (as opposed to VB/COBOL/ASP/HTML) and can't help you. I was only trying to explain some background regarding some things everyone encounters when starting to program for browsers. Good luck! -----Original Message----- From: Ragu Sadasivam [mailto:sathyamangalam@HOTMAIL.COM] Sent: Wednesday, July 12, 2000 4:28 PM To: SQR-USERS@list.iex.net Subject: Re: Page breaks in HTML The reason I am even concerned about page breaks is b'cos, the report originally was designed that way per customer's request. Right now, it can be viewed with the SQR Viewer and printed. [It is a lengthy document - 1800 pages]. The reason we want it on the web is for distribution and also the licensing issues with SQR Viewer. Only y'day I found out about the page breaks not being possible in HTML. If people are looking to put their reports out in the web, for the ease of distribution and viewing [since IE or Netscape is on everyone's desktop], should it not be able to recognize page breaks. What is the use of publishing these reports online and go through the trouble of trying to fit them logically, if HTML is going to do its own thing? Any thoughts on the FONT BASESIZE [mentioned below]- what triggers this? Appreciate your help... >From: "Dombrowski, Dave F" >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Page breaks in HTML >Date: Wed, 12 Jul 2000 15:11:42 -0400 > >I could be wrong, but I've never heard of page breaks in HTML. Don't >confuse >separate web pages from a single web page with page breaking. Using SQR >printer options will yield separate web pages. A three page 'document' is >actually three separate web pages (HTML files). A browser has no >capabilities to interpret printer commands like page breaks, carriage >returns or tabbing. How could it? Even if you 'space out' things so that a >page 'appears' to break where intended, what would happen when the user >alters the text size through the browser? > >I'm not talking about .PDF or .DOC or .RPT files, just .HTM/.HTML files. >The >advantage you gain with straight HTML is that you are truly browser >independent - no third party server software or browser plugins needed - >and >that you can do other things like edit data and more easily pull data >dynamically. The advantage you gain from a .PDF or other file is full >control over formatting. > >In the end, it's a matter of knowing who your clients are and what software >they have. For 'pure' internet apps, you usually end up using server-side >processing with as little JavaScript as possible and send out straight HTML >to the client. For reporting purposes, use HTML tables to format things as >best as possible. If you get concerned with page breks, split the output >into separate web pages and provide navigation to move from one to another. >Finally, if you absolutel