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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by olrac2

  1. olrac2

    connectivity fro Crystal Reports from ODBC to SQL Server

    Hi, I currently have established reports that run of my ODBC connections. We need them to connect to the SQL Server connection. How can I switch them over? Thanks!
  2. olrac2

    Crystal reports V14 saving to V11

    Hi, Can I write a report in V14 and save it in Crystal V11 format? Thanks
  3. olrac2

    transform a current table and add end dates on a record

    Hi gmmastros, Thanks for the explaination and the code. This worked fantastically..just two lines of code and it solved all my problems (On A.emp = B.emp & And A.RowId = B.RowId - 1). I wasn't sure about the "with" statement so I created two copies of the original table and crossed them as...
  4. olrac2

    transform a current table and add end dates on a record

    Hi, I write basic queries (using tables and nested queries) but this is not enough for my current problem. I have a table that looks like: current table emp payroll eff_date strp rate 2 VIHA 20030910 9 35.31 2 VIHA 20060401 9 36.37 2 VIHA 20070401 9 37.64 2 VIHA 20080401 9 38.58 2 VIHA...
See more

Part and Inventory Search

Back
Top