Last week I did another RDCL Report Training class, this time in UK. In this class we stumbled over an issue, I had never seen before, while we where implementing Transfooter and Transheader functionality in a report. You might never encounter this issue, but to save you the headache I got solving this issue, here is the solution or bug you might call it.
You might remember the Transfooter and Transheader solution I blogged about a few years ago here: http://blogs.msdn.com/b/nav/archive/2011/06/06/transfooter-and-transheader-functionality-in-rdlc-ssrs-reports-revisited.aspx. This solution also works perfectly in NAV 2013 and Visual Studio 2010. I have upgraded the report to NAV 2013 and made some layout changes to it. You can download the new version here from my SkyDrive: http://sdrv.ms/191AC0g.
But back to the problem. While we were adding Transfooter and Transheader functionality to the report, we also played around with the LeftIndent property on the textbox that feeds information to Transfooter Text box in the Page Footer. In the above demo report this would be Text Box “Customer__Debit_Amount_”.
When i.e. setting the LeftIndent property to 5pt to this specific Text box, we suddenly got and error in the Transfooter Text Box:
Why that is, I have no clue, but I have stopped using LeftIndent, since I no longer trust that property.
If you have an idea why the Transfooter Text box gives an error when using LeftIndent, I would love to hear. If not I will just park this as yet another bug in Visual Studio.