Crystal is refreshing my recordset without reason...

[Millstone]

When passing an ADO recordset to Crystal Reports, Crystal is re-opening the recordset ie re-running the query/stored procedure even though it has been opened in VB.

Is there any way to stop this, or a more efficient way of putting together the report? Re-running the stored procedure is slowing down the report too much.

 

[Millstone]

its ok - have found out that if you close off the recordset, crystal uses the original recordset to create the subreports and hits the db only once.