Stimulsoft Business Intelligence System | Forum

I have prepare excel sheet with data. First sheet contains business objects ( column names ) with data. Second sheet contains data source SrodkiTrwale ( nessesary columns ). Business objects and data SrodkiTrwale table have relation - it's "Nr inwentarzowy". I need WartoscNabycia for each Srodek Trwaly in my report

Hello, Jacek.

It seems that you need to get one value for each row.
It's better to write a SQL query that returns necessary data in one table.

The connection to the database for each row takes time so it's better to get all data at once.

Thank you.

Yes I need a value for each row. Since there is not big data ( it's about 150 rows in both tables ) I think that rendering should be not so long.
Maybe it's possible to get whole sql table to get data and store it C# table and then get value for each row ?

Hello.

There are several ways how you can get data.
You could right necessary SQL query in the report or get necessary data with your code and register it as DataSet.

Thank you.