Problems with filter

[johnl]

SalesQuoteTest.xml

(2 MiB) Downloaded 82 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)

[Lech Kulikowski]

Hello,

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

Thank you.

[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]

Hello,

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

Thank you.

[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]

Hello,

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

Thank you.

[paulsawkins]

The sample and xml is attached to the first post in this thread .

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue.

Thank you.

[johnl]

I want the filter to only print the attachments when the condition is true

[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.