Ssrs – Temmy Wahyu Raharjo

How to install Dynamics 365 Report Authoring Extension from Scratch

I rarely create/update reports. And to be honest, my knowledge actually stuck on creating reports using “Report Builder” which at that time we still used the On-Premise version to query the things we needed to make the report. While the latest version uses Fetch XML and forces us to basically install the extension that we will cover today. So, when I got one, it was very frustrating to install the tools needed step by step. So here is how to install everything from scratch!

Consume WCF from SSRS Report

Now we prepare our WCF Service first. I created a new WCF Application Service. Then for demo purposes, I create a simple method for returning dummy data:

Dataverse: AIReply in actionJune 16, 2024
Today, we will learn how to use AIReply in action. For those who don’t know AIReply is one of Dataverse AI functions that focus on replying to user answers similar to what GPT has. With this uniqueness, we can ask AI to cut steps in feedback creation. In this demonstration, … Continue reading "Dataverse: AIReply in action"
Dataverse Filtering Attributes benchmarkJune 2, 2024
I heard lots of dos and don’ts about performance enhancement specifically when creating plugins in Dataverse. One of the pieces of advice is about setting the “Filtering attributes” when registering the plugin step so the system will not run unnecessarily process. So, today we will check the benchmark between setting … Continue reading "Dataverse Filtering Attributes benchmark"
Dataverse: Query data using Fiscal Period and YearMay 25, 2024
Do you need to query data with the filter based on the Month/Year based on the specified date in your records? Today, we will learn how to query it and hopefully, you can implement it in your future project!
Dataverse: Update Time zone adjustment from Time zone Independent to User Local and Date time BehaviorMay 18, 2024
Hello everyone! I’m sharing my observation regarding Dataverse Date time (again). Previously, I updated several DateTime attributes from Time zone adjustment “User Local” (which is the default value) to “Time zone independent“. Then, my functional reported that the Date Time seemed weird as the Created On of the record vs … Continue reading "Dataverse: Update Time zone adjustment from Time zone Independent to User Local and Date time Behavior"
Low + Pro Code: Create Dataverse Invoice Record based on Power Automate Extract Invoice InformationMay 12, 2024
Hello! For today’s scenario, we will learn how to automate the process of creating a Vendor Invoice record in Dataverse using an uploaded Vendor Invoice PDF file that comes to OneDrive’s company folder. To be exact, we will learn how to utilize Power Automate to simplify the trigger point, supply … Continue reading "Low + Pro Code: Create Dataverse Invoice Record based on Power Automate Extract Invoice Information"
Dataverse – Convert UTC Time to User Timezone in PluginMay 4, 2024
Today, I’ll share a quick tip on converting the UTC date to the User’s Timezone settings in the Plugin (once you read the logic, you can also implement this logic into Power Automate/Custom API). In Dataverse, we can set our timezone in the below UI (go to Settings > Personalized … Continue reading "Dataverse – Convert UTC Time to User Timezone in Plugin"
[Low Code] Send Translated Message to User using App NotificationApril 27, 2024
Today we will learn how to create a Dataverse Instant plug-in using the AITranslate function. The purpose of AITranslate is to translate a message to the targeted language. For today’s scenario, we will learn how to query the selected Dataverse User’s UI Language and send the translated message using XSendAppNotification. … Continue reading "[Low Code] Send Translated Message to User using App Notification"
Build a Dataverse Plugin and use AIClassify to simplify business processApril 20, 2024
For those who don’t know, now we can call AI functions within Dataverse which helps to simplify lots of business processes. One of the scenarios that we will learn today is regarding Case/Feedback/Incident creation where users can just put minimal information such as “Title“, “Description“, and “Customer” and let the … Continue reading "Build a Dataverse Plugin and use AIClassify to simplify business process"
Dataverse: Implement Pre-lock in a plug-in transactionApril 6, 2024
Lately, my mind has traveled a lot on designing a plugin that can handle concurrency issues. Even though the framework itself has UpdateRequest and we can pass the RowVersion, I found the implementation does not always fit with some of the scenarios especially if you want to avoid throwing “Error” … Continue reading "Dataverse: Implement Pre-lock in a plug-in transaction"
Dataverse: Create an API to update Base CurrencyMarch 23, 2024
This time, I’ve got a request from Trung Dũng Nguyễn where he wants to update the base currency based on the updated Currency inputted into the Transaction Currency table. When I check on the system behavior, the Currency (Base) information will be updated as long as we update at least … Continue reading "Dataverse: Create an API to update Base Currency"