Crystal XI: Executing SQL Stored Procedure mult times

[N11689]

All of our Crystal Reports run SQL stored procedures.
I have two reports.
One was created pre-Crystal XI then converted to Crystal XI by opening and saving in Crystal XI...no other changes.

I have another 'new' report created from a converted 'template' report. By converted, I mean the template was created pre Crystal XI and then opened and saved in XI with no changes.

The problem:

The newer report, created with a template, is executing the stored procedure twice. This is causing us to lose data as the stored procedure does an update at the end. So, the second time it runs, there is no data.

The older/converted report only executes the stored procedure once.

I can't see what is different between the two reports. Both have the same exact Report Options settings (no verify on first refresh, etc.), but one is executing the stored procedure twice, the other only once.

Any ideas?

 

[lbass]

I don't know if this applies to stored procedures or not, or whether this is exactly your issue, but when adding new tables in XI to a report that I created in an earlier version using a different driver, I've had to go to database->set location->new table->properties and change the line:

Use DSN Default Properties: False

to "True"

Then all tables use the same driver, and I don't have to log in twice. Not sure if this is an appropriate practice, but it seems to work. I'd be interested in other people's knowledge in this area.

-LB

 

[N11689]

Tried this, but it did not work. Anyone other ideas?

We are using an OLE DB connection to our SQL database.