NAV 2013 Report Layout - Hiding Rows

jreynolds

I recently upgraded some of my NAV 2009 reports to NAV 2013 and was confused by what happened to the Hidden property for table rows. Report 705 (Item Availability) is a good example. This report has a run-time option to use Stockkeeping Units. The layout in Visual Studio has a Table with several rows. Some of the rows are hidden depending on whether or not stockkeeping units are to be used. So in NAV 2009 the Hidden property for the table row has references to the Fields!UseStockkeepingUnit.Value. This is all fine and good. However, in NAV 2013 the layout now contains a Tablix and if you find the corresponding rows of the Tablix you will find that the Hidden property is not set. It turns out that there is a Tablix Member that corresponds to rows and groups and that is where you will find the Hidden property for the rows (here we find the references to Fields!UseStockkeepingUnit.Value).

So my question is what is the benefit of using the Hidden property on the Tablix Member vs. the Hidden property on the Tablix Row? And how do these work together? I find that working with the Tablix Member is more difficult because there is no visual indication of which row in the Tablix corresponds to which Tablix Member (or perhaps this is possible in Visual Studio and I just don’t know how to do it).

Excepti0nal

I totally agree. The GetCode(12,1) stuff is really annoying. Find the hidden field and view the source expression. That will show you all of the fields. Copy all of them, then open VS and paste them into a new document. Turn on line numbers, then you can find what all of the fields are referencing in the layout.