Customizing standard reports in Business Central

[@ant1d0te]

With BC 2021 Wave1 we may have ReportExtensions. Let's see how MS does it. But for now your information is priceless! :) Thanks!

[@ibrahiemrasoelbaks5124]

Thanks Erik. I've learned some new great skills by watching, developing and testing.

[@MrSuperAndrey]

Hi, would be great to show how to get the *.rdlc layout in case not using container.. For example for On Premise BC installation.

[@Hougaard]

Good idea, I'll add that to the list for the next video on reports (not going to happen straight away, got other things in the pipeline right now)

[@ericmuga]

@@Hougaard I have been looking for this, I didnt seem to get a workaround on premise Version 14 as I can't get the two .rdlc

[@anada1124]

Thank you, Erik. Doing this is not very difficult but improve UX a lot.

[@salimaamirouchen1136]

Thank you some much! Very clear and useful.

[@umarnaeem6128]

Can you create a video on creating a report having multiple dataitems as well as dataitem(integer; integer) for looping purpose, and some advance filtration on it like grouping items on item categories, something like that :D this kind of tutorial will be great for beginners like me :)

[@shahidullah07]

many thanks for nice session on report customization, Will be good to have another video on purchase order document report change , i like to add project code etc

[@Hougaard]

You can do that with just the Word layout change, have you tried that?

[@shahidullah07]

@@Hougaard I changed the whole report according to the company need, and i replaced the report with 50001 but its not working, could you please help, I like to replace the standard purchase order with my new report

[@shahidullah07]

@@Hougaard I did that

[@KulwantSingh-oz5xw]

How can we add report in mail body instead as attachment? It would be great if you share some inputs on it.. on cloud version..

[@tyler28533]

Very helpful :) thank you for sharing!

[@lawrencechikoore6081]

Hie Erik Im getting the error below You do not have the following permissions on Report New Standard Purchase - Order: Execute. To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '8507'.

[@rishichourey]

Nice Video Erik, waiting for a report extension video of yours in BC 2021 Wave1.

[@Hougaard]

Check the channel :)

[@rishichourey]

@@Hougaard Oh really!!! Thanks :)

[@alexjose7100]

Hi Erik , Thanks for such great video. Just one small doubt, is it possible to replace a particular layout of the standard report with our custom report instead of replacing the whole standard report itself?

[@Hougaard]

You can use the custom report layout to replace any layout in standard reports, check this kzbin.info/www/bejne/noGwiIeKpLiCZ6M

Hi Erik, Thanks for all your videos. I have a BC sandbox created using BcContainerWizard but I can't find the rdlc file you mention on your video. Do I have to do something special for the file to appear?

[@Hougaard]

You need to add -includeAL on the createe container command to get the base app objects.

@@Hougaard Hi Erik. I understand I need a License file to specify that option, or it asked me or a license file during the wizard. I have a cloud deployment and I don't know how to get a Licence.I will keep searching. Thanks a lot for your help!

[@Hougaard]

@ You can download your license (know as dual use) from Microsoft.

[@chirangaranasinghe19]

Thank you so much.

[@drewkipfer5404]

Nice shirt!

[@Hougaard]

You don't have to be a rocket scientist ..... but it helps :)

[@ihabkamalaldine2555]

Hi Erik, thank you for the great tutorials can you please make a tutorial how we build a report from a to z like create a new report and manage the line,table,etc... thanks.

[@anujchaudhary6985]

What was the did u use in Power shell to cpoy the object?? Please tell\

[@Hougaard]

The BC Container Helper did for me because I add the -IncludeAL parameter...

[@ta3113ta]

Thanks. this vdo helped me a lot.

[@cnclover]

Thank you!

[@RaiBilalHaider]

Hi Erik, I am trying to find detailed information about the use of temporary table and its scope. I am unable to find any practical content about that. Can you help on that by sharing some info. Thanks

[@Hougaard]

I'll put that on the videos-to-do-list :)

[@BoPeepBo]

Hello, How I am using a trial cloud sandbox environment. Not docker. How do I get to the part where you are using the windows powershell to search for the report object? What are the pre-requisites for that?

[@Hougaard]

Please the the new reportextension objects in version 18 instead.

[@BoPeepBo]

@@Hougaard Thank you sir. Does that also work for older BC versions before 18?

[@Hougaard]

It does, custom report layout came in NAV2016 (I believe)....

[@Sapnehigh]

Hi Erik, I want to replace a codeunit with new one, so is there any method or procedure that can replace the same

[@Hougaard]

Great question... But no.. Only if the codeunit is actually using the new interface types.

[@Sapnehigh]

@@Hougaard Thank you Very much.

[@faaizahmed3146]

Dear Erik, can i see the report preview without using runrequestpage??

[@Hougaard]

Nope, there are tricks to save the output and show that...

[@rendipratama42]

Sir can i ask you, How to custom standart report BC from wordlayout to RDLC layout using report builder ? cz i already copy di report and build rdlc layout, then i run , output is not in accordance with the report standart before (wordlayout)

[@Hougaard]

Have you assigned your new layout to the report in "Report Layout Selection" ?

[@rendipratama42]

@@Hougaard ya sir , report layout selection > custom layout then export after that, when i open the layout from report builder, layout empty.. but dataset exists now, i create from scratch for my layout sir, i have question, how to get current company login / session company id from user login

[@anujchaudhary6985]

Sorry Command