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

Part and Inventory Search

Back
Top