Does the stored procedure return thousands of records with many duplicates? By default, CR only reads the first thousand records when creating a parameter list. I've answered this question a few times elsewhere on the forum. Search for 'registry' and you'll find a few posts that walk you through the solution.

In fact, I like this question so much that I added to my "Best of the Forum" section in my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.

Edited by BrianBischof - 01 May 2008 at 10:45pm