Problems with filter

Stimulsoft Reports.WPF discussion
johnl
Posts: 3
Joined: Sun Dec 05, 2021 7:08 am

Problems with filter

Post by johnl »

SalesQuoteTest.xml
(2 MiB) Downloaded 226 times
I am having a problem with filtering this report
When I turn the filter off I get data I don't want but the values all appear to be correct
When I turn the filter on I get the data I want for the first item in databand1 but the items for the second item are not correct ????
I want to filter so that I only get a match of a field in databand1 with a field in databand2 (ItemCategory.ItemForSale.StockTranItem.StockTranItem_Id == Attachment.Attachments_Id)
Attachments
SalesQuoteTextBlue.png
SalesQuoteTextBlue.png (55.46 KiB) Viewed 7084 times
SalesQuoteTest.mrt
(62.12 KiB) Downloaded 217 times
Last edited by johnl on Mon Dec 06, 2021 11:43 pm, edited 1 time in total.
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Problems with filter

Post by Lech Kulikowski »

Hello,

Could you send us a sample (excel, screen, etc) that shows which result you need?

Thank you.
johnl
Posts: 3
Joined: Sun Dec 05, 2021 7:08 am

Re: Problems with filter

Post by johnl »

Samplel

Sales Quote Test

Barney Collection 2 Seater ItemCategory.ItemForSale.StockTranItem.StockTranItem_Id 0
barney Attachment_Attachments_Id 0
barney2 Attachment_Attachments_Id 0

Big Finley Collectyion DOUBLE ItemCategory.ItemForSale.StockTranItem.StockTranItem_Id 5
big finley Attachment_Attachments_Id 5

Filter so that I only get records where ItemCategory.ItemForSale.StockTranItem.StockTranItem_Id match Attachment_Attachments_Id
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: Problems with filter

Post by Max Shamanov »

Hello,

In your XML which you're sent us not all data inserted. Please send us full test data used in filters.

Thank you.
Attachments
Designer_SmGlAEJABI.png
Designer_SmGlAEJABI.png (169.4 KiB) Viewed 7046 times
apOre9GWIT.png
apOre9GWIT.png (141.37 KiB) Viewed 7046 times
paulsawkins
Posts: 8
Joined: Tue Dec 14, 2021 1:45 am

Re: Problems with filter

Post by paulsawkins »

Intention - a purchase order with multiple lines - after each line is the attachments (images) related to that line
Attempt - Databand for the lines + databand (master component databand 1) for the attachment images

Problem is Databand2 is showing all images - not only those linked to the line in Databand 1

So tried to put in a filter - but that does not seem the correct approach....

The XML has the following hierarchy

Crafted.salesorder > StockTranItem id > Attachments > Attachment description.... Where stocktranitemid is the order line. So the attachments are nested in the xml

The report has been setup to have:
- databand per stocktranItemID (the order line)
- databand2 (Master component Databand 1) - the attachments related to the stocktranitemid

However when looking at the Dictionary tree in Stimulsoft - attachments is NOT under Item for sale - not sure why ?
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Problems with filter

Post by Lech Kulikowski »

Hello,

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

Thank you.
paulsawkins
Posts: 8
Joined: Tue Dec 14, 2021 1:45 am

Re: Problems with filter

Post by paulsawkins »

The sample and xml is attached to the first post in this thread .
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Problems with filter

Post by Lech Kulikowski »

Hello,

We couldn't reproduce the issue.

Thank you.
Attachments
Screenshot 2021-12-20 225113.jpg
Screenshot 2021-12-20 225113.jpg (321.18 KiB) Viewed 6940 times
SalesQuoteTest_modified.mrt
(2.37 MiB) Downloaded 215 times
johnl
Posts: 3
Joined: Sun Dec 05, 2021 7:08 am

Re: Problems with filter

Post by johnl »

I want the filter to only print the attachments when the condition is true
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Problems with filter

Post by Lech Kulikowski »

Hello,

We use ADO.NET methods to work with XML, which do not always work correctly with nested structures. Unfortunately, we can not ix it.
You need to modify your XML data to work correctly - split data as flat table sources with relations.

Thank you.
Post Reply