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 SkipVought 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. bboy27

    Wrong data when joining multiple tables

    My apologies! The crystal version I am using is Crsytal 9 and the database is OLE DB using SQL. Quite simply lets say I have actual hrs and am driving cost from those hrs and all I want to do is add an additional column in the cross tab from another table which shows the budgeted hrs or total...
  2. bboy27

    Wrong data when joining multiple tables

    I had a problem recently with joining tables and getting incorrect data being displayed because of the join. I got a solution from synapsevampire who suggested I us UNION ALL to put all the data in one table. That solution worked. The problem is I have a new situation where I have several...
  3. bboy27

    Incorrect data when linking tables

    Thanks for the fast reply! I have managed to get the union to work but is there a way to keep the two values Budget vs. Actual hrs separate? Because what is happening with the union is that it is combining the actual hrs and budgeted together. Is there anyway to keep them separate? TIA
  4. bboy27

    Incorrect data when linking tables

    I am using Crystal Reports v9 and I am trying to create a report of Actual Hrs vs Budgeted Hrs. One table has the project, task and actual hrs and the other table has the same project, task but with budgeted hrs. When I link the tables I am getting incorrect values that I don't understand where...

Part and Inventory Search

Back
Top