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

    Doing a count on a formula field

    Thank you that has worked. Appreciate your help
  2. trishtrash

    Doing a count on a formula field

    Again Sorry formula:- (hour({Call_Progression.Time Spent})*60)+ minute({Call_Progression.Time Spent})
  3. trishtrash

    Doing a count on a formula field

    Sorry the nested formula is as follows: Sum ({@Progression Time},{calls.Call Number} )
  4. trishtrash

    Doing a count on a formula field

    The Formula for Status is as follows:- if {@Total time per call} <=20 then "1" else If {@Total time per call} <=100 and {@Total time per call} > 20 then "2" else If {@Total time per call} >100 then "3
  5. trishtrash

    Doing a count on a formula field

    I have created a report group first by year and then by Ticket number. Under each ticket there is a list of progression times which have been totaled to give me total time per ticket (number). Another formula sets a status 1, 2 or 3 for the length of time (eg status 1 represts 0 mins or less)...
  6. trishtrash

    OleObjects + Hyperlinks

    I am trying to develop a report that prints data from within rtf files. The tables I am querying contain the file names of each rtf file and these files are all stored in a fixed location but I am struggling to show the content of these files within the report. If I set a field up as an OLE...
  7. trishtrash

    Totalling aa time field

    Apologies if I have mis-led you I am not looking for the difference in the times but a sum of a list of times (hr :Min) presented in a list as per examples
  8. trishtrash

    Totalling aa time field

    I have a field that reflects the time spent on a job 00:01 00:15 I need to sum these can you help please
  9. trishtrash

    Dynamic Parameters

    Have set up a dynamic parameter to search on a stock code, when browse only brings up the first 1000 records is this a limitation or is there a setting somewhere to increase this.
  10. trishtrash

    Insert Pictures Associated to Stock Codes

    They will be stored in a file location as either .bmp, .gif or jpegs.
  11. trishtrash

    Insert Pictures Associated to Stock Codes

    Apologies the pictures are stored externally.
  12. trishtrash

    Insert Pictures Associated to Stock Codes

    Within a third pary Erp package, we have stock codes that have an images attached as a .bmp Using Crystal X1 need to produce a report for specific stock codes and would like the associated pictures to print alongside the stock code. Can anyone advise if this is possible?

Part and Inventory Search

Back
Top