>>Entering those parameters in crystal gives me one row of results.
>>If I then display the SQL used and paste that into the management studio I get 4 rows..
Can you post the report sql query and the SQL Server query here?
That might give us a clue.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.