Excel report in Business Central | Report Object in BC | Complete tutorial | Trending
ฝัง
- เผยแพร่เมื่อ 10 ก.ย. 2024
- Hi Viewers,
Excel report in Business Central | Report Object in BC | Complete tutorial | Trending
This channel is dedicated to research aspirants and all who wish to learn technologies with easy examples and exercises. I will be uploading at least three videos every week. You can leave your expected topics which you wish to know in the comment.
Checkout your favourite playlist
==================================================================================
Important tutorials and videos (Playlist) that you should not miss
==================================================================================
1. Research: • PhD Course details, Ph...
2. SCI/Scopus/Annexure-I/WoS/UGC care indexed journals
• SCI, Scopus, Annexure-...
3. Weka Tutorial:
• Weka Tutorial
4. Tableau Prep Builder: • What is Tableau Prep |...
5. ETL Data Integration: Talend:
• What is ETL? well Expl...
6. AL Programming - Microsoft Dynamics 365 Business Central (AL Programming): • AL Programming for abs...
7. Web Designing for Kids:
• Simple sign-in form in...
8. Tableau Desktop: • Learn Tableau Basic Ca...
9. Python Interview Questions: • What is Negative index...
10. GraphPad Prism Statistical Tool: • Introduction to GraphP...
11. R and Rattle GUI for statistics and Research: • Introduction to R and ...
12. Minitab Statistical Tool: • How to download, insta...
13. Online teaching tool for teachers, professors and online mentors: • Best online Whiteboard...
14. Skill-up yourself: • How to become a google...
======================================================================
Social media:
Telegram group: t.me/globalres...
LinkedIn profile: / gomathisri
Instagram profile: @goms_tech_talks
Facebook profile: / goms.techtalks
Website: sites.google.c...
======================================================================
Happy learning
#gomstechtalks #dynamics365 #businesscentral #bc #bcal #trending #bctable #table #report #page #bctutorial #tutorial #business #central #womeninbusiness #business #365 #central #dynamics365businesscentral #dynamics365sales #alprogram #tableextension #alprogrammingtutorial #trending #bcal #bc #dbcnews #report #rdlc #rdlcreport
#github #repository #begginers #beginnertoadvanced #beginnertutorials #beginnerstutorial #guidelines #manual #bcmanual #freetutorial #freetutoring #freecourses #freecourse #freecourseswithcertificates #career #microsoft #microsoftproject #projects #project #visualstudio #visualstudiocode #visual #dynamic #dynamics365sales #dynamics365tutorial
Great. Thank you so much Gomthi.😍
Glad it was helpful. Thank you for your feedback.
great work. Thank you dear Gom
Question: is there a video explaining how to add a field from one report to another in MS Business central?
For example: I want to add transfer order number into Transfer shipment report
Not yet. But sure I will consider this in my future video lists.
Good. Imparting knowledge with simple steps.
Thank you.
Thank you.. looking forward to learn more from you
Sure. Stay tuned. Will add the complete tutorial. Thank you.
Thanks
Welcome.
This too. Great Job. Thank you dear Gom :-)
Thank you kon for taking the time to share your feedback.
while running the report im getting a error like u dont have a license for onedrive?
idk how to sort that issue?
You need the license.
How to set row as blod format,background color using excel buffer in excel report
Please do the usual formatting. If you couldn't find out, please let me know.
I'm happy that you are covering each and every topics in business central. I'm learning more from your videos. Now I have project purchase order and project purchase requisition excels. My requirement is to convert these excels into pdf format. Can you put video related to my requirement of converting excel documents to pdf?
Sure. Will do that . thank you 😊
Hi Revathy,
Do you want to convert it in BC itself or? Can you breif the flow
Yes want to do it in bc only. I have set of excels like project purchase order, project purchase requisition, project budget, project cashflow and project dashboard. I want to convert this excels into pdf in bc. Is it possible to do?
You can directly convert it from Excel itself. Basically, doing through BC many need XMLPorts to convert. So from Excel itself you can convert it
But how? For eg. In my project purchase order excel I have so many columns like po date, po no. Supplier, usd, rate, utilised, over utilised, yet to utilised, status, credit term, estimated payment date, budget cost utilised, remarks and entity. I tried to design a layout for these columns in word using purchase order report. I can able to columns from purchase order from xml pane. But don't know where to get remaining fields. So many fields are not present in purchase order page. Is this approach is correct to do?
Hi mam,
How to Attach Documents to any Record of any Table in Business Central
Hi Venkat,
Please breif, what format of document and and what is the scenario.
Regards
Dr. Gomathi
Hi mam,
Dynamics 365 Business Central: How to add Attachments, Links, Notes Factbox to any pages
How can i put transalations for the columns? I want in spanish and English
It is possible in Excel with Add-ons or VBA script
Hi ma’am.. I am a technical consultant trainee .. I’m currently working in some customer projects.. I am getting so many doubts and trying to sort out,when ever I’m stuck.. I need to learn this properly..like I have started working in this technology since 5 months.. I need proper guidance which I’m not getting from my work space even though I’m intern.. can you please guide.. even I’m rdy to pay to learn.. I prefer learning through a live online course than a recorded section.. please help me
Hi, great to see that you are doing projects in BC. At present I am handling batch sessions for corporates and I don't have time for individual sessions. These videos are recorded during night time after my work hours. I can't help you with individual sessions immediately. Hope you can understand.
Regards,
Dr. Gomathi
Thank you so much for your time ma’am.. I understood..can you suggest any platform/courses which will be helpful for me to learn
Microsoft learn
Hello Mam there is a question that if we want to get sum of Balance or PurchaseLCY Field that u have added in the cell below the last balance data what should i do for that?
Hi Ratnesh,
I have explained how to aggregate the functions in the "multiple tables in a single report" video. You can go to that parameter and use sum function to sum the balance.
Regards,
Dr. Gomathi
@@gomstechtalks @goms tech talks Yes mam it is but i need sum in excel report like in the report u hve created the sum i need in e7 cell, as we can get sum in rdlc format by expression and sum formula .
There are some enhancements in the excel and BC. Please give me some time to check that and get back to you.
Regards,
Dr. Gomathi
@@gomstechtalks Oky Mam thank you for your time.
Hai, how do i can use rdlc report builder on mac os ?
Please check whether this is useful.
help.boldreports.com/report-viewer-sdk/aspnet-core-reporting/report-viewer/getting-started-for-mac-system/
at 7.35 can we show the sum of balance in this sheet but how??
Use Aggregate function
@@gomstechtalks Used sum function but not getting sum in Excel sheet when deployed.
Can we use OrderBy in a report? To make it ascending or descending?
You can use it in the query or page. Not on report.