Hi there, I am struggling to add a new filter to a report I have already created. The report is for the ammount of products that have been produced and booked out on certain date ranges.
I have linked my original report to another table and I want to add a filter on the new table.
When my report is run the filter at the bottom asks for a W/C No.(this would be WC01 for eg), but when I enter this I end up with lots of blank records and a few where this work centre is, I only want the WC01 to be shown???????
Not sure if this makes sense to people.
Can any solve this and if so try to explain how?
Many thanks
Wilko
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Wilko,
I think the issue is that the Work Center No. isn't in the Warehouse Entry (WE) table. You will need to add an NL(Filter) or use Link= to filter out the records you want. I would start by finding all the Routing Lines that are associated with that work center, then use that to filter the WE table. If you look in the Jet Reports Help under the topic of Filtering data from Another Table (or something like that), you will find an example.
I hope this helps!
Please sign in to leave a comment.