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.
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 :)
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,
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?
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)
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.
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?
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?
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 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
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.
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
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
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.
Always the best from the BC expert... Thanks Erik :-)
Glad you think so!
Doktore! Thank you for the great videos.
Thank you, Mr.Erik.
Hi Erik Thanks for great info. What if we need to link a column from a table not in the main Report
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 :)
Great idea, but content on this channel is free (as in beer), if you want to support the channel, buy my software :)
@@Hougaard Yes, I will recommend your software to my customers where applicable.
@@anada1124 That's awesome, thanks!
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
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,
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.
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?
Sure, but it requires a bit of code.
Did you ever figure this out? I am trying to add a column from another table right now.
Did you ever figure this out? I am trying to add a column from another table right now.
maybe show how to add a 1D barcode using a report extension
Barcodes are on "the list" :)
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?
I don't have any explanation right now...
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)
Are you extending the right element in the dataset?
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.
I don't - rdlc is a topic I try to avoid as much as possible :)
I can recommend the book from Steven Renders about reporting.
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?
Then you can create a ReportExtension object and add the fields to the DataSet of the report.
@@Hougaard Thank you! I'm new to AL. Do you may have reference I can look at? :)
@@mindnoise3501 czcams.com/video/HxixMUEqEmE/video.html
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?
Not enough information to be able to help, sorry
@@Hougaard Can I forward the details to your email address?
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.
I'll put that on the todo list :)
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
What report?
@@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
Is your reportextension in the same extension as where you added the field or are you missing a dependency in app.json?
@@Hougaard yup its the same
@@Hougaard Hi Eric, I've started fresh this morning and it works , not sure what was happening yesterday. Thanks again for your response.
Any idea for a multilayout report (select one at runtime) ?
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.
Like this: czcams.com/video/hPMWTToSO1A/video.html ?
@@Hougaard
Works fine, thanks a lot
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
Change your region?
@@Hougaard Yes it helped , Thank you
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
What version of BC?
@@Hougaard BC365 SaaS, Version: W1 21.4 (Platform 21.0.52534.53435 + Application 21.4.52563.52602)
Finally solved by activating Feature:
Feature Management/Feature: New Microsoft Word report rendering platform. -> Enabled for All Users
Best regards,
Can you do a tutorial on adding shortcut dimensions 3 and 4 in a sales invoice
Isn't it already there?
Hi Erik, can I do this without a Microsoft Developer License?
Yes.