Nav 2009 SP1 Report Designer

paramb

Hi All,

I have a question from Nav 2009 SP1 Reports. I am yet to work on new reports except for minor fixes. Now that I have a minor code change required.

I wanted to add Vendor card 'Our Account No.' field to the Purchase Return Order Report. The same field has been already added(Customized) to the 'Purchase Order' Report in the database done by some one else . My first approach in these cases to figure out how it has been done in the already modified objects and reviewed the object in detail. On Review, I have found that a new text box is placed in the Layout(Visual Studio) and this field is getting the value from Code.GetData(18,4). On further review I found that Menu Report-->Report Properties Window Have a tab named 'Code' and I can see the function GetData, but could not see or understand how GetData function is returning Vendor Account No. from vendor table. I have also noticed a function SetData in that function also I cannot see how Vendor Account No. is retrieved from the Vendor table.

I know I will have to master the new report designer eventually, but running short of time at this moment. I would really appreciate if some one can point me to a direction where I should look to see the Getdata function and SetData function gets and returns data from database.

Looking ahead to a reply.

clausl

I suggest you read my blog post here. The first part I explain our beloved Code.GetData and Code.SetData functions work.

http://mibuso.com/blogs/clausl/2012/10/03/simplifying-document-reports-in-nav-2013/

I also explain how to create nice reports without complicating your reports with Code.GetData and Code.SetData.

/Claus Lundstrøm

paramb

Thanks. I will keep you posted.

paramb

Hi,

I have reviewed the blog and some other blog. I did not get an idea on how Setdata and GetData functions accessing Nav table data. What does the 2 parameters mean.

I really appreciate if some one can provide me a direction. My requirement is very simple, i just need a Vendor Card filed added to the Purchase Return Order report.

Also, Please let me know how can I get the manual 80146B from Partnersource. I have access to the Partnersource.

clausl

Write me a private message with contact details, then I give you a quick training course. 2 hours from now I'm available.

/Claus Lundstrøm

paramb

Thanks. I have sent a message.

paramb

Atlast I got it done now. I have done it with the help of Report Designer PDF(I Guess the right way).

Special Thanks to Claus Lundstrøm.

clausl

Perfect :-)