Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ccanalia

    SC420 doesnt boot periodically

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

    Unread mail folder in Outlook 2003

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

    USB Flash Drive

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

    USB Flash Drive

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

    Start page numbers at page two

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

    New Page After

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

    Convert a time on weekend day to week day

    That worked like a charm. Thank you soooo much.
  8. ccanalia

    New Page After

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

    New Page After

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

    Convert a time on weekend day to week day

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

    Convert a time on weekend day to week day

    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?
  12. ccanalia

    Convert a time on weekend day to week day

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

    Formula to change time

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

    Calculating time on an open ticket for business hours

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

    Convert Date/Time field to DateVar

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

    Converting Crystal 10 to Crystal 9

    Hi, I am currently building reports in Crystal 10, the vendor that we are using to post these reports to the internet is only on Crystal 9. We have noticed that the layout of the reports are being skewed when they are going from 10 to 9. The format of the reports are being shifted and text...
  17. ccanalia

    A boolean is required here

    I am working on Crystal Reports 10 and I am running into a problem with something that I thought would be simple. I am starting out with a formula: if {HomelessEnrollment.IsChronicallyHomeless} = "1" then "Yes" else "No" and I get the dialogue box that returns the statement "A boolean is...
  18. ccanalia

    Converting Excel into Crystal Report

    I dont know if this is possible or not, but is there any way to take an Excel 2003 spreadsheet and import it or convert it into a Crystal Reports 10 file?
  19. ccanalia

    Using field information to display result

    I am working on a report where there are two dates listed, an enroll date and an exit date. I am trying to write a formula that will show the enrollment status based on the dates that are listed. If there is an end date the enrollment status would be "Closed" if there is not an end date then...
  20. ccanalia

    Formula in Crystal Reports 10

    I am trying to run this report from some data that my office uses. I have this general report where I have organizations that are listed by their ID in the report. {osOrganization.orgId} I need to take that data and write a formula somehwere that will turn the ID information into the actual...

Part and Inventory Search

Back
Top