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 for that nice video! I have two questions: Can I also implement in my sales doc the Tariff number and the origin of country? Second question: I want to add the position number in my sales docs like: 1, 2, 3 and not like the line numbers 10000, 20000, etc.
Quick update: I was able to add the pos number (with your video) but for the description fields in my sales docs it adds ‚0‘ can I make them invisible? I still was not able to add the tariff number and the origin country of item :/
Hi Erik, thank you for the great video, sadly am not very good with computer so i couldn't fully apply this to my needs, i wonder if i can get help, i have the default "item register-quantity" report downloaded in .rdl extension and I need the organization the item being transferred to be shown in the printed report
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)
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, 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
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.
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,
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 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
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
@@Hougaard Hi Eric, I've started fresh this morning and it works , not sure what was happening yesterday. Thanks again for your response.
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?
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.
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.
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 Thanks for great info. What if we need to link a column from a table not in the main Report
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.
Thank you for that nice video! I have two questions: Can I also implement in my sales doc the Tariff number and the origin of country? Second question: I want to add the position number in my sales docs like: 1, 2, 3 and not like the line numbers 10000, 20000, etc.
Quick update: I was able to add the pos number (with your video) but for the description fields in my sales docs it adds ‚0‘ can I make them invisible? I still was not able to add the tariff number and the origin country of item :/
Hi Erik, thank you for the great video, sadly am not very good with computer so i couldn't fully apply this to my needs, i wonder if i can get help, i have the default "item register-quantity" report downloaded in .rdl extension and I need the organization the item being transferred to be shown in the printed report
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
maybe show how to add a 1D barcode using a report extension
Barcodes are on "the list" :)
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.
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?
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 ruclips.net/video/HxixMUEqEmE/видео.html
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,
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: ruclips.net/video/hPMWTToSO1A/видео.html ?
@@Hougaard
Works fine, thanks a lot
Can you do a tutorial on adding shortcut dimensions 3 and 4 in a sales invoice
Isn't it already there?
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,
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 Erik, can I do this without a Microsoft Developer License?
Yes.
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 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
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.
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...
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.