Underlying SQL is run TWICE. Why?

[johnkatzman]

We use CR7 Pro with SQL Query (Oracle817) as the report source.
The query itself is only run once when the report is run in Crystal Reports Designer, but when using run-time library' Execute method the report query is run TWICE (we see it using Oracle's SQL Trace facility).
This happens when we use parameters in query files.

We might be forgetting some checkbox or flag to set, but we don't know where so your help would be a great asset.

Thanks

 

[reports4kns]

I am also facing the same issue. I am using sql-server7. Did you find any reason/solution for this.

Thanks