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

Crystal Report prompted multiple times for same SQL Command parameters

20 Views

Post Author: jenxia

CA Forum: General

Hi,

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

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!

Regards

Jen