First(Value) Method vs Set/Get Method in 2015/2016 VS Report builder

(0) Share

Report

Posted on by Community Member

I've noticed that you can use the First(Value) in the header instead of the slow and tedious method to set and get data. Is there any disadvantages to using the First(Value) in your reports' header?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (1)

Report

Well, if you print multiple documents at the same time then it always prints the value from the first document if you use First Method.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Would there be a way to avoid this. I've noticed that you can write something after selecting a value? It's a real time saver if it was possible to make it select the first value of the current page instead of the first value of all pages together?

Was this reply helpful? Yes No
Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

Hi ZipZip,

I have written a blog article regarding this. Can you give me your thoughts on SetData() and GetData()?

Link to my blog article: https://goo.gl/VKyV1V

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (1)

Report

Using First(Fields!DocNo.Value) works, if you print one record.

For printing a couple of records: add a textbox to the body section, set property hidden to true, set value/expr. to =Fields!DocNo.Value, set name=RepItemDocNo, add a textbox to the header, set expression to =ReportItems!RepItemDocNo.Value. save, retry.

with that you do not need get/setdata. get/setdata can be used, but reduces the performance.

additional follow https://community.dynamics.com/nav/f/34/p/188794/477130#477130

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thank you for the insight Nareshwar. SetData and GetData is also the last option in my case. It's very time consuming, and to be honest a poor choice of programming in my oppinion. Unfortunately it's also the only choice you have, if you wish to use, dynamic values. I've been able to cut down on the SetData and GetData by using first, on static values, like Captions, but I was hoping to avoid it.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Interesting. Thank you for this. Unfortunately I'm not able to sacrifice performance for practicality.

Was this reply helpful? Yes No
Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

Hi Jonathan,

Valuable tip. Will try out :)

Was this reply helpful? Yes No