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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: redbunny78
  • Content: Threads
  • Order by date
  1. redbunny78

    Excel multiple values in one column, need to split

    I have an excel spreadsheet with several values that have been stored in one field. How can I best split them into other columns? This is what it currently looks like: Name Dr.William R. Hendee Rose Y. Byland MD. Ms. Cynthia Allen I need it to look like this: A B...
  2. redbunny78

    Excel multiple values in one column, need to split

    I have an excel spreadsheet with several values that have been stored in one field. How can I best split them into other columns? This is what it currently looks like: A B C Salutation Name Designation Dr. William R. Hendee...
  3. redbunny78

    Updating a table using excel as a source

    Using SQL 2000 I need to update a pricing table based on data I have in an excel spreadsheet. I need to update the table partprice based on the partnum. The excel spreadsheet has two columns that contain the partnum and the updated price. What is the best method to do this? A DTS package...
  4. redbunny78

    Record selection with prefixes

    Using Crystal 10 and Oracle I need help with the record selection criteria for a report: - I would like to show all tickets opened after midnight the previous day by assignment group. The opentime is a datetime field - The assignment group needs to be limited to results with the following...
  5. redbunny78

    Group by first nine characters

    Using crystal 10 and Oracle I am trying to group on a report by the first nine characters of a job name. What is the best way to do so? Thanks!
  6. redbunny78

    Showing yesterdays data on a YTD report

    I have a YTD report that shows has several formulas but I need to show the same data results for yesterday and the last 3 days. What is the best way to do so? The output would look like: Current YTD % 96% 2007 YTD / Success Rate 82,150 / 92.4 Yesterday / Success Rate 76% / 42 Last 3...
  7. redbunny78

    Showing YTD for previous years

    Using Crystal X and Oracle I have a report that shows YTD numbers based on a DateTime field. I also need to show the YTD numbers for last year and for this month last year. The output would look like: 2007 YTD /Success Rate 1160595/96% 2006 Oct /Success Rate 1440179/95% 2006 /Success Rate...
  8. redbunny78

    Keyword searches in description fields

    Crystal 10 and Oracle I would like to build a report that shows all tickets owned by a certain assignment group. Unfortunately that info is only found in a description field. How can I do a keyword search on that description field to find all tickets that contain '1-' or 'SR'? Thanks so much!
  9. redbunny78

    Yesterday's date in record selection

    Crystal 9 and Oracle How can I limit my record selection to just yesterday. I tried the formula CurrentDate - 1 but get an error. How do I need to change this formula? Thanks!
  10. redbunny78

    Selection formulas with calculations used later in report

    Using Crystal 9 and Oracle I am trying to create a report that shows the number of times a workstation is showing up in the table as receiving the same distribution and is successful. For example, I have a table 'Logs' that shows the following data: Pushdate Endpoint...
  11. redbunny78

    Need help calculating duration with array fields...

    I am trying to calculate total actitvity duration per assignment group. I am using Crystal 9 with an Oracle DB. The report currently shows the following output: Ticket #213434 0012345 9/1/07 14:40 9/1/07 14:41 MICH SMITH IBM-SMO Work Performed 1 Mark responded and will check 0012346...
  12. redbunny78

    DateTime Conversion from GST to EST and EDT

    I am trying to find a formula to convert the GST to local time EST as well as account for daylight savings time. We had a formula that was working until this year when the dates on DST changed. (Probably redundant but from the 1st Sunday/April thru last Sunday/Oct to 2nd Sunday/March thru 1st...

Part and Inventory Search

Back
Top