Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Actuate 10 - undesirable multiple SQL SP calls when using parameters

Status
Not open for further replies.

mrees

Programmer
Feb 20, 2003
197
GB
Morning all,

Here's the setup:
Actuate 10
SQL datasource, using stored procs
Reports have cascading parameters and "stand alone" parameters

We have noticed that when you first open the report, the parameter procs are called once but when you open up the parameters window after a report has been generated, Actuate calls the stored procs that populate the parameters 4-5 times.

Does anyone know a reason for this, there is a concern this could impair performance.

Regards

mrees
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top