Wednesday, February 1, 2017

Reporting Tablix inside a Tablix in RDLC Report MS Dynamics NAV?


Upgrading reports of 2009 Classic Client to 2016 RDLC Client.

I came across a situation where I have to create a logic that after one body in a Group I need Another Body in the same tablix.We can perform the same using this Trick.

Step 1. Merge all the cells in which you want to insert the Tablix.


Impact of Integer Table in MS Dynamcs NAV?


Once I had not put a Filter and used the Integer Table in XMLPORT.

You can check it here.

When I ran this XMLPORT and tried to export the file via this XMLPORT, System goes in loop iteration and after sometime it completely started to hang the system and at last I had to restart the System. I was very lucky that the issue has been resolved at the testing end only.
So how to resolve this error Put a Filter for this Integer Table like this, before using Integer Table anywhere in loop of Navision.

Data at the root level is invalid. Line 1, position 1 MS Dynamics NAV


How I resolve this error? 
Data at the root level is invalid. Line 1, position 1. 




The solution I followed is at :

Dynamics User Link

Step 1 :

You have to remove this property in Navision XMLPORT. For this Goto new line in XMLPORT and open Properties.


Step 2 :

Change format property to Variable text.


I hope this will resolve your problem Like mine.