From sqr-users-admin@sqrug.org Tue Apr 1 00:02:37 2003 Date: Tue, 1 Apr 2003 00:00:02 -0500 From: Nathan Stratton Treadway Subject: [sqr-users] Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathanst@ontko.com) $Revision: 1.14 $ $Date: 2002-11-13 12:55:07-05 $ This document gathers in one location information about the sqr-users mail list. It includes instructions for changing your subscription settings (including unsubscribing), as well are guidelines for using the list. ______________________________________________________________________ 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. Interacting with the list server 3.1 Subscribing to the list 3.2 Unsubscribing from the list 3.3 Digests 3.4 Obtaining your password 3.5 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 2002/04/17: o Reflect the new location of the list and the new list server software being used. 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 Software (and to other products in the SQR product suite). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. Brio Technology changed its name to Brio Software in October 2001. SQR and related applications have also been called "Brio.Report" and "Brio Reports". 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.org/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 Copyright (C) 1999-2002 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 Here are some mailing lists that cover topics relating to SQR in some way. sqr-jobs : SQR Jobs This list may be used for posting SQR-related resumes, recruitments, job announcements, project announcments, help- wanted, work-wanted ads, etc. To join, follow the link above, or send any message to "sqr-jobs-subscribe@yahoogroups.com". peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. BrioSQRReport : Brio SQR Report List for discussion of SQR and SQR Developer (formerly called Brio.Report and Report Builder). To join, follow the link above, or send any message to "BrioSQRReport- subscribe@yahoogroups.com". rm-users : Report- Mart 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.org". brioportalusersgroup : Brio Portal Users Group list List for discussion of Brio Portal. To join, follow the link above, or send any message to "brioportalusersgroup- subscribe@yahoogroups.com". brio-l : OpenITx Brio List List for technical and functional discussion of all Brio products (but most messages are currently about Brio Intelligence). To join, follow the link above. briousers : Brio.Enter- prise Users List for discussion of the Brio.Enterprise (now called Intelligence) product. To join, follow the link above, or send any message to "briousers-subscribe@yahoogroups.com". briolist : Brio List List for discussion of Brio Intelligence. To join, follow the link above, or send any message to "briolist- subscribe@yahoogroups.com". 3. Interacting with the list server The sqr-users mailing list is hosted using the MailMan list server package. All of the MailMan functions described below are accessed from the sqr-users List Info page, "http://www.sqrug.org/mailman/listinfo/sqr-users". 3.1. Subscribing to the list To subscribe to the mailing list, enter your e-mail address in the box at the top of the "Subscribing to sqr-users" section on the sqr-users List Info page, then choose a password to assign to your subscription and enter it in both "Password" boxes. This password is used to allow you to securely make changes to your subscription over the web. This password will be e-mailed back to you at varous times, so you should not use the same password as you are using elsewhere. Once you have filled in the password, click the "Subscribe" button. You should soon receive an e-mail message from the list server requesting confirmation of your subscription request. Once you have replied to this message and your subscription has been processed, you will receive a "welcome" message giving you more information on the list server, and as well as a reminder of the subscription password you chose. 3.2. Unsubscribing from the list To unsubscribe from the list, go to the sqr-users List Info page, enter your e-mail address in the "sqr-users Subscribers" section, and click the "Edit Options" button. In the page that comes up, there will be an "Unsubscribing from sqr-users" section; simply enter your password in the box there and click the "Unsubscribe" button. Assuming you enter the correct password, you will recieve a message stating "You have been unsubscribed." and the removal will take effect immediately (there is no need to send in a confirmation e-mail message). (If you have forgotton your password, see the instructions below.) 3.3. Digests You can request to get your messages in digest form (one large message containing all of the posts made each day). To do this, enter your address in the "sqr-users Subscribers" section of the sqr-users List Info page and click the "Edit Options" button. At the bottom of the resulting page, you will see a section titled "Your sqr-users Subscription Options". Change the "Set Digest Mode" option to "On", enter your subscription password in the box provided, and click the "Submit My Changes" button. (If you have forgotton your password, see the instructions below.) You actually have a choice of two different digest formats, "MIME" or "Plain Text". The MIME format sends each individual list message as a separate MIME attachment to the digest; the plain text format consists of one large text message, with all of the individual messages run together. Which format you will want to use depends on your mail- reading software (and personal preference). If you are not sure which format will work best, you can just leave the default setting of "MIME" and see if the next morning's digest is easy to read in your mail reader -- you can change to the other format at any time using that same web page. 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. To restore normal distribution, simply follow the above instructions choosing the "Off" setting for the Digest option. 3.4. Obtaining your password You will not be able to unsubscribe or change your subscription options without your password. If you have forgotten your password, simply click the "Email My Password to Me" button on the Edit Options page and your password will be e-mailed to you. You will also be e- mailed a copy of your password at the beginning of each month, as part of a "mailing list memberships reminder" message from the MailMan software. 3.5. Problems If the above instructions do not work, please contact the list manager at "sqr-users-manager@sqrug.org". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a description of what you were trying to do and what exactly happened when you made the attempt. 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.) The list server will delete these special attachments from your message and send you a warning notice. 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. o ignore abusive and inappropriate messages that get sent to the list, rather than getting drawn into a debate. The very nature of these messages will cause most subscribers to automatically discredit them -- no "response" is necessary. To the contrary, any response will only "add fule to the fire," prolonging the controversy and further interupting the normal conversation on the list. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@sqrug.org". 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 (see notes below) 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. (For PeopleSoft- specific questions, see other lists mentioned in the ``Related Mailing Lists'' section.) In 2001, PeopleSoft purchased from Brio the rights to the source code for SQR and began releasing its own line of SQR. PeopleSoft's SQR version numbering is different from Brio's, so it's very important to mention whether you are using Brio's "SQR" or "SQR for PeopleSoft". (This info is included automatically if you include the full SQR version-id string as described below.) To get the version-id string for your copy 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 this infor- mation for your own environment. In a command-line environment (Unix, etc.), you can also get this version-id string by saying sqr -id 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.) 5. Job Announcements Please do not post job announcements on the sqr-users list, but use the sqr-jobs list instead. (See ``Related Mailing Lists'' for more information on this list.) A large number of sqr-users subscribers do not want to receive job announcements (for various reasons) and such posts tend to cause a lot of disruption of the discussion on the list. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 1 10:06:03 2003 Date: Tue, 1 Apr 2003 07:03:56 -0800 (PST) From: Rehan Khan Subject: [sqr-users] Image not appearing on Letters Hi, I am trying to get an image ( signature ) on the letters created by an SQR. It works great when I am testing in SQRW ( Windows ) environment, the file that has the image is in SPF format. The code used to print the image in Windows is as follows: declare-image signature Type=BMP-FILE Source='C:\Temp\ladyliberty.bmp' end-declare let #image_length = 8 let #image_height = 6 print 'Look at this picture: ' (+2,{midcol}) print-image signature (+2,{midcol}) image-size= (#image_length, #image_height) let #current_line_adj = #image_height +3 print 'Any Comments?' (+#current_line_adj,{midcol}) But when I am trying to use the same code to print the file to Docutech( Printer Name ) I dont get any image. The code for this is as follows: declare-image signature Type=GIF-FILE Source='/t02/app/psft/ladyliberty.gif/' end-declare OR declare-image signature Type=JPEG-FILE Source='/t02/app/psft/ladyliberty.jpg/' end-declare Ive tried GIF and JPG format and both doesnt work. The file that gets send to the Docutech printer is in .LIS format. Any Suggestions RK --------------------------------- Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 1 12:35:05 2003 Subject: RE: [sqr-users] Image not appearing on Letters Date: Tue, 1 Apr 2003 11:33:59 -0600 From: "Lindquist, Maria" I can only get my images to show up in SQRW too. If anyone comes up with a solution to get it to work on a SQR run thru the web (PDF) let me know. When I run it thru the web it shows up as a box with an X in it. :( -----Original Message----- From: Rehan Khan [mailto:mr52385@yahoo.com] Sent: Tuesday, April 01, 2003 9:04 AM To: sqr-users@sqrug.org Subject: [sqr-users] Image not appearing on Letters Hi, I am trying to get an image ( signature ) on the letters created by an SQR. It works great when I am testing in SQRW ( Windows ) environment, the file that has the image is in SPF format. The code used to print the image in Windows is as follows: declare-image signature Type=BMP-FILE Source='C:\Temp\ladyliberty.bmp' end-declare let #image_length = 8 let #image_height = 6 print 'Look at this picture: ' (+2,{midcol}) print-image signature (+2,{midcol}) image-size= (#image_length, #image_height) let #current_line_adj = #image_height +3 print 'Any Comments?' (+#current_line_adj,{midcol}) But when I am trying to use the same code to print the file to Docutech( Printer Name ) I dont get any image. The code for this is as follows: declare-image signature Type=GIF-FILE Source='/t02/app/psft/ladyliberty.gif/' end-declare OR declare-image signature Type=JPEG-FILE Source='/t02/app/psft/ladyliberty.jpg/' end-declare Ive tried GIF and JPG format and both doesnt work. The file that gets send to the Docutech printer is in .LIS format. Any Suggestions RK --------------------------------- Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 1 12:47:06 2003 From: "Benzenhafer, Dave" Subject: RE: [sqr-users] Image not appearing on Letters Date: Tue, 1 Apr 2003 11:42:31 -0600 For a PDF to pick up the image it has to be a JPEG. SPF files require a BMP. If you need it to show in both file types, you might try to declare both images and print them in the same location so that both file types can see them. Dave Benzenhafer -----Original Message----- From: Lindquist, Maria [mailto:mlindqui@uwc.edu] Sent: Tuesday, April 01, 2003 11:34 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Image not appearing on Letters I can only get my images to show up in SQRW too. If anyone comes up with a solution to get it to work on a SQR run thru the web (PDF) let me know. When I run it thru the web it shows up as a box with an X in it. :( -----Original Message----- From: Rehan Khan [mailto:mr52385@yahoo.com] Sent: Tuesday, April 01, 2003 9:04 AM To: sqr-users@sqrug.org Subject: [sqr-users] Image not appearing on Letters Hi, I am trying to get an image ( signature ) on the letters created by an SQR. It works great when I am testing in SQRW ( Windows ) environment, the file that has the image is in SPF format. The code used to print the image in Windows is as follows: declare-image signature Type=BMP-FILE Source='C:\Temp\ladyliberty.bmp' end-declare let #image_length = 8 let #image_height = 6 print 'Look at this picture: ' (+2,{midcol}) print-image signature (+2,{midcol}) image-size= (#image_length, #image_height) let #current_line_adj = #image_height +3 print 'Any Comments?' (+#current_line_adj,{midcol}) But when I am trying to use the same code to print the file to Docutech( Printer Name ) I dont get any image. The code for this is as follows: declare-image signature Type=GIF-FILE Source='/t02/app/psft/ladyliberty.gif/' end-declare OR declare-image signature Type=JPEG-FILE Source='/t02/app/psft/ladyliberty.jpg/' end-declare Ive tried GIF and JPG format and both doesnt work. The file that gets send to the Docutech printer is in .LIS format. Any Suggestions RK --------------------------------- Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 1 15:53:13 2003 Date: Tue, 1 Apr 2003 12:51:59 -0800 (PST) From: Rehan Khan Subject: RE: [sqr-users] Image not appearing on Letters Thank you the jpg option worked with pdf file format. I am now going to try the same thing with .lis file. Take Care "Benzenhafer, Dave" wrote:For a PDF to pick up the image it has to be a JPEG. SPF files require a BMP. If you need it to show in both file types, you might try to declare both images and print them in the same location so that both file types can see them. Dave Benzenhafer -----Original Message----- From: Lindquist, Maria [mailto:mlindqui@uwc.edu] Sent: Tuesday, April 01, 2003 11:34 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] Image not appearing on Letters I can only get my images to show up in SQRW too. If anyone comes up with a solution to get it to work on a SQR run thru the web (PDF) let me know. When I run it thru the web it shows up as a box with an X in it. :( -----Original Message----- From: Rehan Khan [mailto:mr52385@yahoo.com] Sent: Tuesday, April 01, 2003 9:04 AM To: sqr-users@sqrug.org Subject: [sqr-users] Image not appearing on Letters Hi, I am trying to get an image ( signature ) on the letters created by an SQR. It works great when I am testing in SQRW ( Windows ) environment, the file that has the image is in SPF format. The code used to print the image in Windows is as follows: declare-image signature Type=BMP-FILE Source='C:\Temp\ladyliberty.bmp' end-declare let #image_length = 8 let #image_height = 6 print 'Look at this picture: ' (+2,{midcol}) print-image signature (+2,{midcol}) image-size= (#image_length, #image_height) let #current_line_adj = #image_height +3 print 'Any Comments?' (+#current_line_adj,{midcol}) But when I am trying to use the same code to print the file to Docutech( Printer Name ) I dont get any image. The code for this is as follows: declare-image signature Type=GIF-FILE Source='/t02/app/psft/ladyliberty.gif/' end-declare OR declare-image signature Type=JPEG-FILE Source='/t02/app/psft/ladyliberty.jpg/' end-declare Ive tried GIF and JPG format and both doesnt work. The file that gets send to the Docutech printer is in .LIS format. Any Suggestions RK --------------------------------- Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --------------------------------- Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 1 12:27:48 2003 Date: Tue, 01 Apr 2003 12:30:16 -0500 From: "Robert K. Foster" Subject: RE: [sqr-users] SQR Coding guidelines I'm also using version 6.2.1. When I use the "Save As" command for a file like header.sqh it will save the file, but will save it as header.sqh.sqr, the .sqr extension is simply not displayed when using file explorer. Since all these files have to be run on a Solaris box eventually such a naming convention is a hassle. For instance, running the SQR report with the above header include will fail if I use #include header.sqh since the file is actually header.sqh.sqr. Bob. sqr-users-request@sqrug.org wrote: > Hi Bob, I'm using Report Builder 6.2.1 and it lets me use #include files > with any file extension I want. What version are you using? Report builder > can only add #include files to the sqr source, it won't create them. > Cheers, Steve. > === Bob Foster I/S Coordinator Mid-Michigan MRI, Inc. Direct Line: (517) 364-2673 mailto:rkf@radiology.msu.edu _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 4 23:39:47 2003 Date: Sat, 05 Apr 2003 14:35:24 +1000 From: Steve Cavill Subject: RE: [sqr-users] SQR Coding guidelines Bob, you're quite right, that's what I meant when I said it can only add #include files to the sqr source, it won't create them. Saving always adds *.sqr. Yeah Brio should change it, but I doubt they will, Report Builder is not a high priority product. However, if you do use report builder to save the file, you can rename it in Windows explorer by displaying the full file names (uncheck the option in Windows explorer that says "hide file extensions for known file types). Save it in Report Builder as xxx.sqr, then rename it to xxx.sqh. A hassle yes, but it will get the job done. Cheers, Steve. -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Robert K. Foster Sent: Wednesday, 2 April 2003 3:30 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] SQR Coding guidelines I'm also using version 6.2.1. When I use the "Save As" command for a file like header.sqh it will save the file, but will save it as header.sqh.sqr, the .sqr extension is simply not displayed when using file explorer. Since all these files have to be run on a Solaris box eventually such a naming convention is a hassle. For instance, running the SQR report with the above header include will fail if I use #include header.sqh since the file is actually header.sqh.sqr. Bob. sqr-users-request@sqrug.org wrote: > Hi Bob, I'm using Report Builder 6.2.1 and it lets me use #include files > with any file extension I want. What version are you using? Report builder > can only add #include files to the sqr source, it won't create them. > Cheers, Steve. > === Bob Foster I/S Coordinator Mid-Michigan MRI, Inc. Direct Line: (517) 364-2673 mailto:rkf@radiology.msu.edu _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Sat Apr 5 07:04:11 2003 From: "David Brawner" Subject: RE: [sqr-users] SQR Coding guidelines Date: Sat, 5 Apr 2003 07:01:20 -0500 open the .sqr in a text editor and "save as" anything you like... Actually I prefer to code in a text editor like TextPad anyway. I can easily run the report form within the editor for previews and have allot more control over the code. Dave -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Steve Cavill Sent: Friday, April 04, 2003 11:35 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] SQR Coding guidelines Bob, you're quite right, that's what I meant when I said it can only add #include files to the sqr source, it won't create them. Saving always adds *.sqr. Yeah Brio should change it, but I doubt they will, Report Builder is not a high priority product. However, if you do use report builder to save the file, you can rename it in Windows explorer by displaying the full file names (uncheck the option in Windows explorer that says "hide file extensions for known file types). Save it in Report Builder as xxx.sqr, then rename it to xxx.sqh. A hassle yes, but it will get the job done. Cheers, Steve. -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Robert K. Foster Sent: Wednesday, 2 April 2003 3:30 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] SQR Coding guidelines I'm also using version 6.2.1. When I use the "Save As" command for a file like header.sqh it will save the file, but will save it as header.sqh.sqr, the .sqr extension is simply not displayed when using file explorer. Since all these files have to be run on a Solaris box eventually such a naming convention is a hassle. For instance, running the SQR report with the above header include will fail if I use #include header.sqh since the file is actually header.sqh.sqr. Bob. sqr-users-request@sqrug.org wrote: > Hi Bob, I'm using Report Builder 6.2.1 and it lets me use #include files > with any file extension I want. What version are you using? Report builder > can only add #include files to the sqr source, it won't create them. > Cheers, Steve. > === Bob Foster I/S Coordinator Mid-Michigan MRI, Inc. Direct Line: (517) 364-2673 mailto:rkf@radiology.msu.edu _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 1 13:43:14 2003 Date: Tue, 01 Apr 2003 13:29:48 -0500 From: Dan Vega Subject: [sqr-users] Wrapdepth Error Message Hi everyone, How is wrapdepth() working for you these days? It is driving me nuts. This statement produces the following error message: let #depth = wrapdepth($description, 44, 1, '', '') (SQR 3405) The value for 'wrapdepth width' (0) must be > 0. This statements works and gives the correct results: let #depth = wrapdepth($description, to_number(to_char(44)), to_number(to_char(1)), '', '') I'm sure you can imagine the amount of time I've wasted figuring this out. Has this happened to anyone else? I've seen a few references to this error message in sqr-users archive on sqrug.org, but nothing recent and nothing with a definitive solution. I tried *many* other combinations of variables, functions and expressions for the width and height arguments before I stumbled onto this work-around. Who can I bill for all this time?? I'm using SQR for PeopleSoft/8.41/PC/Windows NT 4.0/ODBC Level 2/Jun 25 2002, which is equivalent to V6.something, no? Thanks -- Dan _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Apr 2 10:47:09 2003 From: Scott.Munson@Metavante.com Date: Wed, 2 Apr 2003 09:45:29 -0600 Subject: [sqr-users] Examples of Delivered SQR Reports Location I know PeopleSoft has zip files containing examples of delivered reports but I can't seem to find them in any of the directories. Does anyone know the location? I found them last year, but have a terrible memory. For example, I know one of the file names is 'fglrcom800.zip' and contains GL report outputs. Thanks, Scott Munson PeopleSoft Billing Team _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Apr 2 10:55:07 2003 Date: Wed, 02 Apr 2003 09:51:39 -0500 From: "Arnold Foelster" Subject: Re: [sqr-users] Examples of Delivered SQR Reports Location there in the peoplebooks directories Scott.Munson@Metavante.com wrote: > > I know PeopleSoft has zip files containing examples of delivered reports > but I can't seem to find them in any of the directories. Does anyone know > the location? I found them last year, but have a terrible memory. > > For example, I know one of the file names is 'fglrcom800.zip' and contains > GL report outputs. > > Thanks, > > Scott Munson > PeopleSoft Billing Team > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Apr 2 11:05:05 2003 Date: Wed, 2 Apr 2003 18:04:05 +0200 (CEST) From: =?iso-8859-1?q?Christophe=20CHOUX?= Subject: Re: [sqr-users] Examples of Delivered SQR Reports Location in which version of PS are you ? Scott.Munson@Metavante.com wrote:I know PeopleSoft has zip files containing examples of delivered reports but I can't seem to find them in any of the directories. Does anyone know the location? I found them last year, but have a terrible memory. For example, I know one of the file names is 'fglrcom800.zip' and contains GL report outputs. Thanks, Scott Munson PeopleSoft Billing Team _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users --------------------------------- Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Testez le nouveau Yahoo! Mail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Apr 2 11:30:10 2003 From: Scott.Munson@Metavante.com Date: Wed, 2 Apr 2003 10:30:41 -0600 Subject: [sqr-users] Re: Examples of Delivered SQR Reports Location Found them in PeopleBooks. They were PDF files, not ZIP. Thanks for the help. Scott Munson PeopleSoft Billing Team _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Apr 2 13:40:14 2003 From: "Jacqueline Smith" Date: Wed, 2 Apr 2003 13:37:03 -0500 Subject: [sqr-users] SQR-HELP HELLO ANYONE: Could you please tell me how to go about creating an array for a flat file that contains has repeating fields on a single record that has to be updated into one field on the database? Thanks for your help. Jacquelin Smith Telephone 631-4545 Code IH PeopleSoft ***************************defiant************************************ This email and any files transmitted with it are intended solely for the use of the individual or agency to whom they are addressed. If you have received this email in error please notify the Navy Exchange Service Command e-mail administrator. This footnote also confirms that this email message has been scanned for the presence of computer viruses. messaging_support_team@nexnet.navy.mil ********************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Apr 2 15:08:04 2003 From: "M S Bugge" Subject: Re: [sqr-users] SQR-HELP Date: Wed, 2 Apr 2003 15:06:24 -0500 Every time you read the flatfile call this array and here it goes. Create-Array NAME=Budget_Array SIZE=1 FIELD=period:number:15 begin-procedure Load-Array let #period = #period1 put #period Into Budget_Array (0) period (1) let #period = #period2 put #period Into Budget_Array (0) period (2) let #period = #period3 put #period Into Budget_Array (0) period (3) let #period = #period4 put #period Into Budget_Array (0) period (4) let #period = #period5 put #period Into Budget_Array (0) period (5) let #period = #period6 put #period Into Budget_Array (0) period (6) let #period = #period7 put #period Into Budget_Array (0) period (7) let #period = #period8 put #period Into Budget_Array (0) period (8) let #period = #period9 put #period Into Budget_Array (0) period (9) let #period = #period10 put #period Into Budget_Array (0) period (10) let #period = #period11 put #period Into Budget_Array (0) period (11) let #period = #period12 put #period Into Budget_Array (0) period (12) let #period = #period13 put #period Into Budget_Array (0) period (13) let #period = #period14 put #period Into Budget_Array (0) period (14) end-procedure Thanks Bugge ----- Original Message ----- From: "Jacqueline Smith" To: Sent: Wednesday, April 02, 2003 1:37 PM Subject: [sqr-users] SQR-HELP > > HELLO ANYONE: > > Could you please tell me how to go about creating an array for a > flat file that contains has repeating fields on a single record that has to > be updated into one field on the database? Thanks for your help. > > > Jacquelin Smith > Telephone 631-4545 > Code IH PeopleSoft > > > > > ***************************defiant************************************ > This email and any files transmitted with it are intended solely for > the use of the individual or agency to whom they are addressed. If > you have received this email in error please notify the Navy Exchange > Service Command e-mail administrator. > > This footnote also confirms that this email message has been scanned > for the presence of computer viruses. > > messaging_support_team@nexnet.navy.mil > ********************************************************************** > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 4 02:34:36 2003 From: "jessdb" Date: Fri, 04 Apr 2003 15:20:17 +0800 Subject: [sqr-users] print date - date-format Hello... Good day. Every time I run my report which has the format below, the output also shows time. Connected using 'SQR ODBC for Oracle' Oracle 73... Win98. What should I do? I want to print an output like this 'dd-Mon-yyyy'. Please help. to_date(to_char(inventory.lastissuedate,'dd-mon-yyyy'),'DD-MON-YYYY') &lastissue [output] Nov 19 1999 12:00AM Thanks, Jess ____________________________________________________________________ ** Get your free E-Mail account at WWW.DIGITELONE.COM ** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 4 06:58:11 2003 From: "David Brawner" Subject: RE: [sqr-users] print date - date-format Date: Fri, 4 Apr 2003 06:54:52 -0500 Is your date stored in a character field, or a date field. Your code converts a date to a character then back to a date??? Why not just, datetostr(inventory.lastissuedate, 'dd-Mon-yyyy') &lastissue It also seems like your mixing syntax from PL/SQL. I didn't know SQR had a "to_date" function. Dave -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of jessdb Sent: Friday, April 04, 2003 2:20 AM To: sqr-users@sqrug.org Subject: [sqr-users] print date - date-format Hello... Good day. Every time I run my report which has the format below, the output also shows time. Connected using 'SQR ODBC for Oracle' Oracle 73... Win98. What should I do? I want to print an output like this 'dd-Mon-yyyy'. Please help. to_date(to_char(inventory.lastissuedate,'dd-mon-yyyy'),'DD-MON-YYYY') &lastissue [output] Nov 19 1999 12:00AM Thanks, Jess ____________________________________________________________________ ** Get your free E-Mail account at WWW.DIGITELONE.COM ** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 4 09:00:47 2003 Subject: RE: [sqr-users] print date - date-format Date: Fri, 4 Apr 2003 07:58:02 -0600 From: "Thornton, Robert" It looks like your date setting in the report is set to 'Mon DD YYYY HH:MIAM' either reset that variable as below: begin-sql alter session set nls_date_format = 'DD-Mon-YYYY' end-sql Or put an edit mask on the output as below: inventory.lastissuedate &lastissue edit 'DD-MON-YYYY' hope that helps Rob -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of David Brawner Sent: Friday, April 04, 2003 5:55 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] print date - date-format Is your date stored in a character field, or a date field. Your code converts a date to a character then back to a date??? Why not just, datetostr(inventory.lastissuedate, 'dd-Mon-yyyy') &lastissue It also seems like your mixing syntax from PL/SQL. I didn't know SQR had a "to_date" function. Dave -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of jessdb Sent: Friday, April 04, 2003 2:20 AM To: sqr-users@sqrug.org Subject: [sqr-users] print date - date-format Hello... Good day. Every time I run my report which has the format below, the output also shows time. Connected using 'SQR ODBC for Oracle' Oracle 73... Win98. What should I do? I want to print an output like this 'dd-Mon-yyyy'. Please help. to_date(to_char(inventory.lastissuedate,'dd-mon-yyyy'),'DD-MON-YYYY') &lastissue [output] Nov 19 1999 12:00AM Thanks, Jess ____________________________________________________________________ ** Get your free E-Mail account at WWW.DIGITELONE.COM ** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 4 09:06:06 2003 Date: Fri, 4 Apr 2003 09:05:17 -0500 From: "White, Denise" Subject: [sqr-users] RE: print date - date-format Hi Jess, Try: to_char(inventory.lastissuedate,'dd-mon-yyyy') &lastissue By nesting the functions, you are first converting the date into the format you want (to_char), but then you are converting it back into its original date format (to_date). Denise M. White Sr. Software Engineer Vicor --__--__-- Message: 1 From: "jessdb" To: sqr-users@sqrug.org Date: Fri, 04 Apr 2003 15:20:17 +0800 Subject: [sqr-users] print date - date-format Reply-To: sqr-users@sqrug.org Hello... Good day. Every time I run my report which has the format below, the output also shows time. Connected using 'SQR ODBC for Oracle' Oracle 73... Win98. What should I do? I want to print an output like this 'dd-Mon-yyyy'. Please help. to_date(to_char(inventory.lastissuedate,'dd-mon-yyyy'),'DD-MON-YYYY') &lastissue [output] Nov 19 1999 12:00AM Thanks, Jess _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 4 15:55:23 2003 Date: Fri, 4 Apr 2003 12:53:22 -0800 (PST) From: D Patel Subject: [sqr-users] Pie-Chart Help Hi All, I am trying to generate Pie-Chart in one off my report. Business requirement is Pie-Chart should start with 12 o'Clock position, whereas in SQR reports by default Pie-chart starts with 3 o'clock position. I tried to search in archived messages, but I couldn't. Thanks in advance, D Patel __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 4 17:38:12 2003 Date: Fri, 4 Apr 2003 14:37:00 -0800 (PST) From: D Patel Subject: [sqr-users] Pie-Chart Help: More Hi All, I am trying to generate Pie-Chart in one off my report. Business requirement is Pie-Chart should start with 12 o'Clock position, whereas in SQR reports by default Pie-chart starts with 3 o'clock position. I tried to search in archived messages, but I couldn't. Another thing I have to display pre-defined colors in the pie-chart sections. I tried this using Create-Color-Palette Name='LocalChartColor' Color_1=('blue') Color_2=('orange') Color_3=('black') Color_4=(255,128,0) Color_5=(0,0,255) Color_6=(0,255,128) Color_7=(255,128,0) Color_8=(0,0,255) Color_9=(0,255,128) and used the same in Print-Chart: Color-Palette='LocalChartColor' I couldn't find any difference. Please point me, where am I doing mistake? Thanks in advance, D Patel __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 7 06:48:36 2003 From: "Robin Ferebee" Date: Mon, 7 Apr 2003 07:36:52 -0400 Subject: [sqr-users] help Good morning. I am attempting to delete a row on a level 1 scroll. I begin by referencing my level 0 scroll and traversing down. When I identify the row, I call the DeleteRow function. All the data is removed except for the two date fields which are on two different tabs. When I query the database all the data is removed except for the emplid and the dates. I have customized the Purge Date field to clear all fields for that row when a Purge Date is entered. [Administer Workforce ==>Manage Labor Relations(GBL) ==>Use ==>Disciplinary Action ] I am including some of the code I created to try and delete the row automatically. For &J = 1 To &LINE_ROWSET.RowCount &LINE_REC = &LINE_ROWSET(&J).DISCIPLIN_ACTN; &LINE_SUM = &LINE_REC.DISCIPLINARY_TYPE.Value; If &LINE_SUM = " " Then DeleteRow(Record.DISCIPLIN_ACTN, 1, Record.DISCIPLIN_STEP, &J); &G_CLEAR = "N"; If RecordDeleted(Record.DISCIPLIN_ACTN, 1, Record.DISCIPLIN_STEP, &J) Then WinMessage(MsgGet(20000, 203, "A row has been deleted.")); End-If; End-If; End-For; Thanks. Robin S. Ferebee PeopleSoft Group Navy Exchange Service Command (757) 631-3347 ***************************defiant************************************ This email and any files transmitted with it are intended solely for the use of the individual or agency to whom they are addressed. If you have received this email in error please notify the Navy Exchange Service Command e-mail administrator. This footnote also confirms that this email message has been scanned for the presence of computer viruses. messaging_support_team@nexnet.navy.mil ********************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 7 06:58:13 2003 Date: Mon, 07 Apr 2003 07:56:49 -0400 From: "Larry Roux" Subject: Re: [sqr-users] help The SQR Users group is probably not the best place for this as not all SQR users are PeopleSoft users. However, you might want to check the field defaults and PeopleCode to see if those fields have default values that are repopulating the data. ****************************** Larry Roux Syracuse University lroux@syr.edu ******************************* >>> Robin_Ferebee@nexnet.navy.mil 04/07/03 07:52 AM >>> Good morning. I am attempting to delete a row on a level 1 scroll. I begin by referencing my level 0 scroll and traversing down. When I identify the row, I call the DeleteRow function. All the data is removed except for the two date fields which are on two different tabs. When I query the database all the data is removed except for the emplid and the dates. I have customized the Purge Date field to clear all fields for that row when a Purge Date is entered. [Administer Workforce ==>Manage Labor Relations(GBL) ==>Use ==>Disciplinary Action ] I am including some of the code I created to try and delete the row automatically. For &J = 1 To &LINE_ROWSET.RowCount &LINE_REC = &LINE_ROWSET(&J).DISCIPLIN_ACTN; &LINE_SUM = &LINE_REC.DISCIPLINARY_TYPE.Value; If &LINE_SUM = " " Then DeleteRow(Record.DISCIPLIN_ACTN, 1, Record.DISCIPLIN_STEP, &J); &G_CLEAR = "N"; If RecordDeleted(Record.DISCIPLIN_ACTN, 1, Record.DISCIPLIN_STEP, &J) Then WinMessage(MsgGet(20000, 203, "A row has been deleted.")); End-If; End-If; End-For; Thanks. Robin S. Ferebee PeopleSoft Group Navy Exchange Service Command (757) 631-3347 ***************************defiant************************************ This email and any files transmitted with it are intended solely for the use of the individual or agency to whom they are addressed. If you have received this email in error please notify the Navy Exchange Service Command e-mail administrator. This footnote also confirms that this email message has been scanned for the presence of computer viruses. messaging_support_team@nexnet.navy.mil ********************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 7 10:44:25 2003 From: Nathan Stratton Treadway Date: Mon, 7 Apr 2003 10:42:12 -0500 Subject: [sqr-users] Re: help -- PeopleCode record deletion On Mon, Apr 07, 2003 at 07:36:52AM -0400, Robin Ferebee wrote: > Good morning. I am attempting to delete a row on a level 1 scroll. I > begin by referencing my level 0 scroll and traversing down. When I > identify the row, I call the DeleteRow function. All the data is removed > except for the two date fields which are on two different tabs. When I > query the database all the data is removed except for the emplid and the > dates. I have customized the Purge Date field to clear all fields for that > row when a Purge Date is entered. This question is specific to PeopleCode, not SQR. You'll probably have better luck if you ask it on a PeopleSoft-specific list, e.g. http://groups.yahoo.com/group/peoplesoft-fans/ Good luck. Nathan ---------------------------------------------------------------------------- Nathan Stratton Treadway | nathanst@ontko.com | Mid-Atlantic region Software consulting services | Ray Ontko & Co. | http://www.ontko.com/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 7 13:33:22 2003 From: "Turner, Ivan" Subject: RE: [sqr-users] help Date: Mon, 7 Apr 2003 12:32:00 -0600 Robin, Do the fields default? -----Original Message----- From: Larry Roux [mailto:lroux@syr.edu] Sent: Monday, April 07, 2003 7:57 AM To: sqr-users@sqrug.org Subject: Re: [sqr-users] help The SQR Users group is probably not the best place for this as not all SQR users are PeopleSoft users. However, you might want to check the field defaults and PeopleCode to see if those fields have default values that are repopulating the data. ****************************** Larry Roux Syracuse University lroux@syr.edu ******************************* >>> Robin_Ferebee@nexnet.navy.mil 04/07/03 07:52 AM >>> Good morning. I am attempting to delete a row on a level 1 scroll. I begin by referencing my level 0 scroll and traversing down. When I identify the row, I call the DeleteRow function. All the data is removed except for the two date fields which are on two different tabs. When I query the database all the data is removed except for the emplid and the dates. I have customized the Purge Date field to clear all fields for that row when a Purge Date is entered. [Administer Workforce ==>Manage Labor Relations(GBL) ==>Use ==>Disciplinary Action ] I am including some of the code I created to try and delete the row automatically. For &J = 1 To &LINE_ROWSET.RowCount &LINE_REC = &LINE_ROWSET(&J).DISCIPLIN_ACTN; &LINE_SUM = &LINE_REC.DISCIPLINARY_TYPE.Value; If &LINE_SUM = " " Then DeleteRow(Record.DISCIPLIN_ACTN, 1, Record.DISCIPLIN_STEP, &J); &G_CLEAR = "N"; If RecordDeleted(Record.DISCIPLIN_ACTN, 1, Record.DISCIPLIN_STEP, &J) Then WinMessage(MsgGet(20000, 203, "A row has been deleted.")); End-If; End-If; End-For; Thanks. Robin S. Ferebee PeopleSoft Group Navy Exchange Service Command (757) 631-3347 ***************************defiant************************************ This email and any files transmitted with it are intended solely for the use of the individual or agency to whom they are addressed. If you have received this email in error please notify the Navy Exchange Service Command e-mail administrator. This footnote also confirms that this email message has been scanned for the presence of computer viruses. messaging_support_team@nexnet.navy.mil ********************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 7 14:40:10 2003 Date: Mon, 7 Apr 2003 12:37:55 -0700 (PDT) From: D Patel Subject: [sqr-users] Pie-Chart Help [Second attempt] Hi All, Thanks in advance. I am trying to generate Pie-Chart in one off my report. Business requirement is Pie-Chart should start with 12 o'Clock position, whereas in SQR reports by default Pie-chart starts with 3 o'clock position. I tried to search in archived messages, but I couldn't. Wheather this is possible or not? If yes how can I change that? Another thing I have to display pre-defined colors in the pie-chart sections. I tried this using Create-Color-Palette Name='LocalChartColor' Color_1=('blue') Color_2=('orange') Color_3=('black') Color_4=(255,128,0) Color_5=(0,0,255) Color_6=(0,255,128) Color_7=(255,128,0) Color_8=(0,0,255) Color_9=(0,255,128) and used the same in Print-Chart: Color-Palette='LocalChartColor' I couldn't find any difference. Please point me, where am I doing mistake? Thanks in advance, D Patel __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 01:54:10 2003 Date: Tue, 8 Apr 2003 16:52:06 +1000 From: "Devinder Singh Kunwar (STP)" Subject: [sqr-users] SQR problem Hi, I am facing a problem with load look up. While retrieving values from the Lookup table i encountered problems due to division of 1 by 13251 . When the division occurs resultant is 0.000075466002565844087238698966115764847936. The first character variable used (printing, display etc) after the division is getting initialized with the value 7936. If a show 'HELP' is given after the Lookup command , the job on running doesn't show "HELP" but shows 7936. This could be due to some memory leakage. *** This problem is occurring when Oracle8 Enterprise Edition Release 8.0.5.2.2 SQR Version - 4.3.4 HP-UX Release - 10.20 *** The same thing works fine for Oracle8 Enterprise Edition Release 8.0.6.0.0 SQR Version - 4.3.4 HP-UX Release - 11.00 Could anyone please help. Regards, Devinder ---------------------------------------------------------------------------------------------------------------------- This e-mail and any attachments to it (the "Communication") is confidential and is for the use only of the intended recipient. The Communication may contain copyright material of Australia and New Zealand Banking Group Limited ABN 11 005 357 522 ("ANZ"), of any of its related entities or of third parties. If you are not the intended recipient of the Communication, please notify the sender immediately by return e-mail, delete the Communication, and do not read, copy, print, retransmit, store or act in reliance on the Communication. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of ANZ. ANZ does not guarantee the integrity of the Communication, or that it is free from errors, viruses or interference. ------------------------------------------------------------------------------ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 04:50:19 2003 From: "Steve Cavill" Subject: RE: [sqr-users] SQR problem Date: Tue, 8 Apr 2003 19:47:55 +1000 Hi Devinder, That looks very odd. As it only occurs in one specific version it is probably a bug. The first thing I would try would be to relink the SQR executable, as per the installation instructions which should be on the CD. What did Brio technical support say? Steve. -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Devinder Singh Kunwar (STP) Sent: Tuesday, 8 April 2003 4:52 PM To: sqr-users@sqrug.org Subject: [sqr-users] SQR problem Importance: High Hi, I am facing a problem with load look up. While retrieving values from the Lookup table i encountered problems due to division of 1 by 13251 . When the division occurs resultant is 0.000075466002565844087238698966115764847936. The first character variable used (printing, display etc) after the division is getting initialized with the value 7936. If a show 'HELP' is given after the Lookup command , the job on running doesn't show "HELP" but shows 7936. This could be due to some memory leakage. *** This problem is occurring when Oracle8 Enterprise Edition Release 8.0.5.2.2 SQR Version - 4.3.4 HP-UX Release - 10.20 *** The same thing works fine for Oracle8 Enterprise Edition Release 8.0.6.0.0 SQR Version - 4.3.4 HP-UX Release - 11.00 Could anyone please help. Regards, Devinder ---------------------------------------------------------------------------- ------------------------------------------ This e-mail and any attachments to it (the "Communication") is confidential and is for the use only of the intended recipient. The Communication may contain copyright material of Australia and New Zealand Banking Group Limited ABN 11 005 357 522 ("ANZ"), of any of its related entities or of third parties. If you are not the intended recipient of the Communication, please notify the sender immediately by return e-mail, delete the Communication, and do not read, copy, print, retransmit, store or act in reliance on the Communication. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of ANZ. ANZ does not guarantee the integrity of the Communication, or that it is free from errors, viruses or interference. ---------------------------------------------------------------------------- -- _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 07:23:29 2003 From: "Robin Ferebee" Date: Tue, 8 Apr 2003 08:20:14 -0400 Subject: [sqr-users] (no subject) Yes the date fields do default to the system date. Thanks. Robin S. Ferebee PeopleSoft Group Navy Exchange Service Command (757) 631-3347 ***************************defiant************************************ This email and any files transmitted with it are intended solely for the use of the individual or agency to whom they are addressed. If you have received this email in error please notify the Navy Exchange Service Command e-mail administrator. This footnote also confirms that this email message has been scanned for the presence of computer viruses. messaging_support_team@nexnet.navy.mil ********************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 09:58:12 2003 From: "Ben Anderson" Date: Tue, 08 Apr 2003 10:57:19 -0400 Subject: [sqr-users] round I want to either do integer divide or round: let #i = 8/7 !I want this to be 1 let #i = 7/7 !I want this to be 1 let #i = 6/7 !I want this to be 0 I've been getting the decimal values and I want the integer. If I need to put steps in between, that's fine. Thanks, Ben Anderson _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 10:05:07 2003 From: Bill Beckner Subject: RE: [sqr-users] round Date: Tue, 8 Apr 2003 10:04:35 -0500 You could use the "trunc" function. For example: let i = trunc(8/7, 0) -----Original Message----- From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] Sent: Tuesday, April 08, 2003 9:57 AM To: sqr-users@sqrug.org Subject: [sqr-users] round I want to either do integer divide or round: let #i = 8/7 !I want this to be 1 let #i = 7/7 !I want this to be 1 let #i = 6/7 !I want this to be 0 I've been getting the decimal values and I want the integer. If I need to put steps in between, that's fine. Thanks, Ben Anderson _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 10:08:05 2003 Subject: Re: [sqr-users] round From: Rick_Creel@aoncons.com Date: Tue, 8 Apr 2003 11:07:15 -0400 If you declare the #i variable to be an integer, it should work. Here is some test code I ran: !************************************ begin-setup declare-variable integer #num_value end-declare end-setup begin-program let #num_value = 8 / 7 show '8 / 7 = ' #num_value let #num_value = 7 / 7 show '7 / 7 = ' #num_value let #num_value = 6 / 7 show '6 / 7 = ' #num_value end-program !************************************ The results were: 8 / 7 = 1 7 / 7 = 1 6 / 7 = 0 SQR: End of Run. "Ben Anderson" cc: Sent by: Subject: [sqr-users] round sqr-users-admin@s qrug.org 04/08/2003 10:57 AM Please respond to sqr-users I want to either do integer divide or round: let #i = 8/7 !I want this to be 1 let #i = 7/7 !I want this to be 1 let #i = 6/7 !I want this to be 0 I've been getting the decimal values and I want the integer. If I need to put steps in between, that's fine. Thanks, Ben Anderson _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 11:17:25 2003 From: "Hood Louise (app1lxh)" Date: Tue, 8 Apr 2003 12:14:49 -0400 Subject: [sqr-users] TEMPORARY TABLES Hi All, Has anyone had any experience (or luck) with creating temporary tables that are unique for each user running a report? I have an sqr in which a temporary table is created in the setup section. Within the program, calculations are performed and results stored in the table for later selection and manipulation. The sqr works fine as long as someone else doesn't try to generate the report while another user has already kicked the program off (the table is already in use and not accessible since it doesn't have a unique name). We are using Oracle 8i and sqr 6.0. I searched the sqrug archives, finding references to CREATE GLOBAL TEMPORARY TABLE, which I also tried without success. It was referred to in a response for DB2 environment, so maybe Oracle doesn't recognize this? There is virtually nothing in the SQR reference manuals and user guide re: temp tables, so if anyone has been there before and conquered this problem, I'd appreciate your input. Thanks, Louise _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 11:33:07 2003 Date: Tue, 08 Apr 2003 12:31:39 -0400 From: "George Jansen" Subject: Re: [sqr-users] TEMPORARY TABLES GLOBAL TEMPORARY tables should work fine; however you should know that a. "GLOBAL" is something of a misnomer; they exist, like other objects, within schemas. You can, however, create public synonyms for them. b. The default for Oracle's GTTs is "ON COMMIT DELETE ROWS", which means that if along the way you happen to commit a transaction you've emptied the table. You must specify "ON COMMIT PRESERVE ROWS" if the data is to persist through transactions. c. One session cannot see another's information in such a table. Doesn't matter whether the username is the same or not, it just can't see it, which is what you want. d. The data goes away when the session ends, which is also what you want. e. You can't use them in distributed transactions. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 11:36:05 2003 Subject: RE: [sqr-users] TEMPORARY TABLES Date: Tue, 8 Apr 2003 10:32:11 -0600 From: "Torres, Jennifer" Louise, We have handled this in a couple of ways: 1- We create unique temporary tables for each execution of the sqr. For example the table is appended with unique value such as username or date/time. The table name is then created in the sqr and referenced with [$table_name] in sql statements. 2- We have used one temporary table for all sqr user executions. Enabled by adding columns to the table to identify the unique users (ie USERNAME). Sql statements then use the USERNAME to reference only rows related to that specific sqr execution. Hope that helps. -----Original Message----- From: Hood Louise (app1lxh) [mailto:app1lxh@ups.com] Sent: Tuesday, April 08, 2003 10:15 AM To: sqr-users@sqrug.org Subject: [sqr-users] TEMPORARY TABLES Hi All, Has anyone had any experience (or luck) with creating temporary tables that are unique for each user running a report? I have an sqr in which a temporary table is created in the setup section. Within the program, calculations are performed and results stored in the table for later selection and manipulation. The sqr works fine as long as someone else doesn't try to generate the report while another user has already kicked the program off (the table is already in use and not accessible since it doesn't have a unique name). We are using Oracle 8i and sqr 6.0. I searched the sqrug archives, finding references to CREATE GLOBAL TEMPORARY TABLE, which I also tried without success. It was referred to in a response for DB2 environment, so maybe Oracle doesn't recognize this? There is virtually nothing in the SQR reference manuals and user guide re: temp tables, so if anyone has been there before and conquered this problem, I'd appreciate your input. Thanks, Louise _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 11:52:09 2003 Date: Tue, 08 Apr 2003 11:51:22 -0500 From: "Lock, Edward J" Subject: RE: [sqr-users] TEMPORARY TABLES This works in Oracle 8i: !test sql----------------------------------- CREATE global temporary TABLE test2 (ord_id NUMBER(3), ord_date DATE, cust_code VARCHAR2(3), date_of_delay DATE) !------------------------------------------- By default, it puts it in the system tablespace, but this can be changed. --Edward Lock -----Original Message----- From: Hood Louise (app1lxh) [mailto:app1lxh@ups.com] Sent: Tuesday, April 08, 2003 11:15 AM To: sqr-users@sqrug.org Subject: [sqr-users] TEMPORARY TABLES Hi All, Has anyone had any experience (or luck) with creating temporary tables that are unique for each user running a report? I have an sqr in which a temporary table is created in the setup section. Within the program, calculations are performed and results stored in the table for later selection and manipulation. The sqr works fine as long as someone else doesn't try to generate the report while another user has already kicked the program off (the table is already in use and not accessible since it doesn't have a unique name). We are using Oracle 8i and sqr 6.0. I searched the sqrug archives, finding references to CREATE GLOBAL TEMPORARY TABLE, which I also tried without success. It was referred to in a response for DB2 environment, so maybe Oracle doesn't recognize this? There is virtually nothing in the SQR reference manuals and user guide re: temp tables, so if anyone has been there before and conquered this problem, I'd appreciate your input. Thanks, Louise _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 12:26:14 2003 Subject: Re: [sqr-users] TEMPORARY TABLES From: "Jerry Coleman" Date: Tue, 8 Apr 2003 13:25:42 -0400 I assume this is a PeopleSoft app, right? Consider adding a column containing $prcs_process_instance to the table, then delete rows pertaining to the process instance at the end of the SQR. |---------+----------------------------> | | "Hood Louise | | | (app1lxh)" | | | | | | Sent by: | | | sqr-users-admin@s| | | qrug.org | | | | | | | | | 04/08/03 12:14 PM| | | Please respond to| | | sqr-users | | | | |---------+----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: sqr-users@sqrug.org | | cc: | | Subject: [sqr-users] TEMPORARY TABLES | >--------------------------------------------------------------------------------------------------------------| Hi All, Has anyone had any experience (or luck) with creating temporary tables that are unique for each user running a report? I have an sqr in which a temporary table is created in the setup section. Within the program, calculations are performed and results stored in the table for later selection and manipulation. The sqr works fine as long as someone else doesn't try to generate the report while another user has already kicked the program off (the table is already in use and not accessible since it doesn't have a unique name). We are using Oracle 8i and sqr 6.0. I searched the sqrug archives, finding references to CREATE GLOBAL TEMPORARY TABLE, which I also tried without success. It was referred to in a response for DB2 environment, so maybe Oracle doesn't recognize this? There is virtually nothing in the SQR reference manuals and user guide re: temp tables, so if anyone has been there before and conquered this problem, I'd appreciate your input. Thanks, Louise _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 12:53:14 2003 Date: Tue, 08 Apr 2003 13:52:29 -0400 From: Christine Sessler Subject: Re: [sqr-users] TEMPORARY TABLES Louise - Been there, struggled with that as we moved from Informix (temp tables on the fly) to Oracle. Our process is working pretty well for us. The one thing that we have found is that you must remember that if you change the temp table structure, the SQR will NOT auto-build it if it already exists. In DEV, we've gotten around this by putting a DROP TABLE statement into the SQR. Also, as you migrate your SQRs through instances and build new instances, check to see if those temp tables already exist. I'd suggest dropping them as you move from instance to instance. This was made easier for us by our naming convention. Here's what we did (a snippit of our whys and how tos). Using Temp Tables in SQRs in Oracle In the Oracle environment, temporary table structures do not automatically disappear, but the data does. The approach to addressing this need will be to create the temporary table within the SQR, but only if the table does not already exist. The following outlines the steps for remediation and maintenance of temporary table usage in Oracle. Because the structure of the table will continue to exist after the program completes processing, names of all temporary tables must begin with CU_GT_(program name)_(table name) to allow easy recognition of them. Ensure that all temporary table creations are performed in the BEGIN-SETUP procedure. Only execute the CREATE statement if the temporary table does not exist, by checking for its existence in the ALL_TABLES table and executing the CREATE statement only if it does not. In CREATE statements use the GLOBAL TEMPORARY syntax with the ON COMMIT PRESERVE ROWS (to handle programs that may perform intermittent commits) clause. Indexes must be created on temporary tables while they are empty; therefore, CREATE INDEX statements must be executed right after the CREATE table statement within the conditional statement. Begin-Setup Begin-SQL DECLARE t_count NUMBER;; BEGIN SELECT count(*) INTO t_count FROM all_tables WHERE table_name = 'CU_GT_PAY604CU_FUT_PAY_CAL';; if t_count = 0 THEN EXECUTE IMMEDIATE CREATE GLOBAL TEMPORARY TABLE CU_GT_PAY604CU_FUT_PAY_CAL (fpc_company char(3), fpc_paygroup char(3), fpc_pay_end_dt char(11), fpc_pay_begin_dt char(11), fpc_working_days number) ON COMMIT PRESERVE ROWS;; EXECUTE IMMEDIATE CREATE INDEX &;; END IF;; END;; End-SQL End-Setup Maintenance Because the structure of a temporary table will continue to exist after the program completes processing, changes to the structure will require a request to the DBAs to drop the table before you can run the changed program. Work Units created to migrate program changes that include temporary table structure changes must include a SQL file containing any DROP statements for the changed temporary tables. Let me know if you have any questions, Chris At 12:14 PM 4/8/2003 -0400, you wrote: >Hi All, > >Has anyone had any experience (or luck) with creating temporary tables that >are unique for each user running a report? I have an sqr in which a >temporary table is created in the setup section. Within the program, >calculations are performed and results stored in the table for later >selection and manipulation. The sqr works fine as long as someone else >doesn't try to generate the report while another user has already kicked the >program off (the table is already in use and not accessible since it doesn't >have a unique name). > >We are using Oracle 8i and sqr 6.0. > >I searched the sqrug archives, finding references to CREATE GLOBAL TEMPORARY >TABLE, which I also tried without success. It was referred to in a response >for DB2 environment, so maybe Oracle doesn't recognize this? > >There is virtually nothing in the SQR reference manuals and user guide re: >temp tables, so if anyone has been there before and conquered this problem, >I'd appreciate your input. > >Thanks, >Louise > > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org >http://www.sqrug.org/mailman/listinfo/sqr-users ************************************************************ Christine Sessler Cornell University CIT/Business Information Systems 120 Maple Avenue Ithaca, NY 14850 607.255.8149 - Office 607.255.6982 - Fax cms41@cornell.edu ************************************************************ "If a dog jumps in your lap, it is because he is fond of you; but if a cat does the same thing, it is because your lap is warmer." - Alfred North Whitehead "The only normal people are the ones you don't know very well." - Joe Ancis _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Tue Apr 8 22:52:11 2003 From: Harish_Venkiteswaran@Satyam.com Subject: RE: [sqr-users] TEMPORARY TABLES Date: Wed, 9 Apr 2003 09:16:33 +0530 Hi, Estending what Torres wrote. I presume you are working in peoplesoft Database. You need to create a table which has a process instance and oprid as a key.That way you could get the data based on that particular instance and the oprid that has run the report.Consider the scenarios that 2 user are running the report. Table1 Oprid-Key Process Instance-Key Key1-Key Nonkey1 When 1st user runs the report.The oprid would be updated as User1 and Process Instance - Current Process Instance for that report When 2nd user runs the report .The oprid would be updated as User2 and Process Instance - Current Process Instance for that report. You can code the select for the temporary table as SELECT KEY1,NONKEY1 FROM TABLE1 WHERE OPRID=$USER AND PROCESS_INSTANCE=$PRCSINSTANCE Using a single table you can segregate the data relevant for each user. Regards Harish > --Original Message----- > From: Hood Louise (app1lxh) [SMTP:app1lxh@ups.com] > Sent: Tuesday, April 08, 2003 9:45 PM > To: sqr-users@sqrug.org > Subject: [sqr-users] TEMPORARY TABLES > > Hi All, > > Has anyone had any experience (or luck) with creating temporary tables > that > are unique for each user running a report? I have an sqr in which a > temporary table is created in the setup section. Within the program, > calculations are performed and results stored in the table for later > selection and manipulation. The sqr works fine as long as someone else > doesn't try to generate the report while another user has already kicked > the > program off (the table is already in use and not accessible since it > doesn't > have a unique name). > > We are using Oracle 8i and sqr 6.0. > > I searched the sqrug archives, finding references to CREATE GLOBAL > TEMPORARY > TABLE, which I also tried without success. It was referred to in a > response > for DB2 environment, so maybe Oracle doesn't recognize this? > > There is virtually nothing in the SQR reference manuals and user guide re: > temp tables, so if anyone has been there before and conquered this > problem, > I'd appreciate your input. > > Thanks, > Louise > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users ************************************************************************** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ************************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Apr 9 07:39:10 2003 From: Ray Ontko Date: Wed, 9 Apr 2003 07:38:34 -0500 Subject: [sqr-users] mail loop fixed SQR Users, I modified the user subscription that was causing the e-mail loop this morning. It was caused by an out-of-office auto-reply message that was reponding to its own acknowledgements. Some hints for those of you who ever think about using some sort of Vacation/Out Of Office program -- you should make sure that: 1) It only sends _one_ "on vacation" note back to a given address. Obviously, if this rule is not followed, Bad Things(tm) happen on mailing lists -- and even for more private communication getting more than one "on vacation" note can be irritating to people who are e-mailing you while you are away. 2) It does not send notes in response to "bulk" messages. The sqr-users list (and most other mailing lists) always sends messages with a "Precedence: bulk" header line. A good Vacation program will notice this and avoid sending a response, thus preventing your vacation schedule from being distributed to everyone on the mailing list (as well as being posted on the web in the list archives...). Check with your mail administrator to make sure that you system's Vacation progrom follows these guidelines, and everyone will be a lot happier :) Ray ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Apr 9 07:44:15 2003 From: "Mezzullo, Paul" Date: Wed, 9 Apr 2003 08:48:51 -0400 Subject: [sqr-users] excellent Thanks Ray ... _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Wed Apr 9 16:05:27 2003 Date: Wed, 9 Apr 2003 16:19:45 -0400 From: "White, Denise" Subject: [sqr-users] RE: TEMPORARY TABLES Hi Louise, I have encountered the same problem with multiple users running the same job and having conflicts. To create a unique name for the temporary table, I appended the $prcs_process_instance to the end of the table name, making it dynamic. However, I found that after I did this, I could not create the table in the BEGIN-SETUP procedure, where I had always created temp tables before. I had to create a regular procedure, in which I did the usual drop and then create. Of course, because it was not in BEGIN-SETUP, I couldn't use the special ON-ERROR options (I usually use WARN for the drop), so I had to use my regular ON-ERROR procedure. I also found that using a dynamic table name caused a few other glitches, such as having to qualify numeric columns when selecting from it (ex. "t.amt &t.amt=number"). I can't remember all the specific glitches, so it may take a bit of trial and error on your part. The only real problem to this approach is that every table name is unique, so if there is an abnormal stop to the program, it will not get dropped next time it is run (so I guess that initial drop before the create is really unnecessary). We are on 4.3.4, so this is all assuming that this will still work the same for you. HTH, Denise M. White Sr. Software Engineer Vicor --__--__-- Message: 5 From: "Hood Louise (app1lxh)" To: sqr-users@sqrug.org Date: Tue, 8 Apr 2003 12:14:49 -0400 Subject: [sqr-users] TEMPORARY TABLES Reply-To: sqr-users@sqrug.org Hi All, Has anyone had any experience (or luck) with creating temporary tables that are unique for each user running a report? I have an sqr in which a temporary table is created in the setup section. Within the program, calculations are performed and results stored in the table for later selection and manipulation. The sqr works fine as long as someone else doesn't try to generate the report while another user has already kicked the program off (the table is already in use and not accessible since it doesn't have a unique name). We are using Oracle 8i and sqr 6.0. I searched the sqrug archives, finding references to CREATE GLOBAL TEMPORARY TABLE, which I also tried without success. It was referred to in a response for DB2 environment, so maybe Oracle doesn't recognize this? There is virtually nothing in the SQR reference manuals and user guide re: temp tables, so if anyone has been there before and conquered this problem, I'd appreciate your input. Thanks, Louise _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Thu Apr 10 07:38:04 2003 From: "Hood Louise (app1lxh)" Subject: RE: [sqr-users] RE: TEMPORARY TABLES Date: Wed, 9 Apr 2003 18:06:07 -0400 Denise, Thanks--you've affirmed what I've found out since yesterday (like you said: through trial and error). Thanks to everyone for their suggestions and work-arounds!! What worked for us is getting the create table out of begin-setup (like you described). Now the create table is in the begin-program code stream: begin-program do GetParameters let $currdttm = datetostr(datenow(),'MMDDYYYYHHMISS') DISPLAY '$currdttm = ' NOLINE DISPLAY $currdttm let $TMPTBL = 'SPCRPT'||$userid||$currdttm DISPLAY '$TMPTBL = ' NOLINE DISPLAY $TMPTBL begin-SQL create table [$TMPTBL] (SORT_SVCPVR_NA CHAR(35) NOT NULL, SORT_SVCPVR VARCHAR(10) NOT NULL, SORT_QTR_BEGIN INTEGER NOT NULL, SORT_YTD_REV_PCT DECIMAL(4,1) NOT NULL); end-SQL . . . . end-program Another thing that I found out is that since the table is not in the begin-setup, you can't do DROP TABLE before CREATE TABLE or you get the nasty error message: (SQR 5528) ORACLE OCIStmtExecute error 942 in cursor 1: ORA-00942: table or view does not exist Error on line 149: (SQR 3735) Could not execute SQL. SQR: Program Aborting. (Line 149 in this case is the begin-sql right before DROP TABLE.) Something else that made me think the dynamic name wouldn't work is that I made the unfortunate choice of creating a table name stringing datenow('MMDDYYYYHHMISS') with _TBL. ORACLE apparently does not accept table names beginning with a number. When I created the string as shown in the above code, it works fine. Also, planning for potential interruptions in the SQR processing, the tables get prefixed with SPCRPT. A cleanup script will be run periodically to purge any tables beginning with SPCRPT that get left behind due to the report not completing for whatever reason. The only other problem we encountered was that the PDF file being created did not have a unique name. When we stress tested the SQR and everyone was trying to grab the same PDF file there was an SQR error condition. This was eliminated by prefixing the PDF filename with the $userid, which should virtually remove contention for the same file. Thanks again to the group for all suggestions! Louise -----Original Message----- From: White, Denise [mailto:DEWhite@vicr.com] Sent: Wednesday, April 09, 2003 4:20 PM To: sqr-users@sqrug.org Subject: [sqr-users] RE: TEMPORARY TABLES Hi Louise, I have encountered the same problem with multiple users running the same job and having conflicts. To create a unique name for the temporary table, I appended the $prcs_process_instance to the end of the table name, making it dynamic. However, I found that after I did this, I could not create the table in the BEGIN-SETUP procedure, where I had always created temp tables before. I had to create a regular procedure, in which I did the usual drop and then create. Of course, because it was not in BEGIN-SETUP, I couldn't use the special ON-ERROR options (I usually use WARN for the drop), so I had to use my regular ON-ERROR procedure. I also found that using a dynamic table name caused a few other glitches, such as having to qualify numeric columns when selecting from it (ex. "t.amt &t.amt=number"). I can't remember all the specific glitches, so it may take a bit of trial and error on your part. The only real problem to this approach is that every table name is unique, so ! if there is an abnormal stop to the program, it will not get dropped next time it is run (so I guess that initial drop before the create is really unnecessary). We are on 4.3.4, so this is all assuming that this will still work the same for you. HTH, Denise M. White Sr. Software Engineer Vicor --__--__-- Message: 5 From: "Hood Louise (app1lxh)" To: sqr-users@sqrug.org Date: Tue, 8 Apr 2003 12:14:49 -0400 Subject: [sqr-users] TEMPORARY TABLES Reply-To: sqr-users@sqrug.org Hi All, Has anyone had any experience (or luck) with creating temporary tables that are unique for each user running a report? I have an sqr in which a temporary table is created in the setup section. Within the program, calculations are performed and results stored in the table for later selection and manipulation. The sqr works fine as long as someone else doesn't try to generate the report while another user has already kicked the program off (the table is already in use and not accessible since it doesn't have a unique name). We are using Oracle 8i and sqr 6.0. I searched the sqrug archives, finding references to CREATE GLOBAL TEMPORARY TABLE, which I also tried without success. It was referred to in a response for DB2 environment, so maybe Oracle doesn't recognize this? There is virtually nothing in the SQR reference manuals and user guide re: temp tables, so if anyone has been there before and conquered this problem, I'd appreciate your input. Thanks, Louise _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Thu Apr 10 17:35:30 2003 From: Scott.Munson@Metavante.com Date: Thu, 10 Apr 2003 14:13:42 -0500 Subject: [sqr-users] Page # of # Example Is there an SQC or some standard procedure that can print out "Page # of #"? Currently, all of the reports we have come across only print the current page but the user desires to see the total number of pages, in addition to the current page. Thanks, Scott Munson PeopleSoft Billing Team _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Thu Apr 10 23:00:28 2003 Subject: RE: [sqr-users] Page # of # Example Date: Fri, 11 Apr 2003 13:57:45 +1000 From: "Devinder Singh Kunwar (STP)" Scott, Using "LAST-PAGE" will help. It causes SQR and SQRT to delay printing until the last page has been processed so that the number of the last page is known. Though this could have performance implications. Usage page-number (1,37) 'Page' ! Will appear as last-page ( ) ' of ' '.' ! "Page 12 of 25." *** (1,37) is just to give some position. Cheers, Devinder -----Original Message----- From: Scott.Munson@metavante.com [mailto:Scott.Munson@metavante.com] Sent: Friday, April 11, 2003 12:44 AM To: sqr-users@sqrug.org Subject: [sqr-users] Page # of # Example Is there an SQC or some standard procedure that can print out "Page # of #"? Currently, all of the reports we have come across only print the current page but the user desires to see the total number of pages, in addition to the current page. Thanks, Scott Munson PeopleSoft Billing Team _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Sat Apr 12 01:03:06 2003 From: Al H Subject: Re: [sqr-users] Page # of # Example Date: Fri, 11 Apr 2003 23:01:03 -0700 Just a word of warning..you can't send your report direct to the printer (i.e. -flpt1 or selecting "Printer" as an output destination in PeopleSoft's Process Scheduler) when you use last-page. It will cause an "unable to read from device" error. On Fri, 11 Apr 2003 13:57:45 +1000, you wrote: >Scott, > Using "LAST-PAGE" will help. >It causes SQR and SQRT to delay printing until the last page has been processed so that the number of the last page is known. Though this could have performance implications. > >Usage > > page-number (1,37) 'Page' ! Will appear as > last-page ( ) ' of ' '.' ! "Page 12 of 25." > >*** (1,37) is just to give some position. > >Cheers, >Devinder > > >-----Original Message----- >From: Scott.Munson@metavante.com [mailto:Scott.Munson@metavante.com] >Sent: Friday, April 11, 2003 12:44 AM >To: sqr-users@sqrug.org >Subject: [sqr-users] Page # of # Example > > >Is there an SQC or some standard procedure that can print out "Page # of >#"? Currently, all of the reports we have come across only print the >current page but the user desires to see the total number of pages, in >addition to the current page. > >Thanks, > >Scott Munson >PeopleSoft Billing Team > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 11 07:18:34 2003 From: skirklin@stl-inc.com Subject: RE: [sqr-users] Page # of # Example Date: Fri, 11 Apr 2003 06:14:29 -0600 We use this: BEGIN-FOOTING 1 for-reports=(wowp) print 'Job: Work Order in Progress' (1,2) page-number (,90) 'Page ' last-page () 'of ' '.' END-FOOTING Sherri Kirklin STL-Austin -----Original Message----- From: Scott.Munson@metavante.com [mailto:Scott.Munson@metavante.com] Sent: Thursday, April 10, 2003 2:14 PM To: sqr-users@sqrug.org Subject: [sqr-users] Page # of # Example Is there an SQC or some standard procedure that can print out "Page # of #"? Currently, all of the reports we have come across only print the current page but the user desires to see the total number of pages, in addition to the current page. Thanks, Scott Munson PeopleSoft Billing Team _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users Confidentiality Notice: The information contained in this message is intended only for the use of the addressee, and may be confidential and/or privileged. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Thu Apr 10 17:37:13 2003 From: "Ben Anderson" Date: Thu, 10 Apr 2003 16:32:58 -0400 Subject: [sqr-users] evaluate... array create-array name=week size=8 field=day:number this array gets filled with calendar month numbers like 25, 26, 27, etc. This much I know works because I've printed the array. Here is my problem. evaluate #some_number !this number is equal to 26 when = 26 ! this gets evaluated just fine break when = #week.day(2) ! this number is equal to 26 ! this doesn't get evaluated break !when = week.day(2) ! this gives me an error ! break end-evaluate Hopefully I just have a syntax problem here. Sorry if this is simple - I don't have a manual. From looking through the archives it seems I may be using the array incorrectly. Thanks, Ben Anderson _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Thu Apr 10 18:28:30 2003 From: "Alexander, Steve" Subject: RE: [sqr-users] evaluate... array Date: Thu, 10 Apr 2003 16:31:38 -0700 The "evaluate" and the "when =" are two of the many places in SQR where you cannot use arrays. It does no good to put a # or $ in front of the array. -----Original Message----- From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] Sent: Thursday, April 10, 2003 1:33 PM To: sqr-users@sqrug.org Subject: [sqr-users] evaluate... array create-array name=week size=8 field=day:number this array gets filled with calendar month numbers like 25, 26, 27, etc. This much I know works because I've printed the array. Here is my problem. evaluate #some_number !this number is equal to 26 when = 26 ! this gets evaluated just fine break when = #week.day(2) ! this number is equal to 26 ! this doesn't get evaluated break !when = week.day(2) ! this gives me an error ! break end-evaluate Hopefully I just have a syntax problem here. Sorry if this is simple - I don't have a manual. From looking through the archives it seems I may be using the array incorrectly. Thanks, Ben Anderson _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Sat Apr 12 15:48:44 2003 From: "David Brawner" Subject: RE: [sqr-users] evaluate... array Date: Sat, 12 Apr 2003 16:46:05 -0400 You have to "get" the array value into a variable before it can be evaluated. get #weekday from week(#i) day(2) evaluate #weekday when = 26 {statement} break when = {something else} {statement 2} break when-other break end-evaluate I usually retrieve these in a while loop... Dave -----Original Message----- From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On Behalf Of Ben Anderson Sent: Thursday, April 10, 2003 4:33 PM To: sqr-users@sqrug.org Subject: [sqr-users] evaluate... array create-array name=week size=8 field=day:number this array gets filled with calendar month numbers like 25, 26, 27, etc. This much I know works because I've printed the array. Here is my problem. evaluate #some_number !this number is equal to 26 when = 26 ! this gets evaluated just fine break when = #week.day(2) ! this number is equal to 26 ! this doesn't get evaluated break !when = week.day(2) ! this gives me an error ! break end-evaluate Hopefully I just have a syntax problem here. Sorry if this is simple - I don't have a manual. From looking through the archives it seems I may be using the array incorrectly. Thanks, Ben Anderson _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 11 07:42:58 2003 Date: Fri, 11 Apr 2003 06:41:43 -0600 From: "Horn, Michael (CXO Colorado Springs)" Subject: [sqr-users] Using SQR version 8 and receiving the following message This is a multi-part message in MIME format... ------_=_NextPart_001_01C30027.B4F96277 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello all, I am currently a new user to SQR and we are using version 8. I am using a = Microsoft SQL 2000 Database and I receive the following error when trying t= o use SQR: [MERANT] [ODBC MS SQL Server 6 driver][Microsoft SQL Server] Could not find= stored procedure 'sp_start_xact!' Looking up the sp_start_xact procedure, I cannot find anything for it in MS= SQL, but it shows up as a SYBASE procedure when looking under search engin= es on the web. Could the problem be that the drivers that were provided ar= e for version 6 and not version 8? Also, we have some tables that have field names with spaces. Does anyone k= now how to get past this problem in SQR? I have asked our SQL gurus if the= re is anything could be done to translate a space to and underscore and the= y have said no. Barring going into the database and updating every field n= ame to include an underscore. One of the tables has a space in it also. C= an this be parsed too? Thanks for your help in advance. Michael Horn HP Services CCHS Division (719) 592 - 5043 <>=20 ------_=_NextPart_001_01C30027.B4F96277 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'text/x-vcard' MIME type. It has been automatically discarded before sending the message to the list. ------_=_NextPart_001_01C30027.B4F96277-- _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Sun Apr 13 06:45:25 2003 From: "Edwin Hommes" Subject: Re: [sqr-users] Using SQR version 8 and receiving the following message Date: Sun, 13 Apr 2003 13:43:33 +0200 Michael You may want to check your configuration file on the server side. It may tell SQR it is running on a Sybase DB. (rdbms.sqc) Should be set correctly when installing PS though. Since underscores are in the database world considered wildcards, you can not translate spaces with underscores. You could use any other character, with the exception of *. (also a wildcard) In SQR you can deal with (trailing) spaces by using the command let new_var = rtrim(old_var, ' ') thus cutting of any spaces from the right to the left. This will leave you will a NULL (empty) variable if the source variable contained spaces only. Peoplesoft (most systems) do not like tables with spaces in their names. I'd say that SQR, Peoplesoft as well as Ms SQL Server 2000 will have problems at querying that table Hope this helps, Edwin ----- Original Message ----- From: "Horn, Michael (CXO Colorado Springs)" To: Sent: Friday, April 11, 2003 2:41 PM Subject: [sqr-users] Using SQR version 8 and receiving the following message Hello all, I am currently a new user to SQR and we are using version 8. I am using a Microsoft SQL 2000 Database and I receive the following error when trying to use SQR: [MERANT] [ODBC MS SQL Server 6 driver][Microsoft SQL Server] Could not find stored procedure 'sp_start_xact!' Looking up the sp_start_xact procedure, I cannot find anything for it in MS SQL, but it shows up as a SYBASE procedure when looking under search engines on the web. Could the problem be that the drivers that were provided are for version 6 and not version 8? Also, we have some tables that have field names with spaces. Does anyone know how to get past this problem in SQR? I have asked our SQL gurus if there is anything could be done to translate a space to and underscore and they have said no. Barring going into the database and updating every field name to include an underscore. One of the tables has a space in it also. Can this be parsed too? Thanks for your help in advance. Michael Horn HP Services CCHS Division (719) 592 - 5043 <> ---------------------------------------------------------------------------- ---- > Here was a non admissible message part of 'text/x-vcard' MIME type. It > has been automatically discarded before sending the message to the > list. > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.467 / Virus Database: 266 - Release Date: 01/04/2003 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Fri Apr 11 08:13:10 2003 Date: Fri, 11 Apr 2003 09:12:42 -0400 From: "White, Denise" Subject: [sqr-users] RE: evaluate... array Hi Ben, You will need to do a GET to retrieve the value from the array first. Example: get #day from week(2) You can then use the resulting variable (#day) in the evaluate. Some statements can reference the field within the array directly, as you are trying to do, but others can't. For the ones that can't, you must first retrieve the field into a variable. HTH, Denise M. White Sr. Software Engineer Vicor --__--__-- Message: 3 From: "Ben Anderson" To: sqr-users@sqrug.org Date: Thu, 10 Apr 2003 16:32:58 -0400 Subject: [sqr-users] evaluate... array Reply-To: sqr-users@sqrug.org create-array name=week size=8 field=day:number this array gets filled with calendar month numbers like 25, 26, 27, etc. This much I know works because I've printed the array. Here is my problem. evaluate #some_number !this number is equal to 26 when = 26 ! this gets evaluated just fine break when = #week.day(2) ! this number is equal to 26 ! this doesn't get evaluated break !when = week.day(2) ! this gives me an error ! break end-evaluate Hopefully I just have a syntax problem here. Sorry if this is simple - I don't have a manual. From looking through the archives it seems I may be using the array incorrectly. Thanks, Ben Anderson _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 07:45:15 2003 From: "Ben Anderson" Date: Mon, 14 Apr 2003 08:40:32 -0400 Subject: [sqr-users] wrap - bold in middle Hello all, I want to print this: This is a test. (I want "is" to be bold) I tried this: encode '<27>(s3B' into $bold enocde '<27>(s0B' into $unbold let $line1 = 'This ' || $bold || 'is ' || $unbold || 'a test.' print $line1 (1,1,0) wrap 17 2 And here's my problem. The wrap logic is counting the control characters when breaking to the next line. i.e. this statement will show up on 2 lines instead of 1. Anyone know how to do this? Thanks, Ben Anderson _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 08:02:06 2003 Subject: RE: [sqr-users] wrap - bold in middle Date: Mon, 14 Apr 2003 09:01:26 -0400 From: "Wright, Rodney" I do a lot of bolding and wrapping on our open enrollment forms. As you stated, wrap counts the number of characters and wraps where you tell it to. It does not know the difference between control characters and printing characters. You have to adjust your wrap parameters to get it to wrap the way you want it to. Rod Wright Senior Applications Specialist The Rouse Company 410-992-6307 -----Original Message----- From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] Sent: Monday, April 14, 2003 8:41 AM To: sqr-users@sqrug.org Subject: [sqr-users] wrap - bold in middle Hello all, I want to print this: This is a test. (I want "is" to be bold) I tried this: encode '<27>(s3B' into $bold enocde '<27>(s0B' into $unbold let $line1 = 'This ' || $bold || 'is ' || $unbold || 'a test.' print $line1 (1,1,0) wrap 17 2 And here's my problem. The wrap logic is counting the control characters when breaking to the next line. i.e. this statement will show up on 2 lines instead of 1. Anyone know how to do this? Thanks, Ben Anderson _________________________________________________________________ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 08:34:28 2003 From: "Ben Anderson" Subject: RE: [sqr-users] wrap - bold in middle Date: Mon, 14 Apr 2003 09:33:23 -0400 Rodney, So do you print out each line separately? If I print out one long paragraph in the same print command, with the same wrap - some lines will contain additional control characters and some won't. Therefore, I'd assume that I must have the wrap be the value of a line that contains no control characters. So, if I have a line with control characters, it will break halfway through the line. Do you have this problem? Thanks Ben >From: "Wright, Rodney" >Reply-To: sqr-users@sqrug.org >To: >Subject: RE: [sqr-users] wrap - bold in middle >Date: Mon, 14 Apr 2003 09:01:26 -0400 > >I do a lot of bolding and wrapping on our open enrollment forms. As you >stated, wrap counts the number of characters and wraps where you tell it >to. It does not know the difference between control characters and >printing characters. You have to adjust your wrap parameters to get it >to wrap the way you want it to. > >Rod Wright >Senior Applications Specialist >The Rouse Company >410-992-6307 > > >-----Original Message----- >From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] >Sent: Monday, April 14, 2003 8:41 AM >To: sqr-users@sqrug.org >Subject: [sqr-users] wrap - bold in middle > >Hello all, >I want to print this: > >This is a test. (I want "is" to be bold) > >I tried this: > >encode '<27>(s3B' into $bold >enocde '<27>(s0B' into $unbold > >let $line1 = 'This ' || $bold || 'is ' || $unbold || 'a test.' >print $line1 (1,1,0) wrap 17 2 > > >And here's my problem. The wrap logic is counting the control >characters >when breaking to the next line. i.e. this statement will show up on 2 >lines >instead of 1. Anyone know how to do this? > >Thanks, >Ben Anderson > >_________________________________________________________________ >Protect your PC - get McAfee.com VirusScan Online >http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org >http://www.sqrug.org/mailman/listinfo/sqr-users > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org >http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 09:19:13 2003 Subject: RE: [sqr-users] wrap - bold in middle Date: Mon, 14 Apr 2003 10:18:08 -0400 From: "Wright, Rodney" It depends on what's in the paragraph. If the paragraph has a large section of bold print, then I print the first part of the paragraph with it's wrap parameters, print the section that contains the bold with appropriate wrap parameters, and print the final part of the paragraph with the same wrap parameters as the first part. If the paragraph has small parts of bold throughout, then I print it all with one wrap statement, finding parameters that give me a happy medium between the lines with no bold portions and the lines with bold portions. It would be nice if the wrap statement was a little more sophisticated, taking into account the font you're using along with bold, italics, etc. Unfortunately, it's just a character counter. It's better than printing out each line by itself though. It also makes programming easier than printing out each line by itself. You have to sacrifice a little bit on the looks of the form, but the programming is much more straight forward. Rod Wright Senior Applications Specialist The Rouse Company 410-992-6307 -----Original Message----- From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] Sent: Monday, April 14, 2003 9:33 AM To: sqr-users@sqrug.org Subject: RE: [sqr-users] wrap - bold in middle Rodney, So do you print out each line separately? If I print out one long paragraph in the same print command, with the same wrap - some lines will contain additional control characters and some won't. Therefore, I'd assume that I must have the wrap be the value of a line that contains no control characters. So, if I have a line with control characters, it will break halfway through the line. Do you have this problem? Thanks Ben >From: "Wright, Rodney" >Reply-To: sqr-users@sqrug.org >To: >Subject: RE: [sqr-users] wrap - bold in middle >Date: Mon, 14 Apr 2003 09:01:26 -0400 > >I do a lot of bolding and wrapping on our open enrollment forms. As you >stated, wrap counts the number of characters and wraps where you tell it >to. It does not know the difference between control characters and >printing characters. You have to adjust your wrap parameters to get it >to wrap the way you want it to. > >Rod Wright >Senior Applications Specialist >The Rouse Company >410-992-6307 > > >-----Original Message----- >From: Ben Anderson [mailto:pegandersonbd1@hotmail.com] >Sent: Monday, April 14, 2003 8:41 AM >To: sqr-users@sqrug.org >Subject: [sqr-users] wrap - bold in middle > >Hello all, >I want to print this: > >This is a test. (I want "is" to be bold) > >I tried this: > >encode '<27>(s3B' into $bold >enocde '<27>(s0B' into $unbold > >let $line1 = 'This ' || $bold || 'is ' || $unbold || 'a test.' >print $line1 (1,1,0) wrap 17 2 > > >And here's my problem. The wrap logic is counting the control >characters >when breaking to the next line. i.e. this statement will show up on 2 >lines >instead of 1. Anyone know how to do this? > >Thanks, >Ben Anderson > >_________________________________________________________________ >Protect your PC - get McAfee.com VirusScan Online >http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org >http://www.sqrug.org/mailman/listinfo/sqr-users > >_______________________________________________ >sqr-users mailing list >sqr-users@sqrug.org >http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 16:16:10 2003 From: "M S Bugge" Date: Mon, 14 Apr 2003 17:14:10 -0400 Subject: [sqr-users] Need another set of eyes. This is a multi-part message in MIME format... ------=_NextPart_000_014D_01C302A9.439E6B10 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable BlankThis is strange why am i getting this error: Somebody please assist me= with another set of eyes. begin-procedure validate-ledger-type=20 #debugf show 'validate-ledger-type'=20 begin-select b.ANALYSIS_TYPE=20 let $atype =3D &b.ANALYSIS_TYPE from PS_RR_MP_PC_XREF b where b.RR_MP_LT =3D $ledger_type end-select end-procedure ! validate-ledger-type Error on line 332: (SQR 3719) Columns names and expressions must be unique or be given uniq= ue ps eudonyms (&name). let $atype =3D &b.ANALYSIS_TYPE Errors were found in the program file. Thanks in advance Bugge ------=_NextPart_000_014D_01C302A9.439E6B10 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'image/gif' MIME type. It has been automatically discarded before sending the message to the list. ------=_NextPart_000_014D_01C302A9.439E6B10-- _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 16:26:07 2003 Date: Mon, 14 Apr 2003 17:24:38 -0400 From: "Prasanna Menta" Subject: Re: [sqr-users] Need another set of eyes. You using the same alias type in a different procedure, just change the alias from b.analysis_type to bb.analysis_type, it should work Hope this helps Prasanna M S Bugge wrote: > > BlankThis is strange why am i getting this error: Somebody please assist me with another set of eyes. > > begin-procedure validate-ledger-type > #debugf show 'validate-ledger-type' > > begin-select > > b.ANALYSIS_TYPE > > let $atype = &b.ANALYSIS_TYPE > > from PS_RR_MP_PC_XREF b > where b.RR_MP_LT = $ledger_type > > end-select > > end-procedure ! validate-ledger-type > > Error on line 332: > (SQR 3719) Columns names and expressions must be unique or be given unique ps > eudonyms (&name). > let $atype = &b.ANALYSIS_TYPE > > Errors were found in the program file. > > Thanks in advance > > Bugge _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 16:31:05 2003 From: "M S Bugge" Subject: Re: [sqr-users] Need another set of eyes. Date: Mon, 14 Apr 2003 17:31:57 -0400 Hi Prasanna, I have not used it any where just this. Thanks ----- Original Message ----- From: "Prasanna Menta" To: Sent: Monday, April 14, 2003 5:24 PM Subject: Re: [sqr-users] Need another set of eyes. > You using the same alias type in a different procedure, just change the > alias from b.analysis_type to bb.analysis_type, it should work > > Hope this helps > Prasanna > > M S Bugge wrote: > > > > BlankThis is strange why am i getting this error: Somebody please assist me with another set of eyes. > > > > begin-procedure validate-ledger-type > > #debugf show 'validate-ledger-type' > > > > begin-select > > > > b.ANALYSIS_TYPE > > > > let $atype = &b.ANALYSIS_TYPE > > > > from PS_RR_MP_PC_XREF b > > where b.RR_MP_LT = $ledger_type > > > > end-select > > > > end-procedure ! validate-ledger-type > > > > Error on line 332: > > (SQR 3719) Columns names and expressions must be unique or be given unique ps > > eudonyms (&name). > > let $atype = &b.ANALYSIS_TYPE > > > > Errors were found in the program file. > > > > Thanks in advance > > > > Bugge > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 16:20:07 2003 From: "M S Bugge" Date: Mon, 14 Apr 2003 17:20:35 -0400 Subject: [sqr-users] Need another set of eyes. This is a multi-part message in MIME format... ------=_NextPart_000_017F_01C302AA.29720520 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable BlankThis is strange why am I getting this error: Somebody please assist me= with another set of eyes. begin-procedure validate-ledger-type=20 #debugf show 'validate-ledger-type'=20 begin-select b.ANALYSIS_TYPE=20 let $atype =3D &b.ANALYSIS_TYPE from PS_RR_MP_PC_XREF b where b.RR_MP_LT =3D $ledger_type end-select end-procedure ! validate-ledger-type Error on line 332: (SQR 3719) Columns names and expressions must be unique or be given uniq= ue ps eudonyms (&name). let $atype =3D &b.ANALYSIS_TYPE Errors were found in the program file. Thanks in advance Bugge ------=_NextPart_000_017F_01C302AA.29720520 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'image/gif' MIME type. It has been automatically discarded before sending the message to the list. ------=_NextPart_000_017F_01C302AA.29720520-- _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 16:22:05 2003 From: Bill Beckner Subject: RE: [sqr-users] Need another set of eyes. Date: Mon, 14 Apr 2003 16:21:48 -0500 Check your SQR for another reference to b.ANALYSIS_TYPE. Or, just change the alias in this select statement from "b" to "bb"... HTH! > -----Original Message----- > From: M S Bugge [mailto:msbugge@hotmail.com > ] > Sent: Monday, April 14, 2003 4:14 PM > To: Sqr - Users > Subject: [sqr-users] Need another set of eyes. > > << File: ATT244863.txt >> << File: AUTOMATIC WARNING >> _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 16:30:07 2003 From: "M S Bugge" Subject: Re: [sqr-users] Need another set of eyes. Date: Mon, 14 Apr 2003 17:31:00 -0400 no luck now the error is Error on line 332: (SQR 3719) Columns names and expressions must be unique or be given unique ps eudonyms (&name). let $atype = &bb.ANALYSIS_TYPE Errors were found in the program file. SQR for PeopleSoft: Program Aborting. ----- Original Message ----- From: "Bill Beckner" To: Sent: Monday, April 14, 2003 5:21 PM Subject: RE: [sqr-users] Need another set of eyes. > Check your SQR for another reference to b.ANALYSIS_TYPE. Or, just change > the alias in this select statement from "b" to "bb"... > > HTH! > > > -----Original Message----- > > From: M S Bugge [mailto:msbugge@hotmail.com > > ] > > Sent: Monday, April 14, 2003 4:14 PM > > To: Sqr - Users > > Subject: [sqr-users] Need another set of eyes. > > > > << File: ATT244863.txt >> << File: AUTOMATIC WARNING >> > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-admin@sqrug.org Mon Apr 14 16:34:05 2003 From: David Arthur Subject: