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 Rhinorhino 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: get2work
  • Content: Threads
  • Order by date
  1. get2work

    To_Char on Crystal DateTime Field for formatting

    In Oracle, we use the following format to create a field that can be grouped by: TO_CHAR(V_PIN_TRACK_MAPPING.ACTIVATED_DATE, 'MM/YYYY') In Crystal, however, this formula: TO_CHAR({V_PIN_TRACK_MAPPING.ACTIVATED_DATE}, 'MM/YYYY') sends back an error "The remaining text does not appear to be...
  2. get2work

    Using LEFT in a crosstab formula

    Created a formula named "short descrip" as Left ({PACKAGE.PACK_DESC},9) in the row section of the crosstab. The purpose was to combine like product names based on the first 9 characters. The summarized field is count(MAP.PIN_NUM). The product names are grouping as desired, but the...

Part and Inventory Search

Back
Top