Search results for query: *

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

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

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

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

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

I have this selection criteria that I measure all tickets opened in the previous month and all tickets that are put in a servicerestored status for the previous month. Unfortunately I'm am not pulling tickets that were put in a servicerestored status for the previous month but may have been...

I have this selection criteria that I measure all tickets opened in the previous month and all tickets that are put in a servicerestored status for the previous month. Unfortunately I'm am not pulling tickets that were put in a servicerestored status for the previous month but may have been...

I am using Crystal Reports 10. I have a field called Problem Abstract which is a free form text field with a limit of 55 characters. I am trying to come up with a formula that would exclude tickets containing the word "Password" in the problem abstract field. Any ideas or suggestion would be...

I have a unidue situation occuring on my BOXI R1 SP3 system. I published a crystal report (CR 11 SP2) in which a url had some commas in the field. I went into the file option, select fields and selected number, I removed the thousand seperator and saved the report. Report ran fine and the url in...

I am using Crystal Reports V10. I am working with problem mgt. tickets and there is a field called problem abstract which is a string field (60). I am trying to write a statement that will allow me to search this string field and pull any tickets with the word "Visalia" in the field. This is...

Hello ! Currently I am using Crystal Reports V 10. I have a report that pulls from our ticketing system which uses greenwich time. I try use the following formula to convert the greenwich time to hong kong time but all it is doing is converting the greenwich time by adding 5 hours. I still need...

I have a formula for a change report that I run once a week. The report ran fine Thursday and now today I get this error: Here is the formula : If IsNull({CHANGE.PLAN_ST_TIME}) Then ' ' Else ( TimeVar Plan_St_Time :=...

I'm currently using Crystal Reports 10 for all of our reporting and I've been using the statement LASTFULLMONTH for month end reports. Now our month end has changed from 1 - 30 or 31 to 21 - 20 of the next month ( Ex. Jan 21 to Feb. 20 . Is there a way that I can code a statement in my report...

Does anyone have any info I could read up on or provide to me on how do I find out the pros and cons of Concurrent License vs Named User License. We are upgrading to v10 in Enterprise and plan to use the web based e-portfolio very extensively. I just need to figure out what are my best options...

Is there anyone in the state of North Carolina or anywher else that is running Crystal Enterprise 9 along with the PeopleSoft Toolbox Solution kit ?? Though Business Objects states that they have rolled this out we feel like we have been the Beta Test for the tool kit. We cannot get this to...

Is there anyone in the state of North Carolina that is running Crystal Enterprise 9 along with the PeopleSoft Toolbox Solution kit ?? Though Business Objects states that they have rolled this out we feel like we have been the Beta Test for the tool kit. We cannot get this to work despite the...

I run a network outage report and it gives me the following information: Start of Down Time End of Down Time Down Time Total 1/5/2002 02:43:00AM 1/5/2002 02:47:00AM 0:04:0:0 The down time total field is layed out as 0:0:0:0: 1st 0 = days 2nd 0 = hours 3rd 0 = minutes 4th 0 =...

Where would I go to look at several samples of what folks are doing with Crystal Reports ? I would like to see how individuals are getting creative with the fonts, colors, background, logo's. I feel comfortable with my reports but now would like to enhance them a bit instead of the usual black...