Save report dataset to Excel from the request page (BC18.3+)

 

How to see dataset in Business Central reports

 

We used to have “About this Report” option to export the dataset of the report to inspect the data that is generated by a report dataset in earlier Dynamics NAV versions. This was very useful to filter the reports and optimize the dataset performance.

 

Microsoft included new feature that does similar to above functionality from D365 Business Central version 18.3 onwards. This new feature exports report dataset to Excel.

Step 1: Open the feature management page.

Step 2: By default, all the features are not enabled. Select the feature (Export report dataset to Microsoft Excel document)

 

 

Step 3: We need to enable the feature by changing the value of Enabled for from None – All users

 

Step 4: Refresh the environment for reflecting the new changes.

 

  

Step 5: Now, open Posted Sales Invoices page and then try to print the report for any posted document.

 

 

Step 6: In the request option page select “Send to…” option

 

 

Step 7: In the given “Choose file type…”, select “Microsoft Excel Document (data only) option and click “OK” to download the dataset to Excel document.

Step 8: Now, open the downloaded excel document to view the dataset.

Step 9: To view the developed layout with the data select another option “Microsoft Excel Document (data and layout)” and click OK.

Step 10: Open the downloaded excel file to see the report output with the developed RDL layout.

 

Start your free Dynamics 365 Business Central trial

Do you want to try, learn and explore Business Central?

Please follow below steps on how to set up a free Business Central trial environment.

 

1. Browse

     https://www.microsoft.com/en-in/microsoft-365/enterprise/office-365-e3

 

2. Click on Free Trial

 

3. Enter Email address and click Next

 

4. Click on Set up account

 

5. Enter details and click Next

 

6. Select either Text me or Call me and click on Send Verification code

 

7. Enter verification code that you have received and click Verify

 

8. Now we must select our domain

 

9. Enter the domain name and click “Check availability”.

 

10. Click Next

11. Enter a Username and password

12. Click Sign up

 

13. Click Get Started

14. Download Office apps if you want otherwise click Continue

 

15. Select “No, use default for now” option and click “Use this domain”

16. Add new users if you want otherwise click “Do it later”

17. Click continue

18. Click continue

 

19. Provide your feedback and submit and then click “Go to admin center”

20. Now we are in Microsoft 365 admin center.

 

21. In the same browser, open http://businesscentral.dynamics.com/ to sign up for Dynamics 365 Business Central

22. Click Sign In

23. Select or enter the account which we have created in above steps

24. Enter the password and click Sign In

25. You can select yes/no in below screen. 

 

26. Then it will start setting the Dynamics 365 Business Central environment in back end. Will take couple of minutes.

27. If you by any chance get below screen, then please keep waiting.

28. Click on Get started

29. Click Skip & go to Dynamics 365 Business Central

30. Click on Get Started.

31. Now we are in Dynamics 365 Business Central environment.

 

In next post, I will explain how to manage different environments from Dynamics 365 Business Central Admin center.

What Code Analyzers are right for you?

A code analyzer is a library that builds on the compiler's functionality to offer enhanced analysis of the syntax and semantics of your code at build time. The AL Language extension for Visual Studio Code contains four analyzers:

·        CodeCop is an analyzer that enforces the official AL Coding Guidelines. For more information about the CodeCop rules, see CodeCop Analyzer Rules.

·        PerTenantExtensionCop is an analyzer that enforces rules that must be respected by extensions meant to be installed for individual tenants. For more information about the PerTenantExtensionCop rules, see PerTenantExtensionCop Analyzer Rules.

·        AppSourceCop is an analyzer that enforces rules that must be respected by extensions meant to be published to Microsoft AppSource. For more information about the AppSourceCop rules, see AppSourceCop Analyzer Rules.

·        UICop is an analyzer that enforces rules that must be respected by extensions meant to customize the Web Client. For more information about the UserInterfaceCop rules, see UICop Analyzer Rules.

  

If you are developing an app for AppSource (ISV, Add-on Apps) then you need to enable below Code Analyzers

AppSourceCop 

CodeCop 

UICop 

 

If you are developing a customization for a specific customer then you need to enable below code analyzers

PerTenantExtensionCop 

CodeCop 

UICop 

Do not forget to set "al.enableCodeAnalysis": true

 

Change in sandboxName in Launch.json

 

I was delivering a D365 Business Central training to a client today and was explaining about Launch.json and mentioning that the launch.json file contains information about the server that the extension launches on.

And if we have multiple sandbox environments then we must specify which sandbox to be used in property called “sandboxName”

 

Tried to add the parameter and not able to find it.

 

Shocked for a second and noticed 2 new properties in the Launch.json

 

environmentType: Specifies environment to use to connect to Business Central.

Ex: Sandbox: Specifies a sandbox environment

environmentName : Specifies which production, or sandbox environment to use.

 

Looks like Microsoft has replaced sandboxName with environmentName and provided option to select the environmentType.   

 

Did not use Production option yet.

How to upgrade AppSource/Marketplace Apps without uninstalling and installing again

With latest Business Central Admin center, we can check if there are any latest version of app available in AppSource/Marketplace.

1.    Go to Business Central Admin Center

2.    Click on environment that you want to check for updates and click on it (ex: Production)

3.    Click on Manage Apps

4.    Here we can see if there is any new version available in “Latest Available Version” field and option install in “Available Update Action”

5.    In below example screenshot, we can notice that there is a new version 5.3.0.1 available Progressus Software and we can install by clicking “Install Update”

6.    We get confirm notification when we click on “Install Update”

7.    Update will be scheduled once we click on Yes

8.    Will start updating

9.    And finally will be updated

MVP (Microsoft Most Valuable Professional) 2020

I am happy to announce that I was awarded by Microsoft, with the Microsoft Most Valuable Professional (MVP) Award for 2020-2021 in the category Microsoft Business Applications (D365 Business Central/Dynamics NAV). This is my 9th Microsoft MVP award. 

A big thank you for the Blog readers, Facebook Followers and twitter @mohana_cse06 Followers.  

Who are MVPs?

Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart.

Source https://mvp.microsoft.com/en-us/Overview