Setdata and Getdata in report NAV 2013

(0) Share

Report

Posted on by snoppy

4,824

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
snoppy 4,824 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Damogran 360 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Community site session details

Setdata and Getdata in report NAV 2013

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates

Community site session details

Setdata and Getdata in report NAV 2013

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates