Calculate parameter for each row

Stimulsoft Reports.WPF discussion
jacek_arwal
Posts: 17
Joined: Mon Mar 04, 2019 12:01 pm

Re: Calculate parameter for each row

Post by jacek_arwal »

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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Calculate parameter for each row

Post by HighAley »

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.
jacek_arwal
Posts: 17
Joined: Mon Mar 04, 2019 12:01 pm

Re: Calculate parameter for each row

Post by jacek_arwal »

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 ?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Calculate parameter for each row

Post by HighAley »

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.
Post Reply