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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Custom Layout Reports ...
Microsoft Dynamics NAV (Archived)

Custom Layout Reports Bill To fields

(0) ShareShare
ReportReport
Posted on by addision1 323

I need to alter the "BillTo" address fields on the Invoice report 10074. I need to stop the report from showing the "Contact" and the "Country" fields as part of the billing information.

Now, using the RDLC in sql report builder I do not know where I can see that specific report dataset field that is selected for these report fields.  As an example:

In the Dataset it Lists:         The Report Layout it Shows  The "name" of the Field in the properties pane is
BillToAddress3 <<Expr>> BillToAddress31

If I look at the expression for the Report Layout field it shows the following expression:

=Code.GetData(14, 1)

Now. it appears as if these fields are dynamic and not static, in that if there is a null field then it will populate that field with the next portion of the "bill to" information. So if there is no customer address2 then it will not leave a blank space.

So how do I handle this. would I change some code or should I remove these fields and formulas, then add back in the static fields?  

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at

    Hi Addision,

    In Microsoft Dynamics NAV, to make things simple there are several codeunit that are made universal for most of the output being generated. One of those universal aspect is the Header detail(Address).

    In Standard NAV, All the Address related queries are passed to "Codeunit: 365 Format Address" where as you pointed these values are dynamic, in fact Arrays are being used to handle these values.

    You can manage some of the values with the help of VB programming but in order to do complex adjustments you will have to study this codeunit and try to specify your own function to handle the values for specific customization.

  • Community Member Profile Picture
    Community Member on at

    Most of the Standard NAV document reports using the GetData SetData VB functions in order to manage the dynamic header details. So you could find the SetData parameter defenition from the visibility property of a text box named 'HeaderCompanyAddressInfo' in group header of the parent group in 10074 report.

    And I agree with Rabindra on printing out the address details. It is Navision Standard on document reports.NAV introduced the a code unit 'Format address' to manage it. So in order to handle your requirement you should modify either that code unit. Since the same code unit used on many other standard NAV reports, better to handle your customization separately without affecting other related objects.

    if you remove those fields and formulas, would make the report more complex and you need more workarounds on it. Or I think may be you can use the static fields on the setdata parameter I mention earlier and use them by replacing the current array values on dataset.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    You need to check the Format Address codeunit or check in programming if these fields are programmed to get values for tables.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans