Stimulsoft Business Intelligence System | Forum

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?

Hello,

It should connect in order as its stored in the Dictionary.

What product and version are you use? How do you run your reports?

Thank you.

Hi Lech,

I'm using Stimulsoft Report.Net 2023.3.1.
The basics of my calls are:

Report.Load(fileName);
foreach (StiDatabase curDatabase in report.Dictionary.Databases)
{
((StiSqlDatabase)curDatabase).ConnectionString = connectionString;
}
Report.Show(true);

Watching with SQL Profiler I can see that the data sets are executing in this order:

_AppRole1Copy
JobHeaderConditions
ProposalData
CompanyLogoQuery

You can see in this image the datasets shown in the designer. The order there matches the order from the loop through the datasets I posted originally.
https://workdrive.sharpesoft.com/extern ... 461354dcc8

Hello,

Please send your report template for analysis.

Thank you.