Search results for query: *

FYI: Finally cracked it. I needed a test of the null/not null in every block of code that touches the null field - so not just the 1st block. I.E.: if isnull({HPD:HelpDesk-ShrPeople_Join.Receiver Group}) and ({HPD:HelpDesk-ShrPeople_Join.Assigned To Group+} in ["US-ISSD-Windsor&quot...

Hi Jim, Lisa and thank you. It's still not responding the way it should, here's the code maybe that'll help - it's actually on an isnull rather than not condiion. The receiver field is the only one that has nulls. if isnull({HPD:HelpDesk-ShrPeople_Join.Receiver Group}) and...

I am using Ver.8. against an Oracle DB (Remedy ODBC) I have 2 fields defined to enable me to sum the qty of records based some conditions: FieldName1: If FIELD-A = VALUE-1 or VALUE-2 or Field-B = VALUE-3 or VALUE-4 then 1 else 0. FieldName2: If FieldName1 = 0 then 1 else 0. The 2nd...

I've always accessed only my Remedy database with CR from CE but now I want to run a report that hits an Access database. I have the same ID/password setup in Access, CE, and the ODBC data source but the Viewer still rejects the ID/password. The Access database is on the same server and I can...

Is there a straight forward way to convert seconds to Hours, Minutes, Seconds? For example 3729 seconds to 1:02:09. I have a line item that's already an average number of seconds based on a number of phone calls. To summarize it I must first multiply the the avg seconds by the number of calls...

Nevermind - I found how perform this function via the Insert Summary function.

I'm doing running totals of groups and would like to display the percent of the total number of records for each group: group 1 30 15% group 2 100 50% group 3 70 35% --- Ttl recs 200 How do I do the calculation to get...