web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

[INFO] Example how to add a report in Business Central SaaS/Cloud version with use locally hosted Container Sandbox

(0) ShareShare
ReportReport
Posted on by 1,659

1018.ALFlogo.png

for full version (95 pictures) go to https://github.com/finn777/ALF_Report/blob/master/readme.md

The world is changing … The cloud story is pushing us to use modern dev tools, docker container etc.

In this blog post I’ll try to show the example how to add a report in Business Central SaaS/Cloud version with use locally hosted Container Sandbox. The many pictures will below.

Imagine that we have a good old Business Central on-prem version and run report: Inventory - Sales Statistics

ALFReport00.png

The report is grouping data by Inventory Posting Group.

In our example we will try to create copy of this report but with small modification – remove grouping data by Inventory Posting Group. We are going to do it (finally) for Business Central SaaS/Cloud version.

Run Business Central SaaS/Cloud version (I used my test tenant for GB version, 14.3)

<...>

Well, now we need to use ‘an old trick’ take an exist standard object, rename it, set new object id and later modify a bit.

All standard object in .al format already in our folder Original-14.3.34444.0-W1-al

ALFReport43.png

<...>

Check images and containers.

===

docker images

docker ps

=== 

ALFReport74.png

<...>

Copy shortcuts to our DEV folder.

ALFReport76.png

<...>

ALFReport80.png

<...>

Create new Sandbox (Copy production data) tenant:

ALFReport86.png

ALFReport87.png

<...>

Well, open our Production tenant, Upload Extension:

ALFReport92.png

ALFReport93.png

Run new report (Cloud/SaaS production tenant).

ALFReport94.png

  • Suggested answer
    Alexey Finogenov Profile Picture
    1,659 on at

    no need answer

  • Verified answer
    Alexander Kats Profile Picture
    Microsoft Employee on at

    Alexey, thanks for very useful info!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans