Stored Procedure is executing twice in Crystal Reports 8.5 ?

Question

We have a report in crystal reports 8.5. The data source for that report is a stored procedure which prompts a single param for input. While executing the report with SQL Profiler we noticed it is executing twice. Since it is processing nearly 100K records it is effecting the performance. Please help me with this...!

Jinish Gandhi · Answer

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.