Filtered a databand with a list variable

Stimulsoft Reports.NET discussion
Post Reply
Souhib
Posts: 4
Joined: Thu Feb 09, 2023 9:36 am

Filtered a databand with a list variable

Post by Souhib »

Hello,

I want to filter a databand with a list variable but it does not work.

I have created a list variable FundId. This variable contains the ids of my Fund entity (please see the attached file).
Then I have added a filter in the databand Fund like this Fund.Id == FundId so that the databand is filtered using the values in the id list (please see the attached file).

The filter does not work.
It is possible to filter a databand with a list variable ?

Thank you for your help.
Attachments
Filtered databand with FundId variable
Filtered databand with FundId variable
Capture d’écran 2024-11-25 à 10.22.41.png (234.58 KiB) Viewed 5496 times
Variable FundId
Variable FundId
Capture d’écran 2024-11-25 à 10.22.50.png (295.59 KiB) Viewed 5496 times
Lech Kulikowski
Posts: 7291
Joined: Tue Mar 20, 2018 5:34 am

Re: Filtered a databand with a list variable

Post by Lech Kulikowski »

Hello,

You need to use the following expression:
ListVariableName.Contains(DataSourceName.ColumnName)

Thank you.
Souhib
Posts: 4
Joined: Thu Feb 09, 2023 9:36 am

Re: Filtered a databand with a list variable

Post by Souhib »

Hello,

The filter still does not work even if I used the expression: ListVariableName.Contains(DataSourceName.ColumnName).

Could you help me?

Thank you.
Lech Kulikowski
Posts: 7291
Joined: Tue Mar 20, 2018 5:34 am

Re: Filtered a databand with a list variable

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
Souhib
Posts: 4
Joined: Thu Feb 09, 2023 9:36 am

Re: Filtered a databand with a list variable

Post by Souhib »

Hello,

Please the attached file.

The second attached file with the list of id I want to filter the fund databand with.

Thank you.
Attachments
Capture d’écran 2024-11-29 à 10.00.11.png
Capture d’écran 2024-11-29 à 10.00.11.png (7.53 KiB) Viewed 5336 times
EETTemplate_v1_1_2_10012024_v2_Umbrella.mrt
(1.83 MiB) Downloaded 141 times
Lech Kulikowski
Posts: 7291
Joined: Tue Mar 20, 2018 5:34 am

Re: Filtered a databand with a list variable

Post by Lech Kulikowski »

Hello,

Please send test data for your report.

Also, please check the sample report.

Thank you.
Attachments
ReportSample.mrt
(877.09 KiB) Downloaded 140 times
Souhib
Posts: 4
Joined: Thu Feb 09, 2023 9:36 am

Re: Filtered a databand with a list variable

Post by Souhib »

Hello,

I am using a tool where Stimulsoft is implemented.
I want to filter the databand Fund in the report with a variable that I send from this tool.

The list variable sent is of this format [1,2,3] (1,2,3 is the list of id).

In what format should the list variable be sent to stimulsoft for it to be interpreted?

Thank you.
Lech Kulikowski
Posts: 7291
Joined: Tue Mar 20, 2018 5:34 am

Re: Filtered a databand with a list variable

Post by Lech Kulikowski »

Hello,

Please send your request to developers of this tool.

Thank you.
Post Reply