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 Chris Miller 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. get2work

    To_Char on Crystal DateTime Field for formatting

    THANK YOU!!!
  2. get2work

    To_Char on Crystal DateTime Field for formatting

    Thanks! I chose the latter formula using totext. This partially works. I get 07/YYYY instead of 07/2003. I've tried using formula with the single tick marks and the double quote marks with the same results. Because the datetimestamp in this field is unique for 100K+ records, I need to group by...
  3. 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...
  4. get2work

    Using LEFT in a crosstab formula

    No - I haven't applied hot fixes - sorry, don't know what they are. I have opted to have CR8.5 installed, hopefully by 06/02/03... Thanks for the support!
  5. get2work

    Using LEFT in a crosstab formula

    Thanks! I'm using CR 8.0.1.1 - Do you think that may be the issue? Is there a way to get this to work using 8.0.1.1?
  6. 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