[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Help needed
- Subject: [sqr-users] Help needed
- From: Deepu <pradeepkanneganti@yahoo.com>
- Date: Thu, 28 Oct 2004 15:03:52 -0700 (PDT)
- Cc:
- Delivery-date: Thu, 28 Oct 2004 17:05:03 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi all,
I'm trying to run a crytal report and when I enter the month and yeay in the
prompt i'm getting an error message saying that the month should be between 1
and 12...even though it is.
Then I get this window where it shows the following code..
({WORN_LET.ORIG_HIRE_DT}>=Date ({WORN_LET.:1 }-1, {WORN_LET.:2 }, 1) or
{WORN_LET.REHIRE_DT}>=Date ({WORN_LET.:1 }-1, {WORN_LET.:2 }, 1)) and
(
(not ({WORN_LET.JOBCODE} in ["22085", "22087", "22108"]) and
(({WORN_LET.:1}*12+{WORN_LET.:2}-Year ({@doh})*12-Month ({@doh}))=4 and
{WORN_LET.STD_HOURS} < 21 or
({WORN_LET.:1}*12+{WORN_LET.:2}-Year ({@doh})*12-Month ({@doh}))=3 and
{WORN_LET.STD_HOURS} >=21))
or
({WORN_LET.JOBCODE} in ["22085", "22087", "22108"] and
({WORN_LET.:1}*12+{WORN_LET.:2}-Year ({@doh})*12-Month ({@doh}))=6)
)
can any one pls throw some light ..
Thanks
Deepu
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users