Search results for query: *

Yes, this worked in Crystal. I want the measurement value compared to upper action limit and the lower action limit. Depending on which value the measurement exceeds, I want the exceeded limit displayed in this field. In Crystal it was a formula field. Perhaps I can't do the same thing in...

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...

Never mind. I figured it out. Thanks.

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

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...

When I drop the 'and' I receive an incorrect syntax error WHERE maxamr.dbo.workorder.siteid LIKE :Param_SiteID and maxamr.dbo.workorder.status Not in ('CANCEL', 'COMP', 'CLOSE')

Thank you. I've set the site ID as a parameter because we are a global company using a regional dB. This allows each site to filter and see only their WOs. I can now get it to run, however, I'm getting 336 blank pages so I am still not sure if the query is working.

Are you trying to creat a Look-ahead report, or are you looking at all the PMs (Preventative Maintenance workorders) that are historical? Do you have attached Job plans in the PMs? Is the craft listed in the JPs?

Thank you. Yes, I am using Maximo 5.1. I've tried both solutions but continue to get an error in my SQL. My code is below. I only get the error when I add and maxamr.dbo.workorder.status Not in ('CANCEL', 'COMP', 'CLOSE') to the where clause (probably syntax)? Any ideas? SELECT...

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...