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 IamaSherpa 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. IChang

    "Invalid Date Contents" error

    Hi, I am upgrading reports from CR 8.5 to 10. One of the report shows the error Query Engine Error: S0000: [PrivideX][ODBC DRIVER][FILE IO]Invalid Date Contents. Thank you
  2. IChang

    The string is non-numeric

    Hi, I am new to CR. I am upgrading reports from CR8.5 to CR 10. The following formula shows " the string is non-numeric" SY0_CompanyParameters.ARAgingCategory4 is highlighed. {@agedate}; NumberVar Age_m4 := Month(DateSerial (Year ({@AgeDate}), Month({@AgeDate}) -4, 1)); NumberVar Age_y4...
  3. IChang

    A statement is not expected here

    I guess I must going crazy by working on this issue all day. The error message is "a statement IS expected here'. I don't know why I said it is not.....:( I set the syntax is to Crystal syntax, and it is working. Thank you
  4. IChang

    A statement is not expected here

    Hello, I am upgrading reports from 8.5 to 10. The following formula keeps showing that "A statement is not expected here" ( highlighten on "STD" ) IF {SO_SalesOrderHeader.OrderType} = "S" THEN "STD" ELSE IF {SO_SalesOrderHeader.OrderType} = "M" THEN "MST" ELSE...
  5. IChang

    How to link two field with different length but same data

    Hello, I need to link the following field A, B A ( string, length 6) ex: 001234 B ( string, length 4) ex: 1234 they have the same last four numbers. How can I write a formula to make them equal to each other? Thank you.

Part and Inventory Search

Back
Top