Data connection from BO and Excel

Stimulsoft Reports.WPF discussion
Post Reply
michal_123
Posts: 2
Joined: Wed Apr 05, 2023 7:44 am

Data connection from BO and Excel

Post by michal_123 »

i'm using a report designed by InsERT Company and I would like to connect data from a business objects to a new data source - excel. I'm trying to do it by using a filtr on databnd.
i select "Expression" and enter "Dokument.Pozycje.AsortymentWybrany.Symbol == Arkusz1.Symbol" (Dokument.Pozycje.AsortymentWybrany.Symbol - form Business Objects, Arkusz1.Symbol - column in Excel)
This expression should be different for each row of report, because Symbol is different on each row. But now expression is calculated only for first row and in all rows I have the same value.
Why is this happening and subsequent rows are not checked?
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Data connection from BO and Excel

Post by Lech Kulikowski »

Hello,

Depends on the components of the report. If there are no bands with Arkusz1 source, only the first record from Arkusz1 will get.

Thank you.
michal_123
Posts: 2
Joined: Wed Apr 05, 2023 7:44 am

Re: Data connection from BO and Excel

Post by michal_123 »

I have a Data Band where I selected Arkusz1 at the Data Source (Page Raport - Strona trzecia)
Attachments
FS excel.mrt
(977.02 KiB) Downloaded 123 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Data connection from BO and Excel

Post by Lech Kulikowski »

Hello,

Please send your Excel file for analysis.

Also, please note that the text component without a databand will display ONLY the first record.

Thank you.
Attachments
Screenshot 2023-04-07 101008.png
Screenshot 2023-04-07 101008.png (244.49 KiB) Viewed 8379 times
Screenshot 2023-04-07 101241.png
Screenshot 2023-04-07 101241.png (231.71 KiB) Viewed 8379 times
Post Reply