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

    If record exists in Table A and Table B display Table B record.

    I added the Code and changed the table.field to the correct ones placed in header of report and no difference. My report has all four fields in it. Not sure what I am doing wrong, Granted I am also selecting by date range. IF IsNull({V_OE_SHIP_SCHED.ORDER_LINE}) OR...
  2. locoproko

    If record exists in Table A and Table B display Table B record.

    Crystal Reports 10 Pervasive 10 I am trying to query two tables where when a record exists in Table A and not Table B then display record for Table A. If record exists for Table A and exists in Table B then display Table B. Table A will always have a record if not then one will not exist in...
  3. locoproko

    Using Calender in Parameter with String field

    Thanks MrBill!! After a couple of tries I got it to work. Hopefully I learn something from it. Systems/IT Manager Crystal Report Ver. 10.0.0.533 Pervasive 8.5 ODBC
  4. locoproko

    Using Calender in Parameter with String field

    Hello, First time here. I am Using Pervasive with a date field as string type. Data in string field is consistant yyyymmdd. I can convert to mm/dd/yyyy for report no problem with following... local stringvar cvdtin := {TIME_ATTENDANCE.DATE_IN}; local stringvar a := left(cvdtin, 4); local...

Part and Inventory Search

Back
Top