Agnes,
I don't use Crystal, so I can't give you any more specifics other than to say that what Kevin means is to have your application get the data from Sql Server into a DataSet and then pass DataSets to your Crystal Report, rather than having your Crystal Report get the data directly from Sql Server.
Since I don't use Crystal, I don't know how to do this, but this info might point you in the right direction (or Kevin or someone else might pop in with the details of how to do this).
~~Bonnie
>Thanks Kevin
>But I don't know how to set 'push' mode.
>Where Can I set in crystal report ?