Click to See Complete Forum and Search --> : Query Exceution when Preview in Crystal Client


adutt
November 20th, 2008, 02:49 AM
Hi,
I have a crystal report in which there is a dynamic prompt.In the prompt screen this value is populated through a command object say Command 1. I have another command object Command 2 which actually fetches the report data. The command 2 object also depend on some static parameter values which come up on the parameter screen.When I preview the report in crystal client Both Command1 and Command2 gets executed before the parameter screen appears. Whereas only command1 is required to generate the parameter screen. Command 2 gets executed with the value to the static parameters as their default value.Since Command2 also gets exceuted before the prompt screen appears, it causes the prompt screen to appear only after a long wait. Thus in essence command2 get executed twice during the exceution of the report, once before the parameter screen screen and once after we fill up the parameter screen and hit ok. How can we get command2 not to run before the parameter screen comes up?

jggtz
November 20th, 2008, 01:34 PM
Take out the CR parameters and ask for them inside the app and send to report thru formula fields or apply them to construct the recordset, etc.