B1.2 Create a report in NAV 2009 using the external assembly

Try to remember once again: The goal is to create a new report using the external assembly.

  • 1. Open Microsoft Dynamics NAV 2009 Classic with SQL Option and connect to you database
  • 2. Select Tools – Object Designer
  • 3. Select Reports
  • 4. Select New

clip_image002

  • 5. Create a blank report
  • 6. For the data item we will use the user table to get a list of the NAV user.
  • 7. Move you cursor to the next empty line the data item designer and select the properties.
  • 8. Modify the EnableExternalAssemblies property to yes. This is very important because of security risks by default it is not allowed using external assemblies in reports.

clip_image004

  • 9. Moving on to the Section Designer
  • 10. Insert a User Header and a User Body
  • 11. Insert the USER ID field with the field menu

clip_image005

If you like you can also insert a caption for the report and/or company name and page number etc.

At this point we will move into Visual Studio

  • 12. Close the Section Designer
  • 13. Select Tools – Create Layout Suggestion

clip_image007

Now we will setup the external assembly for using in this report.

  • 14. Go to Report – Report Properties
  • 15. Move on to the References tab
  • 16. Select the appropriate Assembly using the button on the right side.

clip_image009

  • 17. Close the report properties using the OK button and return to the designer
  • 18. Insert a second row next to the user id by using the right mouse button.

clip_image010

We will now change the expression of the second textbox calling the assembly

For calling the assembly we have to call the Code region – function(variable) name – name of function in the assembly

  • 19. Enter =Code.myfunction.GetPassword in the expression of the textbox

clip_image011

That’s it. Now it’s time to save, compile and start the report.

  • 20. Click save in Visual Studio
  • 21. Close Visual Studio and return to NAV classic.
  • 22. Confirm the appropriate question about update the RDLC in NAV by using the Yes button
  • 23. Save and compile the report in NAV
  • 24. Start the report

clip_image012

Attention: If you have no output or a blank page in your preview, please check if you have a database user in your company because this example is based on database user list…(or use another table ;-)

Using External Assemblies in NAV 2009 reporting Part II

Using External Assemblies in NAV 2009 reporting Part I

Training- NAV 2009 Reporting mit RDLC Advanced