You’re offline. This is a read only version of the page.
2,983
I have this report design where parent DataSet is "Customer" then child is "Vat Entry" and SubChild is "Item"
In the Request Page I'm putting a Item Categorý Code filter in the Item Table, but it's getting ignored. I'm getting VAT Entries from Items of other categories in my report.
Is this expected behaviour??
*This post is locked for comments
Is that because there is no relation between VAT Entry and Item?
Even setting this property to Yes will make the OnAfterGetRecord of "Value entry" to trigger and affect other sections or datasets, like the Integer DataSet in My Example. In the case of my report, we add data to some buffers to show totals at the end of the document. We are trying to avoid this buffers to have data of items that must be filtered.
Finally I solved it using FILTERGROUPS:
In my Value Entry OnAftergetRecord I put this code:
Share
Report
All responses (
Answers (
ItemFiltersTxt := ItemTable.GETVIEW; //this is a local Text variable
rItemFilter.FILTERGROUP(10); //rItemFilter is a local record variable
ritemFilter.SETVIEW(ItemFiltersTxt);
rItemFilter.FILTERGROUP(0);
ritemFilter.SETFILTER("No.","Item No.");
IF NOT rItemFilter.ISEMPTY THEN BEGIN
//INSERT DATA IN BUFFERS THAT AFFECT OTHER SECTIONS AND DATASETS
Is there VAT-information in the table "Value Entry"?
For NAV2017, I couldn't find anything related to VAT in this table.
Wow.. so this is like an "Outer Join" behaviour.. it's the first time I realize this. So how could I enable an Item Table filter? The idea is that the user is able to get VAT entries using Customer filters and Item Filters (Customer ID, Customer Groups, Item ID, Item Groups, etc..)
If I put the Item Table above the Value Entry DataSet, I loose the customer filter. Any way to mantain both table filters (customer and item)
I just found this dataset property:
PrintOnlyIfDetail (but it's not working)
Yes. With the above mentioned filter, you control the output of the "Item"-DataItem only.
Because it's a Child-DataItem, it does not affect the output of the Parent-DataItem.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156