Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Formula field Value based on Comparison
I had a report in Crystal were I built a formula field. The field would display one of two records based on the limit exceeded. I can't seem to figure out how to do the same thing in Actuate. The field was something like this. Any help would be greatly appreciated. if...- IvySkye
- Thread
- Replies: 4
- Forum: Actuate Reporting Solutions
-
Compare a data value to today
How can I compare a datavalue to today? I'd like to change the font color but I seem to be missing something in my code in the method. If DataValue < Current_Date Then font.color = red else font.color = black End If- IvySkye
- Thread
- Replies: 3
- Forum: Actuate Reporting Solutions
-
ToUpper - sorry, another newbie question
How do I set the method of ToUpper on a field before it is analyzed by the WHERE clause? For example, in Maximo we have the CrewID field. Although it is a select value field, people can simply type in the shift and save the record. I may have a shift written in a dozen different ways (SHIFT...- IvySkye
- Thread
- Replies: 2
- Forum: Actuate Reporting Solutions
-
Help setting specific values
I am new to Actuate. I've been using Crystal for over 6 years. Can someone please tell me how to specify values for a field? For example I want to look at ALL records that are NOT Cancelled, Closed, or Complete. This was easy in Crystal. I can't figure out how to set this restriction in ERD...- IvySkye
- Thread
- Replies: 10
- Forum: Actuate Reporting Solutions
