Upload your Electronic Reporting objects to Dataverse solution automatically – How the new ALM in ER will look like.

In a previous post, I explained how I did to migrate all the existing ERs of a project to Dataverse. But what about the new ER reports or versions created after that? After months of not knowing what the new development/deployment cycle will look like due to the deprecation of RCS and the move to Dataverse, we finally have an answer! There is a new functionality to streamline the process of uploading to the Dataverse repository your Electronic Reporting objects right after you have developed and tested them in your development environment! That way you will be able to easily distribute them to all the different environments and also keep all your reports in one place, making easier to avoid ending up having divergent versions of the same report.

This functionality is included into the Upload into repository (that it normally worked so-so), but that now is a live safer/changer for all the ER developers that want to do the things correctly and use a Repository. … More Upload your Electronic Reporting objects to Dataverse solution automatically – How the new ALM in ER will look like.

D365FO Electronic Reporting: Dynamic Height (Auto-fit Height) in Excel rows with wrap text and merged cells

If you have worked with Business documents or with ER Excels, you have probably faced the issue of having merged cells that don’t vertically grow dinamically to be adjusted to the content. Did you know that there’s an OOB solution for it? In this post and also in below video, we are going to see it in detail, hence you can avoid making the errors I did when I discovered it and started to implement it in all my ER reports. check it out! … More D365FO Electronic Reporting: Dynamic Height (Auto-fit Height) in Excel rows with wrap text and merged cells

D365FO ER (GER): Error while evaluating expression…

In this post (and you have the video version of it in YouTube), we are going to understand why this pretty common error happens, giving us the tools to see what is wrong, and troubleshooting the error. We are going to see 2 different examples, first didactic one, made out by me to force the error and help us understand it, and second one, a real ER error from the OOB BAI2 Bank statements, that I had to face lately in a project. … More D365FO ER (GER): Error while evaluating expression…

D365FO Electronic Reporting complete real export to Excel example: Use of AllItemsQuery, ListDistinct and ListJoin

In this video/post we are going to go through the requirement of exporting all the CustInvoiceTrans with the related header and lines charges. This is a real requirement example that I chose because I find it very didactic, since given the table structure I was forced to use and understand the functions AllItemsQuery, ListDistinct and ListJoin. I also take advantage of this example to explain again how to export data to excel, generating myself the Excel template with the ranges and everything. Check it out, it is a good opportunity to continue strengthening your ER abilities! … More D365FO Electronic Reporting complete real export to Excel example: Use of AllItemsQuery, ListDistinct and ListJoin

D365FO Reports in ER. Destinations with direct execution or Print Management for Business Documents.

In this post we are going to explain how to configure the Electronic Reporting Destionations to convert a report to PDF, send it to the archive, send it by email, etc. You have also this video where I configure and explain it for our report used in previous videos/posts and for a Business document report in the print management destinations. … More D365FO Reports in ER. Destinations with direct execution or Print Management for Business Documents.

Electronic Reporting From Scratch part 4: Optimization of GER. FILTER vs WHERE and debugging your ER.

Electronic Reporting, despite not being code based, is still development, and it deals with data whether it is used for reporting or for integration purposes, so performance is something to definitely take into acount. In this video we include the ER Perfomance into the table, bringing an example that will help us understand how data is loaded into the ER and to give the importance to the optimization that it really has. … More Electronic Reporting From Scratch part 4: Optimization of GER. FILTER vs WHERE and debugging your ER.

D365FO SSRS Report parameters (Cell definitions) error

If you work with SSRS Reports, specially duplicating out of the box ones, you will probably have to deal with the parameters errors after restoring a dataset. This quick post will help you understand why is this happening and how to fix it, as it may not be straightforward and the errors are not self-explanatory. … More D365FO SSRS Report parameters (Cell definitions) error