After reading my previous post I have concluded that not enough information was given. What I am trying to do is take 2 JDE Tables and use Seagate Crystal Reports to get information from the tables. The problem is there is about 450,000 records in the database that Crystal Reports has to sort through and perform calculations that take up a lot of space. My thought was to use a stored procedure to eliminate the individual computer from having to do all the sorting and calculations by having it already calculated and sorted on the server. Has anyone out there done this before.