Adding fields to reports with ReportExtensions in AL and Business Central

Поделиться
HTML-код
  • Опубликовано: 19 сен 2024

Комментарии • 60

  • @sonnythspoon
    @sonnythspoon 2 года назад +2

    Erik, thank you for the videos. Not only do I use then regularly, I forward them to my coworkers and student CO-OPs I bring in to learn Business Central development.

  • @anada1124
    @anada1124 3 года назад +1

    Thank you, Erik.
    You can actually make money for the next 6 months by making your videos about Report Extension chargeable because many people have been waiting for the new feature for a long time :)

    • @Hougaard
      @Hougaard  3 года назад +2

      Great idea, but content on this channel is free (as in beer), if you want to support the channel, buy my software :)

    • @anada1124
      @anada1124 3 года назад +1

      @@Hougaard Yes, I will recommend your software to my customers where applicable.

    • @Hougaard
      @Hougaard  3 года назад

      @@anada1124 That's awesome, thanks!

  • @ankitkishore77
    @ankitkishore77 3 года назад

    Always the best from the BC expert... Thanks Erik :-)

    • @Hougaard
      @Hougaard  3 года назад

      Glad you think so!

  • @cobrasubtilty4681
    @cobrasubtilty4681 2 года назад

    Doktore! Thank you for the great videos.

  • @cnclover
    @cnclover 3 года назад

    Thank you, Mr.Erik.

  • @Moioiland
    @Moioiland 4 месяца назад

    In your "Custom Report Layouts", where did you get all those Word templates? Did you have to create all of those? Mine are all rdlc.

  • @kennienybo
    @kennienybo 3 года назад +3

    maybe show how to add a 1D barcode using a report extension

    • @Hougaard
      @Hougaard  3 года назад +2

      Barcodes are on "the list" :)

  • @mohammedmarhoon7408
    @mohammedmarhoon7408 3 года назад +1

    Hi Erik Thanks for great info. What if we need to link a column from a table not in the main Report

  • @indranijayakody3381
    @indranijayakody3381 2 года назад

    Thank you very much Erik. after watching this video , After long time I started to work on development side BC Reports again and modify the Sales Invoice. also I am trying to get Customer Statement only with Open entries from Customer ledger entries. Selection page only we have filtering fields from Customer Table 18, if we have customer entry table then we can filter open = true. any sections please? Many thanks in advance,

  • @CarlosGonzalezFuster
    @CarlosGonzalezFuster 3 года назад

    Hi Erik, what we have to do to add a flowfield field to a data set. Where we have to put the calcfield? Many Thanks

  • @muqeetataderinto2977
    @muqeetataderinto2977 Год назад

    Hello Erik, appreciate your videos. I have a question:
    I'm trying to add vendor bank account details to the Day Bank Vendor Ledger Entry Report. The vendor name is appear for all the GL entries. Pls can I have your input on it?

    • @Hougaard
      @Hougaard  Год назад +1

      Not enough information to be able to help, sorry

    • @muqeetataderinto2977
      @muqeetataderinto2977 Год назад

      @@Hougaard Can I forward the details to your email address?

  • @AndrasAlakszai
    @AndrasAlakszai 2 года назад +1

    Hi Erik, Thanks for the great videos.
    Is there a way to add a column from another table? linking to a field from the original report?

    • @Hougaard
      @Hougaard  2 года назад +2

      Sure, but it requires a bit of code.

    • @jared6171
      @jared6171 2 года назад +2

      Did you ever figure this out? I am trying to add a column from another table right now.

    • @muqeetataderinto2977
      @muqeetataderinto2977 Год назад

      Did you ever figure this out? I am trying to add a column from another table right now.

  • @carajter07
    @carajter07 2 года назад

    Hey howard, i have created a Custom-Field by table-extension and Page-Extention ( thx to your eLi5 video) . Now I would like to extend-the report 1302, but can find the afore mentioned custom field. ( The custom field is deployed and shows in Gui)

    • @Hougaard
      @Hougaard  2 года назад

      Are you extending the right element in the dataset?

  • @sainudheenthacharathodi4892
    @sainudheenthacharathodi4892 Год назад

    Hi Erik Thank you for the videos, Hi, I have one doubt on date formatting, How we can format the date for ex: the due date in the sales invoice (1306), current date format is mm/dd/yy how can I change this into dd//mm// yy, .without coding is it possible,Thanks in advance

  • @abdulrahmanmahfudh405
    @abdulrahmanmahfudh405 Год назад

    Can you do a tutorial on adding shortcut dimensions 3 and 4 in a sales invoice

    • @Hougaard
      @Hougaard  Год назад

      Isn't it already there?

  • @Marni1997
    @Marni1997 Год назад

    Hi Erik, can I do this without a Microsoft Developer License?

  •  3 года назад

    Hi, Erik.
    I noticed that ins app.json now, appears: platform: "1.0.0.0". And yes, in application: "18.0.0.0" unlike in previous versions. i.e: platform: "17.0.0.0", application: "17.0.0.0" .
    Do you know if that's a bug?, or have they change their mind with in the way platform works now?

    • @Hougaard
      @Hougaard  3 года назад

      I don't have any explanation right now...

  • @shalikasamarakoon6702
    @shalikasamarakoon6702 3 года назад

    Hi @eric,
    Thank you very much for the presentation and can you do a training on showing item image in sales quotation?
    1305 sales confirmation.

    • @Hougaard
      @Hougaard  3 года назад

      I'll put that on the todo list :)

  • @komica007
    @komica007 Год назад

    Hello Erik,
    As first thank you for another useful video and spreading knowledge.
    I have a problem with Report Layouts and Run Report action.
    Page : Report Layouts (9660, List)
    Table: Report Layout List (2000000234)
    Run Report action always use default layout no matter what layout is selected!
    Have you any idea why this is happening?
    Thank you in advance,
    Best regards,
    Goran

    • @Hougaard
      @Hougaard  Год назад

      What version of BC?

    • @komica007
      @komica007 Год назад

      @@Hougaard BC365 SaaS, Version: W1 21.4 (Platform 21.0.52534.53435 + Application 21.4.52563.52602)

    • @komica007
      @komica007 Год назад

      Finally solved by activating Feature:
      Feature Management/Feature: New Microsoft Word report rendering platform. -> Enabled for All Users
      Best regards,

  • @mastertomi01
    @mastertomi01 2 года назад

    Hey Erik, thank you! I have a follow-up question:
    I have self-created fields in items that I want to include in the report. How can I find the fields and add them to the report?

    • @Hougaard
      @Hougaard  2 года назад

      Then you can create a ReportExtension object and add the fields to the DataSet of the report.

    • @mindnoise3501
      @mindnoise3501 2 года назад

      @@Hougaard Thank you! I'm new to AL. Do you may have reference I can look at? :)

    • @Hougaard
      @Hougaard  2 года назад

      @@mindnoise3501 ruclips.net/video/HxixMUEqEmE/видео.html

  • @ChristopheWatrelot
    @ChristopheWatrelot 3 года назад +1

    Any idea for a multilayout report (select one at runtime) ?

    • @quentinturban1590
      @quentinturban1590 3 года назад

      I was going to ask the exact same question 😂 And it is very frustrating because in "what's new and planned for BC18" there was an item mentioning this feature few weeks ago so I guess it was in the scope but it just disappeared from the page now.

    • @Hougaard
      @Hougaard  3 года назад +2

      Like this: ruclips.net/video/hPMWTToSO1A/видео.html ?

    • @ChristopheWatrelot
      @ChristopheWatrelot 3 года назад

      @@Hougaard
      Works fine, thanks a lot

  • @hicamajig
    @hicamajig 3 года назад

    Do you know of any good resources for writing RDLC reports? I feel like every time I try to do so it is always extremely painful and gets nowhere fast.

    • @Hougaard
      @Hougaard  3 года назад +1

      I don't - rdlc is a topic I try to avoid as much as possible :)

    • @davidhofschneider7842
      @davidhofschneider7842 3 года назад +1

      I can recommend the book from Steven Renders about reporting.

  • @vijar89
    @vijar89 2 года назад

    Hi Eric,
    I've added a table extension to the Sales Order (table 36)
    but i cant see that field when i try to add it to the report.
    I can see the field i added on the Sales order card in BC.
    Any thoughts?
    Thanks

    • @Hougaard
      @Hougaard  2 года назад

      What report?

    • @vijar89
      @vijar89 2 года назад

      @@Hougaard 1305 "Standard Sales - Order Conf." i created a field called Credit Hold , i can see it in BC on the sales order card but can't see to find it when i use the "Column" function on line 7 of your video

    • @Hougaard
      @Hougaard  2 года назад

      Is your reportextension in the same extension as where you added the field or are you missing a dependency in app.json?

    • @vijar89
      @vijar89 2 года назад

      @@Hougaard yup its the same

    • @vijar89
      @vijar89 2 года назад

      @@Hougaard Hi Eric, I've started fresh this morning and it works , not sure what was happening yesterday. Thanks again for your response.