Page 1 of 2
Calculate parameter for each row
Posted: Thu Mar 07, 2019 10:13 am
by jacek_arwal
I have SQL data source:
Code: Select all
Select
ModelDanychContainer.SrodkiTrwale.WartoscNabycia
From
ModelDanychContainer.SrodkiTrwale
Where
ModelDanychContainer.SrodkiTrwale.NrInwentarzowy = @NrInw
with a parameter in my report:
@NrInw
and expression:
This expression should be diffrent for each row of report, because NrInwentarzowy is diffrent on each row. But now expression is calculated only for first row and in all rows I have the same WartoscNabycia
Report is attached
Re: Calculate parameter for each row
Posted: Thu Mar 07, 2019 11:35 am
by Lech Kulikowski
Hello,
Please try to set the ReconnectOnEachRow=true property for the data source.
Thank you.
Re: Calculate parameter for each row
Posted: Thu Mar 07, 2019 11:59 am
by jacek_arwal
Where can I find this property ? For datasource SrodkiTrwale I see only some events on property tab.
Re: Calculate parameter for each row
Posted: Thu Mar 07, 2019 12:56 pm
by Lech Kulikowski
Hello,
Properties for the data source.
Thank you.
Re: Calculate parameter for each row
Posted: Thu Mar 07, 2019 1:51 pm
by jacek_arwal
It didn't help
Re: Calculate parameter for each row
Posted: Fri Mar 08, 2019 9:24 am
by Lech Kulikowski
Hello,
Unfortunately, it is not working with combination Business Object and Data Source.
Thank you.
Re: Calculate parameter for each row
Posted: Fri Mar 08, 2019 5:43 pm
by jacek_arwal
Is there any other possibility to solve this problem ? Second Pass or C# function to refresh field ?
Re: Calculate parameter for each row
Posted: Mon Mar 11, 2019 7:09 pm
by HighAley
Hello, Jacek.
You should get all data for the report before rendering it.
But the Business objects work different way.
The data are requested during rendering.
You could try to modify your business objects and add necessary data there.
Thank you.
Re: Calculate parameter for each row
Posted: Mon Mar 11, 2019 8:44 pm
by jacek_arwal
Adding data to Business Object is impossible because report is designed by Company Insert. I can add full table SrodkiTrwale as data source - it contains WartoscNabycia with values for my report. There is a relation between this table and business object but as as I know ther is now way to establish such relation in report. But is there a way to render value for field XXX for every row ? If yes I could search appropiate value in data source using value of business object.
Re: Calculate parameter for each row
Posted: Tue Mar 12, 2019 2:50 pm
by Lech Kulikowski
Hello,
Could you prepare a simple project with Test business objects and connection in which need send parameters? We will try to find a solution for you.
Thank you.