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 dencom 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: IChang
  • Content: Threads
  • Order by date
  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

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