Skip to Content
Former Member
Jan 08, 2008 at 01:21 AM

Crystal Report prompted multiple times for same SQL Command parameters


Post Author: jenxia

CA Forum: General


I am working on Crystal Report XI, CR Developer with Product Version

I have few reports generated by Crystal Report XI that has parameters for SQL Commands and paramaters for Selection Formula.

While parameters for Selection Formula only prompted once for user input, the parameters for SQL commands got prompted multiple times by Prompt Engine of Crystal Report, once at Set database connection and then twice at refreshing report data for the identical parameters.

Does any one on these forums have seen this before?

Is there a way to suppress those extra prompts input?

Any suggestion?

Thanks in Advance for any response!