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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Custom reports, datasets missing

(0) ShareShare
ReportReport
Posted on by 15

Hi all, 

We are currently running an implementation of Business Central for a client, and have had some difficulty with building custom reports. 

Using MS Report Builder, it seems that the datasets for Ship-to address do not actually pull the ship-to information from the sales order or blanket sales order. 

We have tried populating the ship-to on the order with all three options (default (Sell-to address), Alternative Shipping Address and Custom Address), but still get no data on the report itself.

Has anyone else encountered a similar issue? 

Any advice we could receive would be greatly appreciated.

Thanks,

Dominic

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    150 on at

    It’ll be data related. The order confirmation report has a Boolean called ShowShippingAddr. On the RDLC report that will control if the data is visible or not. Expect your missing some data that it believes is necessary. Note this check can be bypassed with a modification. I’d start by checking over the sell to country as that is the usual data missing that causes this one

    This function is run as part of the report:

    procedure SalesHeaderShipTo(var AddrArray: array[8] of Text[100]; CustAddr: array[8] of Text[100]; var SalesHeader: Record "Sales Header") Result: Boolean

       var

           CountryRegion: Record "Country/Region";

           SellToCountry: Code[50];

           Handled: Boolean;

       begin

           OnBeforeSalesHeaderShipTo(AddrArray, CustAddr, SalesHeader, Handled, Result);

           if Handled then

               exit(Result);

           with SalesHeader do begin

               FormatAddr(

                 AddrArray, "Ship-to Name", "Ship-to Name 2", "Ship-to Contact", "Ship-to Address", "Ship-to Address 2",

                 "Ship-to City", "Ship-to Post Code", "Ship-to County", "Ship-to Country/Region Code");

               if CountryRegion.Get("Sell-to Country/Region Code") then

                   SellToCountry := CountryRegion.Name;

               if "Sell-to Customer No." <> "Bill-to Customer No." then

                   exit(true);

               for i := 1 to ArrayLen(AddrArray) do

                   if (AddrArray[i] <> CustAddr[i]) and (AddrArray[i] <> '') and (AddrArray[i] <> SellToCountry) then

                       exit(true);

           end;

           exit(false);

       end;

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,170 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,283 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,104 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans