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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by baldr1c

  1. baldr1c

    Crystal Formula...tricky

    An easier way would be to copy your current report and in the record selection have complaint status = completed and have the action date = today -1
  2. baldr1c

    Crystal word count

    Thanks Naith You can also use UBound(Split{field})) Cheers
  3. baldr1c

    Crystal word count

    Does anyone know how to do a word count in a report. The report has one main text field and I need to count how many words in this field and show it as a total for the whole report. I was thinking along the lines of counting how many time a " " came up in the field and then creating a...
  4. baldr1c

    Help with SQL

    I am new with Oracle and I am having a problem getting the correct syntax for the following query; SELECT BRB_CALLDET_T.ACC_NUM, BRB_CALLDET_T.BILL_NUM, BRB_CALLDET_T.SERV_NUM, IF(BRB_CALLDET_T.GNRC_PRC_AMT_CR)='CR' THEN SUM(BRB_CALLDET_T.GNRC_PRC_AMT* -1) ELSIF...
  5. baldr1c

    Formatting elapsed time values

    Thanks for that it has solved the problem very nicely.
  6. baldr1c

    Formatting elapsed time values

    I am using CR 8.5 and have a elapsed time field in my DB which is formatted to text. I have to add the time values and then display them as hh:mm:ss. I have converted the time field to seconds and I can then sum/average etc which is great. I am having problems in converting the seconds value...
See more

Part and Inventory Search

Back
Top