It still doesnot work.
I created a Parameter field called ?PERIOD.
It works for UpperCase values only.
How can I make it work for anycase. Iam on Crystal 8.5 and Oracle 9i.
Please Advice.
Thanks
I have a Parameter field called PeriodID.
This is a concatenation of MONYYYY. This is stored in the database as uppercase as JAN2003.
If my users enter jan2003 in lower case how can I make sure that it gets converted to Uppercase before it runs the query at the database???
Please Help.
Thanks
I have group header on a report that I want to show on every page till the group ends.
On new group I want a page break and show it on a different page How do I do this????
Thanks
WildRancher
Reebo
When I try to put the following into the formula field it says bad date...UCASE(TOTEXT(DATEADD("m", -1, DATE("01" &LEFT({EMPLOYEE_VW.PERIOD_ID},3)&" "&RIGHT({EMPLOYEE_VW.PERIOD_ID},4))), "MMMyyyy"))
Please Help.
Thanks
Hello Madawc Williams of GBR,
This Period should be a dynamic one...the data I have shown is a sample and the Year -1 logic for this report is not supported by previuos and next...
Please help.
Thanks
Hello all,
This is what I have:
Table T1 has the following fields:
Emplid
Period
Salary
The information is stored as:
Emplid Period Salary
100 DEC2002 123
101 DEC2002 456
100 JAN2003 456
101 JAN2003 789
Now this is what I want to do.
I want to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.