Stored Procedure is executing twice in Crystal Reports 8.5 ?

there is your solution. Under database expert in Crystal Designer I specified the stored procedure that I wanted to use (which had the parameters in it), along with the table or view I wanted to use to populate the choices available for the parameter. The problem was that the SP and Table were linked in Crystal Reports. Thus everytime the program went to the lookup view or table it would generate the parameter prompts for the stored procedure. To remedy this I simply unlinked them in database expert. I then edited my parameter fields in the report to look at the lookup table or view. After that everything worked fine, only one prompt.