Designing a RDL report from multiple tables | RDL Report in Business Central | BC Tutorial
HTML-код
- Опубликовано: 19 сен 2024
- Hi Viewers,
Designing a RDL report from multiple tables | RDL Report in Business Central | BC Tutorial
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...
======================================================================
#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 #rdlreport #reports
Happy learning
Good and on important parts confusing about rows and columns and some other stuff. But this leads to trouble shooting qualities of the developer 🙂
Thank you very much Goms
Hi,
Thank you for your feedback! I'm glad that you found the video helpful for the most part. I understand that the rows and columns section could be confusing, and I'll try to make that part clearer in the future.
I'm glad that you were able to troubleshoot the issues you encountered, and I hope that you continue to enjoy my videos.
Thanks again for your feedback!
Best regards,
Dr. Gomathi S
Thank you for this video! I have 3 questions about line 186
DataItemTableView = sorting("Document Type", "No.");
1. Does it mean "first sort by doc. type and then by number"?
2. How are the automatical sortings in BC? As I understand it BC will apply alphabetical sorting for text field (like doc. type here), numerical sorting for numbers (like customer no. here), is that correct?
3. What happens if you write it the other way around: sorting("No.", "Document Type")?
Absolutely, please find the answers for your question
1. Does it mean "first sort by doc. type and then by number"?
Yes, you're exactly right! The code DataItemTableView = sorting("Document Type", "No."); performs hierarchical sorting in Microsoft Dynamics. Here's how:
Primary Sort: It first sorts the records based on the "Document Type" field in ascending order (likely alphabetical order).
Secondary Sort: For records with the same "Document Type", it then sorts them based on the "No." field, also in ascending order (likely numerical order).
2. How are the automatic sortings in BC?
You're spot on. Microsoft Dynamics Business Central (BC) employs default sorting behaviors that depend on the field's data type:
Text Fields: Alphabetical sorting (A to Z) is applied to text fields like "Document Type".
Number Fields: Numerical sorting (ascending or descending) is used for number fields like "No." or "Customer No.".
3. What happens if you write it the other way around: sorting("No.", "Document Type")?
The sorting order would be reversed. Here's what would happen:
Primary Sort: The primary sort would be based on the "No." field in ascending order (numerically).
Secondary Sort: For records having the same "No." value, a secondary sort would be performed based on the "Document Type" field in alphabetical order.
Thank you so much for your support.
Thanks, It would be so nice. If there are the printing result showing. Thank you
Sure, I will show i the upcoming videos
Hello can you tell us how you connect the first and the second table, because when I try I get only for first customer info in upper table, and for lower table everything seems okay, thank you very much.
Thanks. I did not uderstand EntryNo_CustLegerEntry adding part to table. what you did there? also why use list? can you explain more about group part.
Sure.
Thanks for this detailed explanation. I start newly with AL language and building reports. I need to ask you is there any way we can send parameters from AL language in VS Code to MS Report Designer?? Thanks in advance
Yes. Please check the videos related to reports.
@gomstechtalks Thanks for the quick response. I am watching the videos now
Great
@@gomstechtalks I watched the report videos but I could not find how to pass parameters from .al file to rdl file. I was hoping to send dynamic parameters from code behind. Can you please guide me to how to do it as I was not able to figure out how you did it (passing parameters from code behind to report designer) ?? Thank you very much in advance.
Amen Amen Amen
Dear Dr.Gomathi, I try to download BC tutorial, particulaly reference to multiple tables for RDLC report. I cannot able to locate it from gitgub site. Could you able to send me the link , please. Thank you so much. I like your teaching styles.....
Please check here github.com/Gomathikrishna/D365-Business-Central-AL-Programming
Why we use First while selecting the field ??
Returns the first value in the given scope of the specified expression in a paginated report. You can try LAST function and check the difference.
Hello madam how to convert amount in words in report
You should hard code it by writing function wither in BC or in RDL
Hello how to add field in report without using dataitem
Please check here: ruclips.net/video/gg8xCN_8ydo/видео.html&pp=iAQB
I want to add new field in RDLC layout report using coding without data item
In link given by you that is for word layout..I have added two dataitem in my report but I want to add another field from third dataitem by using coding..how it is done
Then how will you save the data? Only if you create it through coding the data will be stored in table
16:01 How did you run it?
Ctrl+ F5
@@gomstechtalks Thank you very much.
I want to print report header 1 time only
Plz give example.
To print a report header only one time in an RDL report, you can use the built-in feature of the report header. By default, the report header is printed on each page of the report. However, you can configure it to print only on the first page by following these steps:
1. Open your RDL report in Visual Studio or your preferred editor.
2. Locate the Report Header section in the Design view of the report.
3. Right-click on the Report Header and select "Properties" from the context menu.
4. In the Properties window, locate the "PrintOnFirstPage" property and set it to "True".
5. Save your changes and preview the report to see the header printed only once on the first page.
I hope this helps you with your RDL report!
what is compiler error? like 0706
Please check here learn.microsoft.com/en-us/dotnet/csharp/misc/cs0706