What controls the order the datasources execute
Posted: Fri Dec 01, 2023 4:44 pm
Hello,
I have a report with 4 datasources for a dictionary. I see the order they are displayed in the Designer UI and iterating through the datasources in code using:
foreach (StiSqlSource curDatasource in report.Dictionary.DataSources)
{
System.Diagnostics.Trace.WriteLine("SQL Datasource Name: " + curDatasource.Name );
}
produces these trace statements:
SQL Datasource Name: ProposalData
SQL Datasource Name: CompanyLogoQuery
SQL Datasource Name: _AppRole1Copy
SQL Datasource Name: JobHeaderConditions
However, monitoring the request to the SQL Server I can tell that these request/statements are not executed in this order.
What determines the order the datasources are executed?
Is there a way to control which source executes first?
I have a report with 4 datasources for a dictionary. I see the order they are displayed in the Designer UI and iterating through the datasources in code using:
foreach (StiSqlSource curDatasource in report.Dictionary.DataSources)
{
System.Diagnostics.Trace.WriteLine("SQL Datasource Name: " + curDatasource.Name );
}
produces these trace statements:
SQL Datasource Name: ProposalData
SQL Datasource Name: CompanyLogoQuery
SQL Datasource Name: _AppRole1Copy
SQL Datasource Name: JobHeaderConditions
However, monitoring the request to the SQL Server I can tell that these request/statements are not executed in this order.
What determines the order the datasources are executed?
Is there a way to control which source executes first?