Recent content by ccanalia

I have a Dell SC420 server that I use as a regular desktop computer. Intermittently when I press the power button I get an orange blinking light, most of the time I can pull the power cable, wait a few hours, plug it back in and press the button again and sometimes I will get power. Sometimes...

Help!! I deleted my Unread email folder in Outlook 2003 and I dont know how to create another one with the same type of properties. Does anyone know how to do this? Thanks in advance, Chris

Actually XP will allow you to do this. I tested it out right after I got the response from jbarnett. Thanks John your response worked perfectly.

I am running Windows XP Pro with SP2, I do not have a floppy disk drive but I do have a USB Flash Drive. When I connect my Flash Drive, Windows automatically sets this device as G:. Is there any way for me to change this? I would like to be able to use my Flash Drive as an acting A: drive...

Please help. I am using a SQL Database with CR v10. I am trying to have my page numbers N of M show up differently. I dont want CR to count my first page of my report. So the first page would not show a page number and then page two would show Page 1 of M. So basically I want 1 subtracted...

Ok, I get it now. Sorry for the confustion.

That worked like a charm. Thank you soooo much.

Im a little confused. I put it the wrong formula in the "New Page After" section. What was I supposed to put there instead?

I am using Crystal Reports 10 with a SQL Server Database. I am grouping data and I have selected the option to have a New Page After each group footer in the Section Expert. When I get to my last page I have one blank page. I have tried checking the box to Suppress Blank Section. I even...

Ive gotten clsoer but the problem that I am running into is when the day is changed to the first monday, it is not changing the time to 9am on Monday. I have played around with the formula a little but so far I have not gotten what I am trying for. Example: I have One date that is showing up...

I tried this but I am getting the same thing as I was before. I have One date that is showing up on a Sunday (10/31/04 3:06pm) and the same date and time shows up whether I use the formula I provided or the formula that was suggested. Any other suggestions?

I am running CR10 and using a SQL Server Database. I have this formula so far. if time({Cases.CreateDate}) <= ctime(9,0,0) then cdatetime(year({Cases.CreateDate}), month({Cases.CreateDate}),day({Cases.CreateDate}),9,0,0) else {Cases.CreateDate} What I want to incorporate into this formula is...

I am using CR 10 with a SQL database and I have a field that I am trying to take any time that was recorded before 9am and display the same date and adjust the time to 9am. I thought I would be able to use an IF THEN statment but CR tells me that I not only need time, but a date too. What I...

I have this report I am working on in CR10 with a SQL database from our support site. I am trying to calculate the total business hours each ticket is open. My formulas work for anything that was submitted during business hours, anything submitted after or before business hours is showing an...

I am currently writing a report in Crystal 10 and I am using a formula to get statistics for our support site on how long a ticket is open. This is a SQL Database. I am using this formula and I am assuming that it is not working because my date field isnt in DateVar format...