[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] Evaluate - When




Thanks for replying. I opened a ticket with peoplesoft. This Sqr is in 
Health & Safety and the name of Sqr is OHS019.

It should definetly go into the processing section when value is D or E.

Will update.

Thanks.


>From: "Jamie Harris" <JHarris@frederick.edu>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] Evaluate - When
>Date: Wed, 20 Apr 2005 11:21:34 -0400
>
>That's strange. :)
>
>It looks like it should fall-through into the when-other if the value
>is D or E.  I guess the programmer at Peoplesoft thought that's what it
>would do (and didn't test it!).
>
>You are correct about needing to remove the when = 'D' and when = 'E'.
>I would open a case with PS though, and let them know what you found and
>what you did to correct it.
>
>What PS delivered SQR was this in?
>
>
>-----------------------------------------------------
>James Harris
>Junior Systems Programmer/Analyst
>Information Technology Division
>Frederick Community College
>-----------------------------------------------------
>
> >>> radhika_05@hotmail.com 4/20/2005 11:09 AM >>>
>
>Hi,
>
>    I am having a problem with delivered SQR. It has Evaluate Statement
>which
>codes like the following:
>
>Evaluate &Paygroup
>when = 'A'
>     ! processing A
>     break;
>when = 'B'
>when = 'C'
>     !processing B or C
>     Break;
>when = 'D'
>when = 'E'
>when-other
>     ! processing D or E or other
>     Break;
>End-Evaluate
>
>     Here when the value of paygroup is B or C it goes into processing B
>or
>C. But when the value is D or E it doesn't go to Processing D or E or
>other.
>
>I can remove the lines of code when = 'D' and when = 'E' . But before
>making
>changes to the delivered one, i would like to know is there any reason
>for
>peoplesoft to code like this?
>
>Any input would be appreciated.
>
>Thanks.
>
>_________________________________________________________________
>Express yourself instantly with MSN Messenger! Download today - it's
>FREE!
>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>
>_______________________________________________
>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

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


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