SetData() GetData ()— Round 2.0

This is a follow-up post to the original post about SSRS setting-getting data, since when I inquired the Dynamics NAV forums, and I received answers where I am no longer required to use SetData() — GerData().
I mean this is impressive stuff!

Original blog post: https://medium.com/nareshwar-r/setdata-getdata-on-ssrs-reporting-on-dynamics-nav-121ac46cde6#.vsj0hix0h

Question on the forum: https://community.dynamics.com/nav/f/34/p/188794/476167#476167

There will be few steps and then you do not ever require SetData()-GetData().

Add a textbox to the body section

• Set Property Hidden to True
• Set Value/Expr. to Fields!No_SalesInvHdr.Value
• Set Name = RepItemSalesInvHeaderNo

Add a textbox to the header

• Set expression to = ReportItems!RepItemSalesInvHeaderNo.Value

One more trick

• Go to advanced properties, set RepeatOnNewPage property to True.
• Set KeepWithGroup property to After.

That’s it. Also, I have attached a few screenshots of the method to ease your development.

The hidden TextBox on the Body of the report

Hidden property of the second line which you have created.

Advanced Property of the header of the Tablix. Check out the KeepWithGroup and RepeatOnNewPage properties.

Applying the same property to the row you just created.

The blog ends here, but do shoot any questions/clarifications if you have.

Special thanks to Franz Kalchmair (Alias: Jonathan Archer), one of the senior members of Dynamics NAV official forum helped me to understand the trick. The method is proposed and implemented by Franz, and I did the testing from my end.

Check out his LinkedIn:

Dipl.Ing. Franz Kalchmair | LinkedIn

Additionally here is the place he literally lives :D

archer's Profile - Microsoft Dynamics Community