Recent content by rico7937

I have a s imple report that is pulling in records for oncall, below is the query: {USERS.USER_ACTIVE_FLAG} = 1 and {GROUPS.ACTIVE} = 1 and {MEMBER_OF.GROUP_ID} Like 'IGS-VF*' OR {MEMBER_OF.GROUP_ID} Like 'VFC-*' I cannot figure out why on the return of data that a individual names appears...

Thank you ! That worked as expected !

Maybe I'm coding wrong for what I am trying to do: First I want to pull in all the records from the VENDOR_INFO.VEND_FIELD5 Then I add the 2 statements below: {VENDOR_INFO.VEND_FIELD1} = "Y" AND NOT ({PROBLEM.PROBLEM_ABSTRACT} STARTSWITH ["DR-*","[DR]"]) So far everything is ok, I know have...

Can someone take a look at this formula and let me know why I am getting a boolean required on line # 5 If (isnull ({VENDOR_INFO.VEND_FIELD5})) then " " else ({VENDOR_INFO.VEND_FIELD5}) and ({VENDOR_INFO.VEND_FIELD5}) <> "OVERDUE" and ({VENDOR_INFO.VEND_FIELD5}) <> "OVERDUES" I know I have...

Has anyone experience any issue's with Crystal Enterprise 10 dealing with empty folders in the File Store Output folder ? I was told to enter a -prune command in the file output repository service, which I did. This command has been in place since Feb. 7 at 9 AM and was told that the service it...

Thank you, that worked !

I am using Crystal Reports v10. I am trying to create a formula that will let me forecast when a Service Desk Ticket will breach based upon severity. SEV 1 4 HRS SEV 2 24 HRS SEV 3 10808 HRS(7 DAYS) Ex. Sev 1 Ticket opened 6/30/2008 1:00:00 PM should breach at 6/30/2008 5:00:00 PM Currentyl...

Thank you so much, that worked just fine !

Hello all, I am using Crystal Reports V10. I am trying to figure out how to shorten a field and not sure how to do it. I run a network report with a field called outage_data.resource_id (string field) that produces the following output (About 400 various Id's in this format) VFC-EC7MRTR1...

That is what I am trying to do with this formula in the record selection: DTSToDateTime(tzcvtConvToLocalDatetimeByName(ToText(DateTime({PROBLEM.OPEN_DATE},{PROBLEM.OPEN_TIME}),"MM/dd/yyyy hh:mm tt"),"Eastern Standard Time")) In DateTime (totext (Date(DateAdd...

That can be a true statement. I just need to pull in all records form the 1st of the month to the end. This report will run daily 7 days a week and that is why I am trying to use the Month to date statement. If there's a btter way please let me know. Thanks !

Anh advice ?

This will always be for the current month

I am using crystal reports v10 and need to try to convert this formula from showing the past 24 hrs to a month to date formula ( showing from 00:00:01 on the 1st of the month thru 23:59:59 on the last day of the month). Can someone help me out ...

Understood