Calculate parameter for each row
-
- Posts: 17
- Joined: Mon Mar 04, 2019 12:01 pm
Re: Calculate parameter for each row
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
- Attachments
-
- Raport o środkach trwałych nieumarzanych.mrt
- (71.15 KiB) Downloaded 199 times
-
- SrodkiTrwale.xlsx
- (9 KiB) Downloaded 215 times
Re: Calculate parameter for each row
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.
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.
-
- Posts: 17
- Joined: Mon Mar 04, 2019 12:01 pm
Re: Calculate parameter for each row
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 ?
Maybe it's possible to get whole sql table to get data and store it C# table and then get value for each row ?
Re: Calculate parameter 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.
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.