Great Job - and it's sometimes funny to see how you go through things which will not work as you want - To repeat data in a table in Word for the German developers: Tabellenzeile markieren In XML-Zuordnung Rechtsklick auf "Customer" Inhaltssteuerelement einfügen / wiederholt auswählen Und dann in jede Spalte das von Gom beschriebene Verfahren anwenden, also "Inhaltssteuerelement einfügen" / "Nur-Text" Thank you dear Gom! Kind Regards Carsten
Hi Everyone, We can do repeating option on dataset (in Word) to show all line items of child table while designing the report as shown below. Make sure you must select one complete rows of line item table in word file before applying it Select complete rows of table--.> Select Dataset Item (not columns) --> Right Click--> Insert Content Control --> Repeating After the above step , add respetive cloumns by selecting column elements
Thank you for this great tutorial! Can you please explain what is the difference between Ctrl+Shift+B and Ctrl+F5? I mean with Ctrl+F5 you see the results in BC but in Minute 18:30 you create before that a package. What's is the importance or benefit of creating a package previously?
Thank you for your support and feedback. Compiling a package using Ctrl+Shift+B in Visual Studio triggers a build process, ensuring that your code is translated into machine-readable instructions. This step checks for syntax errors and creates the executable file. So, compiling with Ctrl+Shift+B ensures a clean build, while using Ctrl+F5 additionally launches the application without attaching the debugger. This can be useful for testing the standalone, release version of your program. Hope I answered your question.
Hi Maam, thank you for all your wonderful videos that is helping for self-development on AL language. However, my MS word did not display report name so am unable to select the fields and display it on the word layout as the Report name did not appear in the XML pane. Kindly assist. Thank you.
Its a very good Video, Thank you. But what is in Word Layout if I want to Have Customer as a Header AND Customer Ledger Entrys at Lines and I want to do this Report in Word?
@@gomstechtalks I try to build a onw Report with G/L Account and G/L Entry and later I need Sales Invoice. So I have three Repeater wich needs to run together according the first Data from Account
Hello, can we filter information on word-layout don't use filtering on the request page? for example, printing customers on layout by a specific customer number, Balance, address
Hi, I have one doubt on date formatting, How we can format the date for ex: the due date in the sales invoice, current date format is mm/dd/yy how can I change this into dd//mm// yy, .without coding is it possible
Please check here 1. Processing: ua-cam.com/video/S22MS8odsIM/v-deo.html 2. Navigation: ua-cam.com/video/pPaf8qXQkg0/v-deo.html 3. Creation: ua-cam.com/video/fCJN3iKPyxM/v-deo.html 4. Reporting: ua-cam.com/video/xrIY_vvVMJg/v-deo.html All the best Regards, Dr. Gomathi
I think I had the same problem. I get the same record repeated. Not diferent records, One for each client record. I think in video happens too. The two rows had the same client data.
Great Job - and it's sometimes funny to see how you go through things which will not work as you want -
To repeat data in a table in Word for the German developers:
Tabellenzeile markieren
In XML-Zuordnung Rechtsklick auf "Customer"
Inhaltssteuerelement einfügen / wiederholt auswählen
Und dann in jede Spalte das von Gom beschriebene Verfahren anwenden, also "Inhaltssteuerelement einfügen" / "Nur-Text"
Thank you dear Gom!
Kind Regards
Carsten
I was waiting for this report for very long days. As usual u explained it clearly. Thank you so much
Thank you Revathy. 😊
Perfect like always. Thank you so much. Waiting for more Videos related to report. Take Care Stay Safe Bye Bye
Thank you . you too stay safe. Take care.
Thabks and regards,
Dr. Gomathi
Perfect teaching like always on all your videos. thank you very much
Thank you Indrani🙂🙂🙏🙏
Hi Everyone,
We can do repeating option on dataset (in Word) to show all line items of child table while designing the report as shown below.
Make sure you must select one complete rows of line item table in word file before applying it
Select complete rows of table--.> Select Dataset Item (not columns) --> Right Click--> Insert Content Control --> Repeating
After the above step , add respetive cloumns by selecting column elements
Thank you, Stephen.
@@gomstechtalks That's what I also found out with the repeating data in tables. :-)
Thank you for this great tutorial! Can you please explain what is the difference between Ctrl+Shift+B and Ctrl+F5? I mean with Ctrl+F5 you see the results in BC but in Minute 18:30 you create before that a package. What's is the importance or benefit of creating a package previously?
Thank you for your support and feedback.
Compiling a package using Ctrl+Shift+B in Visual Studio triggers a build process, ensuring that your code is translated into machine-readable instructions. This step checks for syntax errors and creates the executable file.
So, compiling with Ctrl+Shift+B ensures a clean build, while using Ctrl+F5 additionally launches the application without attaching the debugger. This can be useful for testing the standalone, release version of your program.
Hope I answered your question.
Hi Maam, thank you for all your wonderful videos that is helping for self-development on AL language. However, my MS word did not display report name so am unable to select the fields and display it on the word layout as the Report name did not appear in the XML pane. Kindly assist. Thank you.
Plz Ignore maam I have sorted out this. Thanks
Great
Its a very good Video, Thank you.
But what is in Word Layout if I want to Have Customer as a Header AND Customer Ledger Entrys at Lines and I want to do this Report in Word?
Thank you. Possible, are you extending any report or doing your report?
@@gomstechtalks I try to build a onw Report with G/L Account and G/L Entry and later I need Sales Invoice. So I have three Repeater wich needs to run together according the first Data from Account
I can help if I can see the complete report code
Hello, can we filter information on word-layout don't use filtering on the request page? for example, printing customers on layout by a specific customer number, Balance, address
Hi, If you need filters, better use RDL or Excel layout.
Hi, I have one doubt on date formatting, How we can format the date for ex: the due date in the sales invoice, current date format is mm/dd/yy how can I change this into dd//mm// yy, .without coding is it possible
We can do this in the report builder
@@gomstechtalks report builder? do I need to create an extension for that or in the word layout I can make the changes.
You can try in the word layout
Please make video on action
Sure.
Please check here
1. Processing: ua-cam.com/video/S22MS8odsIM/v-deo.html
2. Navigation: ua-cam.com/video/pPaf8qXQkg0/v-deo.html
3. Creation: ua-cam.com/video/fCJN3iKPyxM/v-deo.html
4. Reporting: ua-cam.com/video/xrIY_vvVMJg/v-deo.html
All the best
Regards,
Dr. Gomathi
Create a record in word it will create only first record of table i want all the record in report
No, all the records will come. Check your table if you have all the data and if you are not getting it write the query to fetch the required records
I think I had the same problem. I get the same record repeated. Not diferent records, One for each client record. I think in video happens too. The two rows had the same client data.
The solution was gived by @stepheneapen in his comentary. Thanks.