hi All, I am calling a stored procedure from a command object in Crystal Reports and it's taking a long time - over 10 mins to update the datasource using Database Expert or Set Data source Location. Any suggestions as to what could be cause this? Does Crystal Report actually runs the command object query at the point of updating the source?
It is also taking considerably longer to execute the stored procedure in Crystal Report (13 mins art best) compared to executing same stored procedure in SQL Server Mgt Studio (3 mins or less).
Thanks !!