Do filters on second level tables not work?
For example, I have a report using the Item Ledger Entry table, to show consumption and purchases. In this report I also have the Item table to pull in the unit cost and MOQ. The filters for the 1st level Item Ledger Entry table work fine, but the filter for the Item table does not. I've seen this action on my other reports, i.e. not filtering on 2nd and beyond level tables.
Feedback would be appreciated.
Thank you,
Chris
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi,
the filters should work.
Can you post the code, you made?
regards
jetsetter -
Jet Reports Historic Posts Per the request, below is the code, created using Table Builder.
To reiterate, the filter for the Item Ledger Entry (Posting Date >1/1/2014) works, while the filter for Item (Replenishment System = Purchase) does not.
Below is just one example, I have made many different reports, using a wide variety of tables, and have never had a filter in the 2nd, 3rd, etc., level tables work.
Thank you for your feedback,
Chris
Auto+Hide+Values
Hide Tables and Fields Filters
Hide Item Ledger Entry
Hide Posting Date >1/1/2014
Hide Item
Hide Replenishment System Purchase
Hide Links: ∞||"Item","No.","=Item No.","Replenishment System","Purchase","","","","","","","","","","","","","","","",""
Hide Headers: Item No. Posting Date Quantity Cost Amount (Actual) Source No. Item - Unit Cost Item - Minimum Order Quantity Entry Type
Hide Fields: Item No. Posting Date Quantity FlowField([Cost Amount (Actual)]) Source No. LinkField([Item],[Unit Cost]) LinkField([Item],[Minimum Order Quantity]) Entry Type
Table -
Jet Reports Historic Posts Hi,
very interesting!
I changed your filter from "Replenishment System" to "No." (item no.), to see what happens (e.g. "2*")
Yes, and you are right, the Filter does not work…. :(
I would suggest, that you open a ticket at support…
when nobody from JetReports is answering in the next hours.
Please let us know, what's going on.!
regards
jetsetter -
Jet Reports Historic Posts I think I've replicated this problem. In order to confirm, you need to check the actual TABLE function (in design mode, put your mouse on the word TABLE under Fields, do you see "Link=Replenishment System", or do you see "InclusiveLink=Replenishment System"?
The InclusiveLInk is generated when you select the 'only when… found' option at the bottom of the linked table options.
For instance, when I was testing, I was linking the Salesperson table to my report, and I decided to filter the results based on the assigned sales person (not the salesperson on the invoice).
in the section about the link (right-hand side of the builder) -
I added a filter for the Salesperson table, and made the table ink (where code = salesperson code)
beneath that area was the option to "include Order Entry Rows", and I was given two choices (one has to be selected):
* Always
* Only when Salesperson found
by default - Always was selected, and when I ran the table with that selection - I got all customers, no matter who the assigned sales person was.
when I recreated the table, and selected "only when found", I got only the customers that were assigned to that sales person.
So - to make a long story short, you can try to rebuild the table and make sure that "only when … is found" is selected, or you can try to change the report from "InclusiveLink" to "Link"
Hopefully this will fix the error you have been dealing with, Chris. Good luck!
~Heather
Please sign in to leave a comment.