I've created a crystal report from Excel Data.  My Data has 100,000 row and 37 columns.  Excel is connected with data base expert and is my active connection.  My problem:  All of my records are not being read by Crystal.  I know because my grand totals are not correct.  Is there a limitation on rows of data that crystal sees?  Anyone have any ideas. Thank you so much for any input! 

Thank you for your reply.  Can you tell me how I would connect directly? I am using an excel spreadsheet with the data. 

Edited by Reports - 25 Jan 2012 at 6:35am