Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 315

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

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Custom Layout Reports Bill To fields

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Custom Layout Reports Bill To fields

    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
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: Custom Layout Reports Bill To fields

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans