From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Thu Jul 01 00:00:35 2004 Date: Thu, 1 Jul 2004 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.21 $ $Date: 2004-03-04 02:47:15-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 When your email address changes 3.4 Digests 3.5 Obtaining your password 3.6 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 2003/11/01: o Update subscribe/unsubscribe instructions for new version of list server software. o New URL for "brio-l" mailing list. 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 Hyperion (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. On October 16, 2003, Hyperion acquired Brio Software. 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-2004 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 near the bottom of the page, and click the "Unsubscribe or edit options" button. You will then see the "member options" page; fill in your password at the top of the page and click "Log in". (If you have forgotton your password, see the ``Obtaining your Password'' section, below). This will take you to the "membership configuration" page. In the middle of that page, there will be an "Unsubscribing from sqr- users" section; simply turn on the "Yes, I really want to unsubscribe" checkbox and click the "Unsubscribe" button. You should get a page back saying that the removal was successful (as well as a confirmation email message). The removal will take effect immediately; there is no need to send in a confirmation e-mail message. If you don't know your password, you can choose to unsubscribe using e-mail confirmation. Instead of entering the password on the "member options" page, just click the "Unsubscribe" button found just below the "Log In" button. You will then see a page noting that a confirmation e-mail has been sent; once you follow the confirmation instructions in that e-mail your removal will be complete. 3.3. When your email address changes If your e-mail address changes -- for example, if your company changes names, or if your mail administrator changes the way your name is spelled out or abbreviated -- you will need to update your subscription to match your new address before you can post to the list (see the ``Posting'' section, below). To do this, simply log in to your "membership configuration" page (see the directions for logging in to this page in the ``Unsubscribing'' section, above). At the top of that page you'll see a "Changing your membership information" section. Fill out the text boxes and click the "Change My Address and Name" button. You will be sent a confirmation e-mail, and once you have responded to that e-mail your subscription will be updated and you can begin posting from your new address. 3.4. 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, log in to your "membership configuration" page (see the directions on doing this in the ``Unsubscribing'' section, above). At the bottom of the page, you will see a section titled "Your sqr-users Subscription Options". Change the "Set Digest Mode" option (the second option in the list) to "On" and click the "Submit My Changes" button at the bottom of the page. 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.5. Obtaining your password You will not be able to change your subscription options without your password. If you have forgotten your password, simply click the "Email My Password to Me" button on the "member options" page and your password will be emailed 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.6. 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). More specifically, in order for Mailman to recognize that this message was sent by a subscriber, the return address on your message much exactly match the addresss you used to subscribe -- if you have more than one address you will need to be sure that you are sending from the correct one. (See the ``When you email address changes'' section, above, if your e-mail address has changed since you subscribed.) 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 as other subscribers' mail systems repond....) 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. Also, if you are trying to send (for example) SQR source code files, make sure your mail-reader software is assigning proper MIME types to your attachments or they may not be distributed. 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 fuel 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 SQR product name and version number (see notes below) o Operating system name 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/Hyperion's, so it's very important to mention whether you are using Hyperion'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 and database version numbers listed here are the ones under which this copy of SQR was compiled, so you'll still need to include this information 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-bounces+sqrusersarch=sqrug.org@sqrug.org Thu Jul 01 13:56:57 2004 From: "Mark Hall" Date: Thu, 01 Jul 2004 13:54:03 -0500 Subject: [sqr-users] (SQR 5543) Specify the Oracle DLL name in the SQR.INI One of my users ran into the following error running sqrw. (SQR 5543) Specify the Oracle DLL name in the SQR.INI file in (Environment Oracle] section for ORAVLE_DLL entry such as ORACLE_DLL =orant71.dll I found an old thread on sqrug which helped me to solve the problem but the solution, at least the one I found, is not explicitly spelled out in any posting. So in the interest of contributing to the knowledge base I will share my solution. Simply add the path to the oracle binaries on your local machine to your system PATH variable. C:\oracle\ora81\bin Start>Settings>Control Panel>System. Select the Advanced tab on the System Properties dialog box. Click the Environment variables button. Edit the path system variable to include the path to the oracle binaries. C:\oracle\ora81\bin; Mark Hall IS Analyst ERP Team Parkview Health Systems Fort Wayne, IN 260-373-8796 mark.hall@parkview.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Thu Jul 01 15:07:47 2004 Date: Thu, 1 Jul 2004 16:07:00 -0400 From: "Pink, Michael" Subject: [sqr-users] Flat File Limitations Hi, Does anyone know if there is a size limitation for writing flat files in SQR? Mike. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Thu Jul 01 15:46:16 2004 From: Ray Ontko Date: Thu, 1 Jul 2004 15:44:16 -0500 Subject: Re: [sqr-users] Flat File Limitations I'm not aware of any. Are you running into a problem? What operating system? Fixed or varying length records? If fixed, what record size? Ray On Thu, Jul 01, 2004 at 04:07:00PM -0400, Pink, Michael wrote: > Hi, > Does anyone know if there is a size limitation for writing flat files in > SQR? > Mike. > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------- 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-bounces+sqrusersarch=sqrug.org@sqrug.org Thu Jul 01 16:16:35 2004 From: "Lynds,Rick" Subject: RE: [sqr-users] Flat File Limitations Date: Thu, 1 Jul 2004 14:14:04 -0700 I recall some discussion about this a while ago. The result was that the limitations are generally due to limitations in the host operating/file system, rather than the SQR product itself. -----Original Message----- From: Pink, Michael [mailto:Michael.Pink@pgnmail.com] Sent: Thursday, July 01, 2004 1:07 PM To: sqr-users@sqrug.org Subject: [sqr-users] Flat File Limitations Hi, Does anyone know if there is a size limitation for writing flat files in SQR? Mike. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Thu Jul 01 16:26:55 2004 From: "the dragon" Subject: RE: [sqr-users] Flat File Limitations Date: Thu, 01 Jul 2004 16:25:52 -0500 Mike, There are OS level limitations, especially if you are using Unix, you may run into the ulimt restrictions for your user (Usually 1 GB??), or, obviously the amount of available disk space will limit your output file peace, clark PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Hi, Does anyone know if there is a size limitation for writing flat files in SQR? Mike. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Fri Jul 02 05:57:51 2004 Subject: RE: [sqr-users] Flat File Limitations Date: Fri, 2 Jul 2004 06:54:48 -0400 From: "Pink, Michael" Yeah we are getting a core dump after a certain number of rows are met. The record length is 2098 and on HP unix. -----Original Message----- From: sqr-users-bounces+michael.pink=3Dpgnmail.com@sqrug.org [mailto:sqr-users-bounces+michael.pink=3Dpgnmail.com@sqrug.org] On Behalf Of Ray Ontko Sent: Thursday, July 01, 2004 4:44 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Flat File Limitations I'm not aware of any. Are you running into a problem? What operating system? Fixed or varying length records? If fixed, what record size? Ray On Thu, Jul 01, 2004 at 04:07:00PM -0400, Pink, Michael wrote: > Hi, > Does anyone know if there is a size limitation for writing flat files in > SQR? > Mike. >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------- 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 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Fri Jul 02 10:04:06 2004 From: Ray Ontko Date: Fri, 2 Jul 2004 10:03:37 -0500 Subject: Re: [sqr-users] Flat File Limitations Is it somewhere near 1024000 records? If so, then you're probably bumping into a 2GB file limit. I'm not sure whether you'll be able to easily get around this. Ray On Fri, Jul 02, 2004 at 06:54:48AM -0400, Pink, Michael wrote: > Yeah we are getting a core dump after a certain number of rows are met. > The record length is 2098 and on HP unix. > > -----Original Message----- > From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org > [mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On Behalf > Of Ray Ontko > Sent: Thursday, July 01, 2004 4:44 PM > To: This list is for discussion about the SQR database reporting > languagefrom Hyperion Solutions. > Subject: Re: [sqr-users] Flat File Limitations > > > I'm not aware of any. Are you running into a problem? What operating > system? Fixed or varying length records? If fixed, what record size? > > Ray > > On Thu, Jul 01, 2004 at 04:07:00PM -0400, Pink, Michael wrote: > > Hi, > > Does anyone know if there is a size limitation for writing flat files > in > > SQR? > > Mike. > > > > _______________________________________________ > > sqr-users mailing list > > sqr-users@sqrug.org > > http://www.sqrug.org/mailman/listinfo/sqr-users > ---------------------------------------------------------------------- > 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 > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------- 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-bounces+sqrusersarch=sqrug.org@sqrug.org Fri Jul 02 10:13:33 2004 From: "Raj Srinivasan" Subject: RE: [sqr-users] Flat File Limitations Date: Fri, 2 Jul 2004 10:12:08 -0500 There was a similar problem at one of the big PS shops, and the resolution was to split the file into manageable size and then process sequentially. Thanks!!! Raj -----Original Message----- From: sqr-users-bounces+raj.srinivasan=hccs.edu@sqrug.org [mailto:sqr-users-bounces+raj.srinivasan=hccs.edu@sqrug.org]On Behalf Of Ray Ontko Sent: Friday, July 02, 2004 10:04 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Flat File Limitations Is it somewhere near 1024000 records? If so, then you're probably bumping into a 2GB file limit. I'm not sure whether you'll be able to easily get around this. Ray On Fri, Jul 02, 2004 at 06:54:48AM -0400, Pink, Michael wrote: > Yeah we are getting a core dump after a certain number of rows are met. > The record length is 2098 and on HP unix. > > -----Original Message----- > From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org > [mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On Behalf > Of Ray Ontko > Sent: Thursday, July 01, 2004 4:44 PM > To: This list is for discussion about the SQR database reporting > languagefrom Hyperion Solutions. > Subject: Re: [sqr-users] Flat File Limitations > > > I'm not aware of any. Are you running into a problem? What operating > system? Fixed or varying length records? If fixed, what record size? > > Ray > > On Thu, Jul 01, 2004 at 04:07:00PM -0400, Pink, Michael wrote: > > Hi, > > Does anyone know if there is a size limitation for writing flat files > in > > SQR? > > Mike. > > > > _______________________________________________ > > sqr-users mailing list > > sqr-users@sqrug.org > > http://www.sqrug.org/mailman/listinfo/sqr-users > ---------------------------------------------------------------------- > 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 > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------- 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 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Fri Jul 02 06:19:18 2004 From: "the dragon" Subject: RE: [sqr-users] Flat File Limitations Date: Fri, 02 Jul 2004 06:18:01 -0500 Mike, How large is your output file when the sqr bails? I still think you're running up against an OS size limit; on AIX it would be the ulimit - you should get your system admin involved. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- Yeah we are getting a core dump after a certain number of rows are met. The record length is 2098 and on HP unix. -----Original Message----- I'm not aware of any. Are you running into a problem? What operating system? Fixed or varying length records? If fixed, what record size? Ray _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Fri Jul 02 10:09:39 2004 Subject: RE: [sqr-users] Flat File Limitations Date: Fri, 2 Jul 2004 11:07:31 -0400 From: "Pink, Michael" No the file is actually small, only about 11,000 rows. Less than 25 meg. -----Original Message----- From: sqr-users-bounces+michael.pink=3Dpgnmail.com@sqrug.org [mailto:sqr-users-bounces+michael.pink=3Dpgnmail.com@sqrug.org] On Behalf Of Ray Ontko Sent: Friday, July 02, 2004 11:04 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Flat File Limitations Is it somewhere near 1024000 records? If so, then you're probably=20 bumping into a 2GB file limit. I'm not sure whether you'll be able to easily get around this. Ray On Fri, Jul 02, 2004 at 06:54:48AM -0400, Pink, Michael wrote: > Yeah we are getting a core dump after a certain number of rows are met. > The record length is 2098 and on HP unix. >=20 > -----Original Message----- > From: sqr-users-bounces+michael.pink=3Dpgnmail.com@sqrug.org > [mailto:sqr-users-bounces+michael.pink=3Dpgnmail.com@sqrug.org] On Behalf > Of Ray Ontko > Sent: Thursday, July 01, 2004 4:44 PM > To: This list is for discussion about the SQR database reporting > languagefrom Hyperion Solutions. > Subject: Re: [sqr-users] Flat File Limitations >=20 >=20 > I'm not aware of any. Are you running into a problem? What operating > system? Fixed or varying length records? If fixed, what record size? >=20 > Ray >=20 > On Thu, Jul 01, 2004 at 04:07:00PM -0400, Pink, Michael wrote: > > Hi, > > Does anyone know if there is a size limitation for writing flat files > in > > SQR? > > Mike. > >=20 > > _______________________________________________ > > sqr-users mailing list > > sqr-users@sqrug.org > > http://www.sqrug.org/mailman/listinfo/sqr-users > ---------------------------------------------------------------------- > 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/ >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users >=20 > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------- 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 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Fri Jul 02 10:21:12 2004 From: "Mark Hall" Date: Fri, 02 Jul 2004 10:18:34 -0500 Subject: RE: [sqr-users] Flat File Limitations If you are running into the 2G file limit you need to process the file in a file system that is "large file enabled." In some file systems I run into this limit when I am doing an export of an Oracle database. But certain file systems are, as I said, "large file enabled" and they except files sizes greater than 2G. Talk to your Unix system administrator. That is, if you are processing this file on a Unix box. It may just be that you need to use a different file system. Mark Hall IS Analyst ERP Team Parkview Health Systems Fort Wayne, IN 260-373-8796 mark.hall@parkview.com >>> raj.srinivasan@hccs.edu 07/02/04 10:12AM >>> There was a similar problem at one of the big PS shops, and the resolution was to split the file into manageable size and then process sequentially. Thanks!!! Raj -----Original Message----- From: sqr-users-bounces+raj.srinivasan=hccs.edu@sqrug.org [mailto:sqr-users-bounces+raj.srinivasan=hccs.edu@sqrug.org]On Behalf Of Ray Ontko Sent: Friday, July 02, 2004 10:04 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: Re: [sqr-users] Flat File Limitations Is it somewhere near 1024000 records? If so, then you're probably bumping into a 2GB file limit. I'm not sure whether you'll be able to easily get around this. Ray On Fri, Jul 02, 2004 at 06:54:48AM -0400, Pink, Michael wrote: > Yeah we are getting a core dump after a certain number of rows are met. > The record length is 2098 and on HP unix. > > -----Original Message----- > From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org > [mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On Behalf > Of Ray Ontko > Sent: Thursday, July 01, 2004 4:44 PM > To: This list is for discussion about the SQR database reporting > languagefrom Hyperion Solutions. > Subject: Re: [sqr-users] Flat File Limitations > > > I'm not aware of any. Are you running into a problem? What operating > system? Fixed or varying length records? If fixed, what record size? > > Ray > > On Thu, Jul 01, 2004 at 04:07:00PM -0400, Pink, Michael wrote: > > Hi, > > Does anyone know if there is a size limitation for writing flat files > in > > SQR? > > Mike. > > > > _______________________________________________ > > sqr-users mailing list > > sqr-users@sqrug.org > > http://www.sqrug.org/mailman/listinfo/sqr-users > ---------------------------------------------------------------------- > 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 > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users ---------------------------------------------------------------------- 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 _______________________________________________ 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-bounces+sqrusersarch=sqrug.org@sqrug.org Fri Jul 02 11:42:40 2004 From: "Bencke, Gina" Date: Fri, 2 Jul 2004 12:41:15 -0400 Subject: [sqr-users] Output variables with SQL Server Stored Procedures First let me say that I know there are many SQRUG postings regarding this topic and I did read and try to apply them. However I cannot get SQL-Server Stored Procedures with output variables to work! declare-variable float #colVariance text $outStr end-declare=20=20 move 'Hotels' to $str execute on-error=3DSQL-Error do=3DPrint-Columns @#storedProcStatus=3D fce_str_parm @entity=3D$str, @outStrVar=3D$outStr OUT into &ENTITY char(30), &ACTUAL float, &PROJECTED float=20 =20=20=20=20 print $outStr (+1,1) show 'Str: <' $outStr '>' =20=20 The above code successfully prints the column values returned from the stored procedure but $outStr is NULL and should not be. While the SQL Analyzer code below works properly, returning a string in @var. declare @var CHAR(30) exec fce_str_parm 'Hotels', @var out select @var The SQR code below fails with an execution error " (SQR 6801) Em2StdString: Null Operand Passed as input" regardless of how I call the stored procedure. The SQL Analyzer code works. move 3.0 to #actual move 5.0 to #projected move 0 to #colVariance execute on-error=3DSQL-Error =20=20=20 @#storedProcStatus=3D fce_calc_var @actual=3D#actual, @projected=3D#projected, @variance=3D#colVariance OUT !fce_calc_var 3, 5, #colVariance OUT=20 =20=20=20=20 !fce_calc_var @actual=3D3, @projected=3D5, @variance=3D#colVar output =20=20=20=20=20 !fce_calc_var 3, 5, #colVar OUT=20 =20 print 'Test 1' (2,1) print #colVar (0, +3) edit 999,999.99 print #storedProcStatus (0, +3) edit 999 declare @var DECIMAL (26,3) exec fce_calc_var 3, 5, @var out select @var Thanks, in advance, for your help. Gina Bencke Bencke Consulting Corporation Office (440) 519-0060 email: gina.work@bencke.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Fri Jul 02 14:44:32 2004 From: matunjt@NU.COM Date: Fri, 2 Jul 2004 15:41:57 -0400 Subject: [sqr-users] Interpreting HTML code in SQR report output We have a field to include in an SQR report that contains HTML code. Is there anyway for SQR to interpret the HTML formatting when printing / rendering the report? Specifically line breaks, bolding, and bullets. We are able to pull all HTML tags from the output, but we would like to keep some of the formatting. Where are using Report Builder 6.2.1 against Oracle 9i. Here is a sample of the field data:
  • Working with purchasing to complete contract
  • Researching issues related to deployment
    • PC equipment
    • Network limitations
  • Signed-off on Phase II contract with vendor
This is the output in the actual application that we would like to come close to: Working with purchasing to complete contract Researching issues related to deployment PC equipment Network limitations Signed-off on Phase II contract with vendor Any suggestions? Thanks, Jon Matunas ********************************************************************** This e-mail, including any files or attachments transmitted with it, is confidential and intended for a specific purpose and for use only by the individual or entity to whom it is addressed. Any disclosure, copying or distribution of this e-mail or the taking of any action based on its contents, other than for its intended purpose, is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately and delete it from your system. Any views or opinions expressed in this e-mail are not necessarily those of Northeast Utilities, its subsidiaries and affiliates (NU). E-mail transmission cannot be guaranteed to be error-free or secure or free from viruses, and NU disclaims all liability for any resulting damage, errors, or omissions. ********************************************************************** _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Sun Jul 04 01:53:36 2004 From: "Steve Cavill" Subject: RE: [sqr-users] Interpreting HTML code in SQR report output Date: Sun, 4 Jul 2004 16:52:27 +1000 You should be able to use PRINT CODE-PRINTER=HT which will include whatever you ask it to. See the chapter on "Working with HTML" in the SQR developers guide which has an example. Cheers, Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of matunjt@NU.COM Sent: Saturday, 3 July 2004 5:42 AM To: sqr-users@sqrug.org Subject: [sqr-users] Interpreting HTML code in SQR report output We have a field to include in an SQR report that contains HTML code. Is there anyway for SQR to interpret the HTML formatting when printing / rendering the report? Specifically line breaks, bolding, and bullets. We are able to pull all HTML tags from the output, but we would like to keep some of the formatting. Where are using Report Builder 6.2.1 against Oracle 9i. Here is a sample of the field data:
  • Working with purchasing to complete contract
  • Researching issues related to deployment
    • PC equipment
    • Network limitations
  • Signed-off on Phase II contract with vendor
This is the output in the actual application that we would like to come close to: Working with purchasing to complete contract Researching issues related to deployment PC equipment Network limitations Signed-off on Phase II contract with vendor Any suggestions? Thanks, Jon Matunas ********************************************************************** This e-mail, including any files or attachments transmitted with it, is confidential and intended for a specific purpose and for use only by the individual or entity to whom it is addressed. Any disclosure, copying or distribution of this e-mail or the taking of any action based on its contents, other than for its intended purpose, is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately and delete it from your system. Any views or opinions expressed in this e-mail are not necessarily those of Northeast Utilities, its subsidiaries and affiliates (NU). E-mail transmission cannot be guaranteed to be error-free or secure or free from viruses, and NU disclaims all liability for any resulting damage, errors, or omissions. ********************************************************************** _______________________________________________ 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-bounces+sqrusersarch=sqrug.org@sqrug.org Sun Jul 04 19:44:28 2004 From: Ray Ontko Date: Sun, 4 Jul 2004 19:43:59 -0500 Subject: Re: [sqr-users] Interpreting HTML code in SQR report output Jon, (Steve,) If you're only creating HTML output, then Steve's suggestion should work for you. You might need to trim out the and tags. But, I'm guessing that your question has to do with rendering HTML in the context of -printer:pd, -printer:ht, or -printer:ps. If that's the case, then you'll want to _interpret_ the HTML and invoke the appropriate PRINT commands depending on the HTML content. We've developed such an HTML interpreter (that reads a string containing HTML and then executes the equivalent print commands) that also uses our proportional font library. We get pretty good results for a useful subset of HTML. We have a substantial investment in our proportional font and HTML rendering libary. We haven't quite decided on an approach for allowing others to use the library. Contact me at rayo@ontko.com if you'd like to persue this further. Ray On Sun, Jul 04, 2004 at 04:52:27PM +1000, Steve Cavill wrote: > You should be able to use PRINT CODE-PRINTER=HT which will include whatever > you ask it to. See the chapter on "Working with HTML" in the SQR developers > guide which has an example. > Cheers, Steve. > > -----Original Message----- > From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org > [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On > Behalf Of matunjt@NU.COM > Sent: Saturday, 3 July 2004 5:42 AM > To: sqr-users@sqrug.org > Subject: [sqr-users] Interpreting HTML code in SQR report output > > > > > > > We have a field to include in an SQR report that contains HTML code. Is > there anyway for SQR to interpret the HTML formatting when printing / > rendering the report? Specifically line breaks, bolding, and bullets. We > are able to pull all HTML tags from the output, but we would like to keep > some of the formatting. > > Where are using Report Builder 6.2.1 against Oracle 9i. > > Here is a sample of the field data: > >
    >
  • >
    Working with purchasing to complete contract
    • >
  • >
    Researching issues related to deployment
    • >
      >
    • >
      PC equipment
      • >
    • >
      Network limitations
    >
  • >
    Signed-off on Phase II contract with > vendor
> > This is the output in the actual application that we would like to come > close to: > Working with purchasing to complete contract > Researching issues related to deployment > PC equipment > Network limitations > Signed-off on Phase II contract with vendor > > > Any suggestions? > > Thanks, > Jon Matunas > > > > ********************************************************************** > This e-mail, including any files or attachments transmitted with it, is > confidential and intended for a specific purpose and for use only by the > individual or entity to whom it is addressed. Any disclosure, copying or > distribution of this e-mail or the taking of any action based on its > contents, other than for its intended purpose, is strictly prohibited. If > you have received this e-mail in error, please notify the sender immediately > and delete it from your system. Any views or opinions expressed in this > e-mail are not necessarily those of Northeast Utilities, its subsidiaries > and affiliates (NU). E-mail transmission cannot be guaranteed to be > error-free or secure or free from viruses, and NU disclaims all liability > for any resulting damage, errors, or omissions. > ********************************************************************** > > > _______________________________________________ > 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 ---------------------------------------------------------------------- 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-bounces+sqrusersarch=sqrug.org@sqrug.org Fri Jul 02 14:48:12 2004 From: "Bencke, Gina" Date: Fri, 2 Jul 2004 15:46:24 -0400 Subject: RE: [sqr-users] Output variables with SQL Server Stored Procedures -- Partially solved I finally have the fce_calc_var working. The problem was that #storedProcStatus needed to be declared as INTEGER.=20=20 fce_str_parm still returns a NULL string for $outStr. Does anyone know why? Regards, Gina Bencke FCE Office (216) 416-3492 Home Office (440) 519-0060 email: gina.work@bencke.com -----Original Message----- From: sqr-users-bounces+ginabencke=3Dforestcity.net@sqrug.org [mailto:sqr-users-bounces+ginabencke=3Dforestcity.net@sqrug.org] On Behalf Of Bencke, Gina Sent: Friday, July 02, 2004 12:41 PM To: sqr-users@sqrug.org Subject: [sqr-users] Output variables with SQL Server Stored Procedures First let me say that I know there are many SQRUG postings regarding this topic and I did read and try to apply them. However I cannot get SQL-Server Stored Procedures with output variables to work! declare-variable float #colVariance text $outStr end-declare=20=20 move 'Hotels' to $str execute on-error=3DSQL-Error do=3DPrint-Columns @#storedProcStatus=3D fce_str_parm @entity=3D$str, @outStrVar=3D$outStr OUT into &ENTITY char(30), &ACTUAL float, &PROJECTED float=20 =20=20=20=20 print $outStr (+1,1) show 'Str: <' $outStr '>' =20=20 The above code successfully prints the column values returned from the stored procedure but $outStr is NULL and should not be. While the SQL Analyzer code below works properly, returning a string in @var. declare @var CHAR(30) exec fce_str_parm 'Hotels', @var out select @var The SQR code below fails with an execution error " (SQR 6801) Em2StdString: Null Operand Passed as input" regardless of how I call the stored procedure. The SQL Analyzer code works. move 3.0 to #actual move 5.0 to #projected move 0 to #colVariance execute on-error=3DSQL-Error =20=20=20 @#storedProcStatus=3D fce_calc_var @actual=3D#actual, @projected=3D#projected, @variance=3D#colVariance OUT !fce_calc_var 3, 5, #colVariance OUT=20 =20=20=20=20 !fce_calc_var @actual=3D3, @projected=3D5, @variance=3D#colVar output =20=20=20=20=20 !fce_calc_var 3, 5, #colVar OUT=20 =20 print 'Test 1' (2,1) print #colVar (0, +3) edit 999,999.99 print #storedProcStatus (0, +3) edit 999 declare @var DECIMAL (26,3) exec fce_calc_var 3, 5, @var out select @var Thanks, in advance, for your help. Gina Bencke Bencke Consulting Corporation Office (440) 519-0060 email: gina.work@bencke.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-bounces+sqrusersarch=sqrug.org@sqrug.org Sat Jul 03 06:06:16 2004 From: "Steve Cavill" Subject: RE: [sqr-users] Brio version 6 failed to create report.htm Date: Sat, 3 Jul 2004 20:43:37 +1000 That's usually a problem with your JRE setup. Does the spf get created? Check the sqr.ini files on both machines and make sure you have the right JRE and environment variables set. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Thornton, Robert Sent: Thursday, 1 July 2004 8:19 AM To: sqr-users@sqrug.org Subject: [sqr-users] Brio version 6 failed to create report.htm I have Brio version 6 loaded on a XP machine. When I try to preview a report the htm page fails to create. This works fine on an NT machine. Is this a setting I am over looking or is it an XP issue? Thanks Robert _______________________________________________ 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-bounces+sqrusersarch=sqrug.org@sqrug.org Sat Jul 03 09:28:21 2004 Date: Sat, 3 Jul 2004 07:27:16 -0700 (PDT) From: razeel zaleel Subject: [sqr-users] Printing on 2 diff printer i am trying to print on 2 different printers depending on the criteria in the sqr program, any idea how i can do it in sqr appreciate your help thanx __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Sat Jul 03 13:14:02 2004 From: "the dragon" Subject: RE: [sqr-users] Printing on 2 diff printer Date: Sat, 03 Jul 2004 13:11:30 -0500 using what OS?? PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- i am trying to print on 2 different printers depending on the criteria in the sqr program, any idea how i can do it in sqr appreciate your help thanx _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Sun Jul 04 22:40:13 2004 Date: Sun, 4 Jul 2004 20:37:48 -0700 (PDT) From: razeel zaleel Subject: RE: [sqr-users] Printing on 2 diff printer Windows 2000 PS 8 Oracle Thanks zaleel --- the dragon wrote: > using what OS?? > > > > PSA: Salary <> Slavery. If you earn a salary, your > employer is renting your > services for 40 hours a week, not purchasing your > soul. Your time is the > only real finite asset that you have, and once used > it can never be > recovered, so don't waste it by giving it away. > > "Time is the coin of your life. It is the only coin > you have, and only you > can determine how it will be spent. Be careful lest > you let other people > spend it for you." > > Carl Sandburg > (1878 - 1967) > > ----Original Message Follows---- > > i am trying to print on 2 different printers > depending on the criteria in the sqr program, any > idea > how i can do it in sqr > > appreciate your help > > thanx > > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Tue Jul 06 10:15:16 2004 Subject: RE: [sqr-users] Brio version 6 failed to create report.htm Date: Tue, 6 Jul 2004 10:13:11 -0500 From: "Thornton, Robert" I have tried the following settings at different times in the [Environment:Common] and [JRE] sections. The report still does not create the htm file. The LOG, SPF, and PDF files get created. Am I overlooking a needed setting or is there a permission issue I am not aware of.=20=20=20 SQR_JRE_VER=3D1.1.7 SQR_JRE_EXE=3DC:\Program Files\Brio\JRE\jre117\bin\jre.exe=20 SQR_JRE_VER=3D1.1.8 SQR_JRE_EXE=3DC:\Program Files\Brio\JRE\jre118\bin\jre.exe SQR_JRE_VER=3D1.1.7 SQR_JRE_EXE=3DC:\Program Files\Oracle\jre\1.1.7\bin\jre.exe Thanks=20 Robert -----Original Message----- From: Steve Cavill [mailto:steve.cavill@infoclarity.com.au]=20 Sent: Saturday, July 03, 2004 4:44 AM To: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions. Subject: RE: [sqr-users] Brio version 6 failed to create report.htm That's usually a problem with your JRE setup. Does the spf get created? Check the sqr.ini files on both machines and make sure you have the right JRE and environment variables set. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=3Dinfoclarity.com.au@sqrug.org]On Behalf Of Thornton, Robert Sent: Thursday, 1 July 2004 8:19 AM To: sqr-users@sqrug.org Subject: [sqr-users] Brio version 6 failed to create report.htm I have Brio version 6 loaded on a XP machine. When I try to preview a report the htm page fails to create. This works fine on an NT machine. Is this a setting I am over looking or is it an XP issue? Thanks Robert _______________________________________________ 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-bounces+sqrusersarch=sqrug.org@sqrug.org Tue Jul 06 17:25:35 2004 From: Peter Burton Date: Tue, 6 Jul 2004 15:24:19 -0700 Subject: RE: [sqr-users] Brio version 6 failed to create report.htm Robert, The most likely reason that HTML is not gentting generated is because the JRE is not compatible with the hardware. Try renaming the file SYMJIT.DLL to SYMJIT.DLL_ORG. This file is located in the JRE's BIN directory. Peter > -----Original Message----- > From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org > [mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] > On Behalf > Of Thornton, Robert > Sent: Tuesday, July 06, 2004 11:13 AM > To: This list is for discussion about the SQR database > reportinglanguage > from Hyperion Solutions. > Subject: RE: [sqr-users] Brio version 6 failed to create report.htm > > > I have tried the following settings at different times in the > [Environment:Common] and [JRE] sections. The report still does not > create the htm file. The LOG, SPF, and PDF files get created. Am I > overlooking a needed setting or is there a permission issue I am not > aware of. > > > SQR_JRE_VER=1.1.7 > SQR_JRE_EXE=C:\Program Files\Brio\JRE\jre117\bin\jre.exe > > > SQR_JRE_VER=1.1.8 > SQR_JRE_EXE=C:\Program Files\Brio\JRE\jre118\bin\jre.exe > > > SQR_JRE_VER=1.1.7 > SQR_JRE_EXE=C:\Program Files\Oracle\jre\1.1.7\bin\jre.exe > > > > Thanks > Robert > > > > > -----Original Message----- > From: Steve Cavill [mailto:steve.cavill@infoclarity.com.au] > Sent: Saturday, July 03, 2004 4:44 AM > To: This list is for discussion about the SQR database > reportinglanguage > fromHyperion Solutions. > Subject: RE: [sqr-users] Brio version 6 failed to create report.htm > > That's usually a problem with your JRE setup. Does the spf > get created? > Check the sqr.ini files on both machines and make sure you have the > right > JRE and environment variables set. > Steve. > > -----Original Message----- > From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org > [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On > Behalf Of Thornton, Robert > Sent: Thursday, 1 July 2004 8:19 AM > To: sqr-users@sqrug.org > Subject: [sqr-users] Brio version 6 failed to create report.htm > > > I have Brio version 6 loaded on a XP machine. When I try to preview a > report the htm page fails to create. This works fine on an NT machine. > Is this a setting I am over looking or is it an XP issue? > > Thanks > > Robert > > > _______________________________________________ > 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 > > ************************************************************************ If you have received this e-mail in error, please delete it and notify the sender as soon as possible. The contents of this e-mail may be confidential and the unauthorized use, copying, or dissemination of it and any attachments to it, is prohibited. Internet communications are not secure and Hyperion does not, therefore, accept legal responsibility for the contents of this message nor for any damage caused by viruses. The views expressed here do not necessarily represent those of Hyperion. For more information about Hyperion, please visit our Web site at www.hyperion.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Tue Jul 06 17:33:19 2004 From: Peter Burton Date: Tue, 6 Jul 2004 15:30:10 -0700 Subject: RE: [sqr-users] Brio version 6 failed to create report.htm Robert, Correction, the filename is "SYMCJIT.DLL". Peter > -----Original Message----- > From: Peter Burton > Sent: Tuesday, July 06, 2004 6:24 PM > To: 'This list is for discussion about the SQR database reporting > language from Hyperion Solutions.' > Subject: RE: [sqr-users] Brio version 6 failed to create report.htm > > > Robert, > > The most likely reason that HTML is not gentting generated is > because the JRE is not compatible with the hardware. Try > renaming the file SYMJIT.DLL to SYMJIT.DLL_ORG. This file is > located in the JRE's BIN directory. > > Peter > > > -----Original Message----- > > From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org > > [mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] > > On Behalf > > Of Thornton, Robert > > Sent: Tuesday, July 06, 2004 11:13 AM > > To: This list is for discussion about the SQR database > > reportinglanguage > > from Hyperion Solutions. > > Subject: RE: [sqr-users] Brio version 6 failed to create report.htm > > > > > > I have tried the following settings at different times in the > > [Environment:Common] and [JRE] sections. The report still does not > > create the htm file. The LOG, SPF, and PDF files get created. Am I > > overlooking a needed setting or is there a permission issue I am not > > aware of. > > > > > > SQR_JRE_VER=1.1.7 > > SQR_JRE_EXE=C:\Program Files\Brio\JRE\jre117\bin\jre.exe > > > > > > SQR_JRE_VER=1.1.8 > > SQR_JRE_EXE=C:\Program Files\Brio\JRE\jre118\bin\jre.exe > > > > > > SQR_JRE_VER=1.1.7 > > SQR_JRE_EXE=C:\Program Files\Oracle\jre\1.1.7\bin\jre.exe > > > > > > > > Thanks > > Robert > > > > > > > > > > -----Original Message----- > > From: Steve Cavill [mailto:steve.cavill@infoclarity.com.au] > > Sent: Saturday, July 03, 2004 4:44 AM > > To: This list is for discussion about the SQR database > > reportinglanguage > > fromHyperion Solutions. > > Subject: RE: [sqr-users] Brio version 6 failed to create report.htm > > > > That's usually a problem with your JRE setup. Does the spf > > get created? > > Check the sqr.ini files on both machines and make sure you have the > > right > > JRE and environment variables set. > > Steve. > > > > -----Original Message----- > > From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org > > [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On > Behalf Of Thornton, Robert > Sent: Thursday, 1 July 2004 8:19 AM > To: sqr-users@sqrug.org > Subject: [sqr-users] Brio version 6 failed to create report.htm > > > I have Brio version 6 loaded on a XP machine. When I try to preview a > report the htm page fails to create. This works fine on an NT machine. > Is this a setting I am over looking or is it an XP issue? > > Thanks > > Robert > > > _______________________________________________ > 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 > > ************************************************************************ If you have received this e-mail in error, please delete it and notify the sender as soon as possible. The contents of this e-mail may be confidential and the unauthorized use, copying, or dissemination of it and any attachments to it, is prohibited. Internet communications are not secure and Hyperion does not, therefore, accept legal responsibility for the contents of this message nor for any damage caused by viruses. The views expressed here do not necessarily represent those of Hyperion. For more information about Hyperion, please visit our Web site at www.hyperion.com _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Mon Jul 05 07:26:02 2004 Subject: RE: [sqr-users] Subscription to Exceptions From: "Darshil Mehta" Date: Mon, 5 Jul 2004 17:56:02 +0530 I checked both. I get emails whenever do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message My object's life is 500 mins. Is there any code that I have write in .sqr file to get email notifications only whenever there is exceptions? Thanks, Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 30/06/2004 05:52 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Do you get an email if you just subscribe to the report without exceptions? Do any other subscription emails work? You need to see which is failing, the detection of the exception, or the sending of the email. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Wednesday, 30 June 2004 6:58 PM To: sqr-users@sqrug.org Subject: [sqr-users] Subscription to Exceptions All, I have one SQR report in which I have written following code: if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if When I publish this report on Brio Portal with option 'Can have exception', I can see proper exceptions on my Brio Portal dashboard. But when I schedule it with email notification, I do not receive any email regarding exception. Can anyone suggest what could be the problem? Thanks in advance. Best regards, Darshil Mehta ______________________________________________________________________ _______________________________________________ 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-bounces+sqrusersarch=sqrug.org@sqrug.org Mon Jul 05 22:59:06 2004 From: "Steve Cavill" Subject: RE: [sqr-users] Subscription to Exceptions Date: Tue, 6 Jul 2004 11:49:59 +1000 Now I'm confused. Below you say you are getting the email, but earlier you said you are not getting the email. Do you mean you are getting the email whether there is an exception or not, and that you DO NOT want to get a message UNLESS there is an exception? In which case your setup below looks correct. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Monday, 5 July 2004 10:26 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Cc: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions.; sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org Subject: RE: [sqr-users] Subscription to Exceptions I checked both. I get emails whenever do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message My object's life is 500 mins. Is there any code that I have write in .sqr file to get email notifications only whenever there is exceptions? Thanks, Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 30/06/2004 05:52 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Do you get an email if you just subscribe to the report without exceptions? Do any other subscription emails work? You need to see which is failing, the detection of the exception, or the sending of the email. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Wednesday, 30 June 2004 6:58 PM To: sqr-users@sqrug.org Subject: [sqr-users] Subscription to Exceptions All, I have one SQR report in which I have written following code: if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if When I publish this report on Brio Portal with option 'Can have exception', I can see proper exceptions on my Brio Portal dashboard. But when I schedule it with email notification, I do not receive any email regarding exception. Can anyone suggest what could be the problem? Thanks in advance. Best regards, Darshil Mehta ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Mon Jul 05 23:07:23 2004 Subject: RE: [sqr-users] Subscription to Exceptions From: "Darshil Mehta" Date: Tue, 6 Jul 2004 09:37:39 +0530 Sorry for the confusion !!! Let me put it this way. I do get mails when I do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message If I don't do above action, I don't get mails. And if I do above action, I still get mails even there is no exception. I hope this is more clear. Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 06/07/2004 07:19 AM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Now I'm confused. Below you say you are getting the email, but earlier you said you are not getting the email. Do you mean you are getting the email whether there is an exception or not, and that you DO NOT want to get a message UNLESS there is an exception? In which case your setup below looks correct. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Monday, 5 July 2004 10:26 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Cc: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions.; sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org Subject: RE: [sqr-users] Subscription to Exceptions I checked both. I get emails whenever do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message My object's life is 500 mins. Is there any code that I have write in .sqr file to get email notifications only whenever there is exceptions? Thanks, Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 30/06/2004 05:52 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Do you get an email if you just subscribe to the report without exceptions? Do any other subscription emails work? You need to see which is failing, the detection of the exception, or the sending of the email. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Wednesday, 30 June 2004 6:58 PM To: sqr-users@sqrug.org Subject: [sqr-users] Subscription to Exceptions All, I have one SQR report in which I have written following code: if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if When I publish this report on Brio Portal with option 'Can have exception', I can see proper exceptions on my Brio Portal dashboard. But when I schedule it with email notification, I do not receive any email regarding exception. Can anyone suggest what could be the problem? Thanks in advance. Best regards, Darshil Mehta ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Tue Jul 06 03:55:18 2004 From: "Steve Cavill" Subject: RE: [sqr-users] Subscription to Exceptions Date: Tue, 6 Jul 2004 16:33:52 +1000 Your sqr code will ALWAYS generate an exception: if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if The exception is either "Prodline has changes", or "Prodline has NO changes" so I think the portal is working correctly. If one of the above conditions is NOT an exception, then don't create the output.properties file for that condition. Cheers, Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Tuesday, 6 July 2004 2:08 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Cc: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions.; sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org Subject: RE: [sqr-users] Subscription to Exceptions Sorry for the confusion !!! Let me put it this way. I do get mails when I do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message If I don't do above action, I don't get mails. And if I do above action, I still get mails even there is no exception. I hope this is more clear. Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 06/07/2004 07:19 AM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Now I'm confused. Below you say you are getting the email, but earlier you said you are not getting the email. Do you mean you are getting the email whether there is an exception or not, and that you DO NOT want to get a message UNLESS there is an exception? In which case your setup below looks correct. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Monday, 5 July 2004 10:26 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Cc: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions.; sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org Subject: RE: [sqr-users] Subscription to Exceptions I checked both. I get emails whenever do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message My object's life is 500 mins. Is there any code that I have write in .sqr file to get email notifications only whenever there is exceptions? Thanks, Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 30/06/2004 05:52 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Do you get an email if you just subscribe to the report without exceptions? Do any other subscription emails work? You need to see which is failing, the detection of the exception, or the sending of the email. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Wednesday, 30 June 2004 6:58 PM To: sqr-users@sqrug.org Subject: [sqr-users] Subscription to Exceptions All, I have one SQR report in which I have written following code: if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if When I publish this report on Brio Portal with option 'Can have exception', I can see proper exceptions on my Brio Portal dashboard. But when I schedule it with email notification, I do not receive any email regarding exception. Can anyone suggest what could be the problem? Thanks in advance. Best regards, Darshil Mehta ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Tue Jul 06 05:10:07 2004 Subject: RE: [sqr-users] Subscription to Exceptions From: "Darshil Mehta" Date: Tue, 6 Jul 2004 15:24:31 +0530 A minor correction in code. In else part, I have changed exception.default=off from exception.default=on. if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=off' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if Now this code works perfectly on portal. Whenever there is exception, exception dashboard shows exception. Otherwise it does not. But when I do following, I do get mails: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message If I don't do above action, I don't get mails. And if I do above action, I still get mails even there is no exception. Thanks, Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 06/07/2004 12:03 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Your sqr code will ALWAYS generate an exception: if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if The exception is either "Prodline has changes", or "Prodline has NO changes" so I think the portal is working correctly. If one of the above conditions is NOT an exception, then don't create the output.properties file for that condition. Cheers, Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Tuesday, 6 July 2004 2:08 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Cc: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions.; sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org Subject: RE: [sqr-users] Subscription to Exceptions Sorry for the confusion !!! Let me put it this way. I do get mails when I do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message If I don't do above action, I don't get mails. And if I do above action, I still get mails even there is no exception. I hope this is more clear. Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 06/07/2004 07:19 AM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Now I'm confused. Below you say you are getting the email, but earlier you said you are not getting the email. Do you mean you are getting the email whether there is an exception or not, and that you DO NOT want to get a message UNLESS there is an exception? In which case your setup below looks correct. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Monday, 5 July 2004 10:26 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Cc: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions.; sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org Subject: RE: [sqr-users] Subscription to Exceptions I checked both. I get emails whenever do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message My object's life is 500 mins. Is there any code that I have write in .sqr file to get email notifications only whenever there is exceptions? Thanks, Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 30/06/2004 05:52 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Do you get an email if you just subscribe to the report without exceptions? Do any other subscription emails work? You need to see which is failing, the detection of the exception, or the sending of the email. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Wednesday, 30 June 2004 6:58 PM To: sqr-users@sqrug.org Subject: [sqr-users] Subscription to Exceptions All, I have one SQR report in which I have written following code: if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if When I publish this report on Brio Portal with option 'Can have exception', I can see proper exceptions on my Brio Portal dashboard. But when I schedule it with email notification, I do not receive any email regarding exception. Can anyone suggest what could be the problem? Thanks in advance. Best regards, Darshil Mehta ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Sat Jul 10 00:34:13 2004 From: "Steve Cavill" Subject: RE: [sqr-users] Subscription to Exceptions Date: Sat, 10 Jul 2004 15:31:29 +1000 Hi Darshil, i don't think exception.default=off is a valid string in your output.properties. If you don't want an exception, don't write to the file. e.g. if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) !don't create output.properties end-if -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Tuesday, 6 July 2004 7:55 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Cc: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions.; sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org Subject: RE: [sqr-users] Subscription to Exceptions A minor correction in code. In else part, I have changed exception.default=off from exception.default=on. if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=off' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if Now this code works perfectly on portal. Whenever there is exception, exception dashboard shows exception. Otherwise it does not. But when I do following, I do get mails: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message If I don't do above action, I don't get mails. And if I do above action, I still get mails even there is no exception. Thanks, Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 06/07/2004 12:03 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Your sqr code will ALWAYS generate an exception: if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if The exception is either "Prodline has changes", or "Prodline has NO changes" so I think the portal is working correctly. If one of the above conditions is NOT an exception, then don't create the output.properties file for that condition. Cheers, Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Tuesday, 6 July 2004 2:08 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Cc: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions.; sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org Subject: RE: [sqr-users] Subscription to Exceptions Sorry for the confusion !!! Let me put it this way. I do get mails when I do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message If I don't do above action, I don't get mails. And if I do above action, I still get mails even there is no exception. I hope this is more clear. Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 06/07/2004 07:19 AM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Now I'm confused. Below you say you are getting the email, but earlier you said you are not getting the email. Do you mean you are getting the email whether there is an exception or not, and that you DO NOT want to get a message UNLESS there is an exception? In which case your setup below looks correct. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Monday, 5 July 2004 10:26 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Cc: This list is for discussion about the SQR database reportinglanguage fromHyperion Solutions.; sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org Subject: RE: [sqr-users] Subscription to Exceptions I checked both. I get emails whenever do following: On brio portal, under subscription: - Click subscribe to 'Subscribe to output from ' - Click 'Only subscribe to exception item' - Attach output from to email message My object's life is 500 mins. Is there any code that I have write in .sqr file to get email notifications only whenever there is exceptions? Thanks, Darshil "Steve Cavill" Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org 30/06/2004 05:52 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." To: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." cc: Subject: RE: [sqr-users] Subscription to Exceptions Do you get an email if you just subscribe to the report without exceptions? Do any other subscription emails work? You need to see which is failing, the detection of the exception, or the sending of the email. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On Behalf Of Darshil Mehta Sent: Wednesday, 30 June 2004 6:58 PM To: sqr-users@sqrug.org Subject: [sqr-users] Subscription to Exceptions All, I have one SQR report in which I have written following code: if #cnt_total > #temp print 'Exception: Prodline has changed' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has changes' close 0 else print 'Exception: Prodline has NO changes ' (1,1) open 'output.properties' as 0 for-append record=32767:vary write 0 from 'exception.default=on' write 0 from 'exception.default.text=Prodline has NO changes' close 0 end-if When I publish this report on Brio Portal with option 'Can have exception', I can see proper exceptions on my Brio Portal dashboard. But when I schedule it with email notification, I do not receive any email regarding exception. Can anyone suggest what could be the problem? Thanks in advance. Best regards, Darshil Mehta ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ______________________________________________________________________ ______________________________________________________________________ _______________________________________________ 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-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 04:24:49 2004 Date: Wed, 7 Jul 2004 11:20:50 +0200 (CEST) From: =?iso-8859-1?q?Nabil?= Subject: [sqr-users] Various printing types in the same program Hi, I got a SQR program writing at the same time in a CSV and in a PDF files. Do you know if it's possible to add a third writing for direct HP printing (while writing the two files on the disk) ? Thanks from Paris. Nabil --------------------------------- Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! Créez votre Yahoo! Mail Dialoguez en direct avec vos amis grâce à Yahoo! Messenger ! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 06:56:17 2004 From: "the dragon" Subject: RE: [sqr-users] Various printing types in the same program Date: Wed, 07 Jul 2004 06:54:48 -0500 Nabil, I do not believethis to be possible, without running the program twice or cloning it. Why would you need to? The pdf can be printed..... peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) NOTICE: The information contained in this message is protected under United States and international copyright laws and is intended for the personal and confidential use of the addressee. If you are not the addressee or an agent of the addressee, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, taking of any action in reliance upon or copying of this message without the express written permission of the sender or his agent is strictly prohibited and in violation of reference ----Original Message Follows---- Hi, I got a SQR program writing at the same time in a CSV and in a PDF files. Do you know if it's possible to add a third writing for direct HP printing (while writing the two files on the disk) ? Thanks from Paris. Nabil _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 08:32:27 2004 Date: Wed, 7 Jul 2004 15:30:09 +0200 (CEST) From: =?iso-8859-1?q?Nabil?= Subject: RE: [sqr-users] Various printing types in the same program Thanks Clark. Maybe, I can generate a SPF file which I can transform for direct printing and Pdf as the same time... the dragon wrote: Nabil, I do not believethis to be possible, without running the program twice or cloning it. Why would you need to? The pdf can be printed..... peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) NOTICE: The information contained in this message is protected under United States and international copyright laws and is intended for the personal and confidential use of the addressee. If you are not the addressee or an agent of the addressee, you are hereby notified that you have received this message in error and that any review, dissemination, distribution, taking of any action in reliance upon or copying of this message without the express written permission of the sender or his agent is strictly prohibited and in violation of reference ----Original Message Follows---- Hi, I got a SQR program writing at the same time in a CSV and in a PDF files. Do you know if it's possible to add a third writing for direct HP printing (while writing the two files on the disk) ? Thanks from Paris. Nabil --------------------------------- Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! Créez votre Yahoo! Mail Dialoguez en direct avec vos amis grâce à Yahoo! Messenger ! _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 08:27:50 2004 From: "David Ellick" Subject: Re: [sqr-users] Various printing types in the same program Date: Wed, 7 Jul 2004 13:59:04 +0100 Nabil, Try generating the output initially as an SPF. Then you can use the new-report command to close the file and call SQRWP to convert the SPF to any format you want. This definitely works in Windows. Basically, Begin-Program !fred.sqr do some_stuff new-report 'dummy.lis' call system using 'sqrwp.exe fred.spf -printer:pd' #x call system using 'sqrwp.exe fred.spf -printer:hp' #x End-Program You can use this approach to generate any number of output types. Alternatively enclose the SQR in a script and call SQRWP in the script. Whichever will be more supportable in your business. David ----- Original Message ----- From: "Nabil" To: Sent: Wednesday, July 07, 2004 10:20 AM Subject: [sqr-users] Various printing types in the same program > Hi, > > I got a SQR program writing at the same time in a CSV and in a PDF files. Do you know if it's possible to add a third writing for direct HP printing (while writing the two files on the disk) ? > > Thanks from Paris. > > Nabil > > > --------------------------------- > Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! > Créez votre Yahoo! Mail > > Dialoguez en direct avec vos amis grâce à Yahoo! Messenger ! > > _______________________________________________ > 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-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 09:22:11 2004 Date: Wed, 07 Jul 2004 10:20:58 -0400 From: "Jessie Dickenson" Subject: [sqr-users] Unable to create SPF file. I encountered a problem yesterday when I was trying to generate an SPF file= .=20 =20 The command I used to make the SQT file was: C:\Program Files\Brio\SQR\ORA\BINW\sqrw.exe C:SQR\6002.SQR user_name/passwo= rd@database_name -rs *nolis I also tried using the flags, -xcb -ziv with the command line. The SQT fi= le gets created allright. But when I run the SQT, instead of getting an SPF= file, a lis file is getting generated. Have I missed something critical wh= ile compiling the SQR program? I would greatly appreciate your help. Thanks= in advance.Jessie =20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 09:31:27 2004 From: "the dragon" Subject: RE: [sqr-users] Unable to create SPF file. Date: Wed, 07 Jul 2004 09:30:27 -0500 Jesse, ummmmm try the -keep switch??? when you run it. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- I encountered a problem yesterday when I was trying to generate an SPF file. The command I used to make the SQT file was: C:\Program Files\Brio\SQR\ORA\BINW\sqrw.exe C:SQR\6002.SQR user_name/password@database_name -rs *nolis I also tried using the flags, -xcb -ziv with the command line. The SQT file gets created allright. But when I run the SQT, instead of getting an SPF file, a lis file is getting generated. Have I missed something critical while compiling the SQR program? I would greatly appreciate your help. Thanks in advance.Jessie _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 10:02:13 2004 Date: Wed, 07 Jul 2004 11:00:48 -0400 From: "Jessie Dickenson" Subject: RE: [sqr-users] Unable to create SPF file. Thank you so much. That worked just fine. Actually the whole command that I= used was: sqrwt.exe filename.SQT username/password@databasename -keep *nolis *xcb *z= iv $input_param =20 This way, I suppress the creation of the LIS file & the SPF file comes up, = once the run is over. =20 Thanks again, Jess >>> "the dragon" 07/07/2004 10:30:27 AM >>> Jesse, ummmmm try the -keep switch??? when you run it. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting you= r=20 services for 40 hours a week, not purchasing your soul. Your time is the= =20 only real finite asset that you have, and once used it can never be=20 recovered, so don't waste it by giving it away. "Time is the coin of your life. It is the only coin you have, and only you= =20 can determine how it will be spent. Be careful lest you let other people= =20 spend it for you." Carl Sandburg (1878 - 1967) ----Original Message Follows---- I encountered a problem yesterday when I was trying to generate an SPF file. The command I used to make the SQT file was: C:\Program Files\Brio\SQR\ORA\BINW\sqrw.exe C:SQR\6002.SQR=20 user_name/password@database_name -rs *nolis I also tried using the flags, -xcb -ziv with the command line. The SQT=20 file gets created allright. But when I run the SQT, instead of getting an= =20 SPF file, a lis file is getting generated. Have I missed something critical= =20 while compiling the SQR program? I would greatly appreciate your help.=20 Thanks in advance.Jessie _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 15:26:17 2004 From: CAllo@hinda.com Date: Wed, 7 Jul 2004 15:25:12 -0500 Subject: [sqr-users] Subselect I don't have very detailed information on the begin-select construct and my question is as follows: In SQL, you can do "subselects" like SELECT Date, (Select total From Acct Where...), Name, ..... FROM ..... I am wondering if it is possible to accomplish something of the sort in a begin-select paragraph? Christopher Allo PeopleSoft Specialist x-3348 This communication is for the exclusive use of addressee and may contain confidential, proprietary or privileged information which may be used exclusively for its intended purpose. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication, and destroy all copies. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 15:35:56 2004 Subject: RE: [sqr-users] Subselect Date: Wed, 7 Jul 2004 15:34:52 -0500 From: "Knapp, Richard" Yup.=20 -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of CAllo@hinda.com Sent: Wednesday, July 07, 2004 3:25 PM To: sqr-users@sqrug.org Subject: [sqr-users] Subselect I don't have very detailed information on the begin-select construct and my question is as follows: In SQL, you can do "subselects" like SELECT Date, (Select total From Acct Where...), Name, ..... FROM ..... I am wondering if it is possible to accomplish something of the sort in a begin-select paragraph? Christopher Allo PeopleSoft Specialist x-3348 This communication is for the exclusive use of addressee and may contain confidential, proprietary or privileged information which may be used exclusively for its intended purpose. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication, and destroy all copies. _______________________________________________ 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-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 15:58:47 2004 Subject: RE: [sqr-users] Subselect From: CAllo@hinda.com Date: Wed, 7 Jul 2004 15:56:22 -0500 Do you have an example of how this would be accomplished? I greatly appreciate your help. "Knapp, Richard" To Sent by: "This list is for discussion about sqr-users-bounces the SQR database reportinglanguage +callo=hinda.com@ from Hyperion Solutions." sqrug.org cc 07/07/2004 03:34 Subject PM RE: [sqr-users] Subselect Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." Yup. -----Original Message----- From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of CAllo@hinda.com Sent: Wednesday, July 07, 2004 3:25 PM To: sqr-users@sqrug.org Subject: [sqr-users] Subselect I don't have very detailed information on the begin-select construct and my question is as follows: In SQL, you can do "subselects" like SELECT Date, (Select total From Acct Where...), Name, ..... FROM ..... I am wondering if it is possible to accomplish something of the sort in a begin-select paragraph? Christopher Allo PeopleSoft Specialist x-3348 This communication is for the exclusive use of addressee and may contain confidential, proprietary or privileged information which may be used exclusively for its intended purpose. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication, and destroy all copies. _______________________________________________ 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 This communication is for the exclusive use of addressee and may contain confidential, proprietary or privileged information which may be used exclusively for its intended purpose. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication, and destroy all copies. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 15:48:07 2004 Date: Wed, 07 Jul 2004 16:45:56 -0400 From: "Larry Roux" Subject: Re: [sqr-users] Subselect Yes, just put a variable at the end of the subselect - ie begin-select A.DATE (select ID from TABLE_X where NAME =3D 'FRED') &ID A.ADDRESS_LINE1 show ' Date =3D ' &A.DATE ' ID =3D ' &ID=20 from ADDRESSES A where A.ADDRESS_TYPE =3D 'HOME' end-select Larry Roux Syracuse University lroux@syr.edu >>> CAllo@hinda.com 07/07/04 16:28 PM >>> I don't have very detailed information on the begin-select construct and my question is as follows: In SQL, you can do "subselects" like SELECT Date, (Select total From Acct Where...), Name, ...... FROM ...... I am wondering if it is possible to accomplish something of the sort in a begin-select paragraph? Christopher Allo PeopleSoft Specialist x-3348 This communication is for the exclusive use of addressee and may contain confidential, proprietary or privileged information which may be used exclusively for its intended purpose. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication, and destroy all copies. _______________________________________________ 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-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 16:20:31 2004 Subject: Re: [sqr-users] Subselect From: CAllo@hinda.com Date: Wed, 7 Jul 2004 16:18:07 -0500 Thanks a bunch. I have tried it and it works as shown, however, the subselect I am trying to do is a "sum" and it looks like SQR doesn't like that. i.e. begin-select A.DATE (select sum(amount) from TABLE_X where NAME = 'FRED') &ID By the way, the reason I'm trying to do this is so that I can ORDER BY A.DATE, &ID. I know I could call separate procedures to go and get this information, but then I am not able to sort the data unless I build some sort of temp table or views. I wanted to be able to just return everything I need in this one select and sort accordingly and then print. Any further thoughts? Christopher Allo PeopleSoft Specialist x-3348 "Larry Roux" Sent by: To sqr-users-bounces +callo=hinda.com@ cc sqrug.org Subject Re: [sqr-users] Subselect 07/07/2004 03:45 PM Please respond to "This list is for discussion about the SQR database reporting language from Hyperion Solutions." Yes, just put a variable at the end of the subselect - ie begin-select A.DATE (select ID from TABLE_X where NAME = 'FRED') &ID A.ADDRESS_LINE1 show ' Date = ' &A.DATE ' ID = ' &ID from ADDRESSES A where A.ADDRESS_TYPE = 'HOME' end-select Larry Roux Syracuse University lroux@syr.edu >>> CAllo@hinda.com 07/07/04 16:28 PM >>> I don't have very detailed information on the begin-select construct and my question is as follows: In SQL, you can do "subselects" like SELECT Date, (Select total From Acct Where...), Name, ...... FROM ...... I am wondering if it is possible to accomplish something of the sort in a begin-select paragraph? Christopher Allo PeopleSoft Specialist x-3348 This communication is for the exclusive use of addressee and may contain confidential, proprietary or privileged information which may be used exclusively for its intended purpose. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication, and destroy all copies. _______________________________________________ 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 This communication is for the exclusive use of addressee and may contain confidential, proprietary or privileged information which may be used exclusively for its intended purpose. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication, and destroy all copies. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces+sqrusersarch=sqrug.org@sqrug.org Wed Jul 07 16:08:40 2004 Subject: RE: [sqr-users] Subselect Date: Wed, 7 Jul 2004 16:07:26 -0500 From: "Knapp, Richard" Just write your sql and enclose the entire paragraph in begin-(select)/end-select and that in begin-procedure/end-procedure. Call this procedure from a begin-program procedure. If it's bonafide SQL, it should work in SQR. Sometimes it is simpler to do the work of a subquery in another paragraph that you call from within the original select: Begin-select A &a_var B &b_var C &c_var do the_other_procedure =46rom some_table Where something =3D somethingelse and etc.... End-select Richard Knapp Database Programmer/Analyst Institutional Research and Planning University of Missouri System 573-882-8856 knappr@umsystem.edu =20 -----Original Message----- From: sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org [mailto:sqr-users-bounces+knappr=3Dumsystem.edu@sqrug.org] On Behalf Of CAllo@hinda.com Sent: Wednesday, July 07, 2004 3:56 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] Subselect Do you have an example of how this would be accomplished? I greatly appreciate your help. =20 "Knapp, Richard"