Cool trick! Guess you could add a (temp) dataitem for the table(s) that are getting queried and transfer their filters that were set via the requestpage. Thanks for sharing 😊
hey, great tutorial! I've made something similar but know I can't use any field from the object, in your example the Customer Ledger Entry, as a filter in the report page, the only option is Integer and it's audit fields, the only solution I came up was to add another dataitem with the object and set the fields I need to show as filters, and pass the No. value in a trigger on the Integer dataitem, would there be a better solution?
Another great trick Erik, thank you very much.
Very Usefull Thanks Tonya & Erik!
Cool trick! Guess you could add a (temp) dataitem for the table(s) that are getting queried and transfer their filters that were set via the requestpage.
Thanks for sharing 😊
hey, great tutorial! I've made something similar but know I can't use any field from the object, in your example the Customer Ledger Entry, as a filter in the report page, the only option is Integer and it's audit fields, the only solution I came up was to add another dataitem with the object and set the fields I need to show as filters, and pass the No. value in a trigger on the Integer dataitem, would there be a better solution?
What's the advantage instead of using existing request page filters ? Can u please explain this ?
Because they are in the UI on the report's request page.