Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Setdata and Getdata in...
Microsoft Dynamics NAV (Archived)

Setdata and Getdata in report NAV 2013

(0) ShareShare
ReportReport
Posted on by snoppy 4,818

When I open the layout of the Cronus Database for NAV 2013, I see a lot of <<Expr>> all over, and it gets worse when opening one of these expression, because the values are just Code.GetData and a number. It is hard to understand and see which field is which in the layout.  And I have also read the 80433 Manual and it mentions there will be no more getdata and setdata function. So do I have to create a new report from scratch? If not, is there anyway to convert getdata to a value which can easily be seen from the layout. Your advice is greatly apprecaiated. Thank you!

*This post is locked for comments

  • Damogran Profile Picture
    Damogran 360 on at
    RE: Setdata and Getdata in report NAV 2013

    I know your pain, Snoppy.

    Here's what I did to find out what getdata should i use:

    First find out where is the hidden field that has the setdata expression, then copy its expression to clipboard.

    Open Excel (or notepad++, or Programmers Notepad whatever can tell you line numbers), and paste the expression there.

    Then just note the row number for quick reference.

    Unfortunately I have been unable to find any way to see the source within Visual Studio so far, so this is the only possibility.

    And, if you decide to redo the report from scratch, please read ClausL's excellent blog about sacking GetData and SetData altogether:

    mibuso.com/.../simplifying-document-reports-in-nav-2013

    Regards, urpok

  • snoppy Profile Picture
    snoppy 4,818 on at
    RE: Setdata and Getdata in report NAV 2013

    Thank you for your experts' reply! I read the post per as below from this  link mibuso.com/.../simplifying-document-reports-in-nav-2013

    in textbox in body so we actually know what “=Code.GetData(20,1)” will evaluate to when executing the report. So let’s start counting 1,2.3,4….20, found it. I feel like being in first grade again when I sit here and count lines :-(. Well maybe just me. When reaching line 20, I realize that “=Code.GetData(20,1)” has this value “Cstr(Fields!PaymentTermsDesc.Value)”

    Which line? Where do I start to count?  Thank you

  • Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,965 Super User 2024 Season 2 on at
    RE: Setdata and Getdata in report NAV 2013

    Hi Snoppy,

    The Location of SetData in NAV 2013 have been changed. Please go through saurav-nav.blogspot.com/.../nav-2013-report-header-doesnt-get.html.

    I hope this will help. 

    Let me know if any issues.

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Setdata and Getdata in report NAV 2013

    Hi,

    you can upgrade a report from 2009 to 2013 to maintain setdata\getdata functions as is if you like.

    Search & read Claus Lundstrøm posts (the inventor of sql reporting services subset & rdlc technology for NAV 2009, 2013..);

    Here a very nice link about report 206 redesigning technology and other tips

    mibuso.com/.../simplifying-document-reports-in-nav-2013

    Others posts here

    mibuso.com/.../reporting

    community.dynamics.com/.../how-to-define-setdata-and-getdata-in-rtc-reports-in-dynamics-nav-navision.aspx

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