RE: [sqr-users] Training question

["Chris Allo" <CAllo@hinda.com>]

Hi Laura
Sorry that your request for help has ended up with a lot of useless comments 
(want to go to the bathroom, smoking stuff, etc etc.).  If you hate sqr, 
peoplesoft, or both, that's fine - All the lady wanted was some help.

I'm not sure what version of PS they are familiar with, and while PS's SQRs 
might boilerplate or whatever else, they can be a good start if you are just 
beginning with sqr...then you can go on to the more fancy features (if you even 
call it fancy) of sqr.  There was a time I knew nothing of SQR and believe it 
or not, I got going fairly quickly thru exposure to PS's sqrs.  By the way, I 
am doing a version 8 implementation of PS right now and will be going live in a 
month and haven't had to "fix" any of their delivered sqrs...so they are a 
decent baseline which you can use.  If you are on PS, pick a simple report like 
OMS1000 or something of that nature to see simple report formatting - make sure 
the sql you have in your procedure(s) actually returns data thru whatever sql 
tool you use.

On the other hand, if one of these folks wants to take the time to teach you 
sqr and help debug your code, then ignore my comments above.

Chris

-----Original Message-----
From: sqr-users-bounces+callo=hinda.com@sqrug.org@HINDACORP On Behalf Of 
"Everett Carr" <ECARR@holycross.edu>
Sent: Monday, July 24, 2006 2:30 PM
To: This list is for discussion about the SQR database reporting language from 
Hyperion Solutions.
Subject: RE: [sqr-users] Training question

Pleasse, you REALLY should have warned me to go to the bathroom and relieve 
myself before reading this.

Peoplesoft TEST?   A company that on multiple occassions that ships source code 
that won't even compile due to syntax errors........  I don't need whatever it 
is you've been smoking.



>>> Sam Spritzer <teknogeek9@yahoo.com> 7/24/2006 3:22 PM >>>
Richard,
  I might agree although not completely.  The PS SQRs are a good basis because 
they utilize SQLs that are tested and tried.  Its a good start in the sense 
that you know that the data you are looking for is valid.
  Sam

"Knapp, Richard" <KnappR@umsystem.edu> wrote:
  
I'm sorry to contradict, Sam, but for someone who has no experience in SQR, I 
think you are recommending a season in hell. I had 5 years of SQR before I 
encountered the PS reports and still it was hellacious (in the extreme.) It is 
all boilerplate. There is not a breath of fresh air to be had. It reads like 
some long winded legal document whose purpose is not to clarify but to wear 
down the reader.

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu 


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org 
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of Sam 
Spritzer
Sent: Monday, July 24, 2006 1:57 PM
To: This list is for discussion about the SQR database reporting languagefrom 
Hyperion Solutions.
Subject: RE: [sqr-users] Training question

Laura,
I am not sure what system you are on but if its Peoplesoft, you would probably 
want to look at their delivered reports and clone based on that. 
SQRly yours,
Sam

Laura Mayer wrote:
Unfortunately I don't have any "good examples". I've been told that my 
predecessor wrote bad code and I need to rewrite it. That's my 
conundrum...finding a good resource to find out how to do it right. 

>>> KnappR@umsystem.edu 7/24/2006 2:49:24 PM >>>

If you are an experienced programmer, just find some examples - hopefully of 
good code. Peoplesoft will not be much help there. SQR is a very simple 
language but there are a few gotchas. One I can think of is - if your SQL 
select block does not return any rows, no code in that block will be executed. 
On the other hand, no new language will be all that easy without some help - 
either good examples or some experienced person to ask questions of or some 
text or, best of all, all of those.
("Simple ain't easy." - Duke Ellington)

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu 

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of Laura 
Mayer
Sent: Monday, July 24, 2006 11:01 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Training question

Does anyone know where I would be able to find some kind of training in SQR 
coding? I feel like I'm drowning here. I've been working on this one report for 
almost a month and am still not finished. 

I've only been able to find one book written on it and no tutorials out there. 

I've looked online and can't seem to find any resources at all.

Thanks for any thoughts. 

Laura


_______________________________________________
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 



************************************************************
"In the beginning, there was something...which exploded yet, they find nothing."

---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ 
countries) for 2¢/min or less.

_______________________________________________
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 



************************************************************
"In the beginning, there was something...which exploded yet, they find nothing."
                
---------------------------------
How low will we go? Check out Yahoo! Messenger's low  PC-to-Phone call rates.

_______________________________________________
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

Here was a non admissible message part of 'application/ms-tnef' MIME
type. It has been automatically discarded before sending the message to
the list. 
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users