[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



By removing the lines when='D' and when'E', I believe you will actually 
change the way this evaluate works.
It appears that the original author does not want anything to occur if D 
or E.  By removing the when's, then a D or E would fall into the OTHER 
clause.

You would think that a break is needed but it appears that the when-other 
is handled a little bit differently.

So, the question is:  Should anything happen when D or E.  If the answer 
is no, then I would leave it alone or perhaps put a break after the 
when='E' for better clarity.  If the answer is, it should do the "other", 
then you would want to remove the when's.

Rick Hansen
Sr. Application Systems Analyst

D - (563) 333-2321, F - (563) 324-0211

________________________________________________________________________________
This e-mail is only intended for the person(s) to whom it is addressed and 
may contain confidential information. Unless stated to the contrary, any 
opinions or comments are personal to the writer and do not represent the 
official view of the company. If you have received this e-mail in error, 
please notify us immediately by reply e-mail and then delete this message 
from your system. Please do not copy it or use it for any purposes, or 
disclose its contents to any other person. Thank you for your cooperation.




"radhika reddy" <radhika_05@hotmail.com>
Sent by: 
sqr-users-bounces+rick.hansen=rsmi.com@sqrug.org
04/20/2005 10:09 AM

Please respond to "This list is for discussion about the SQR database 
reporting language from Hyperion Solutions." 

 
        To:     sqr-users@sqrug.org
        cc: 
        Subject:        [sqr-users] Evaluate - When


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