Cool trick to run a Report on a Query in AL and Business Central

Поділитися
Вставка
  • Опубліковано 4 гру 2024

КОМЕНТАРІ • 6

  • @mikilr9276
    @mikilr9276 2 місяці тому +1

    Another great trick Erik, thank you very much.

  • @ihabkamalaldine2555
    @ihabkamalaldine2555 2 місяці тому +1

    Very Usefull Thanks Tonya & Erik!

  • @zepposprojects3205
    @zepposprojects3205 2 місяці тому

    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 😊

  • @criztina
    @criztina 2 місяці тому

    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?

  • @praveennagarajan6031
    @praveennagarajan6031 2 місяці тому

    What's the advantage instead of using existing request page filters ? Can u please explain this ?

    • @Hougaard
      @Hougaard  2 місяці тому

      Because they are in the UI on the report's request page.