Report Upgrade from 2009 R2 to 2013 BETA error

Troubles_In_Paradise

Hi guys,

Today I tried the to upgrade a quite simple report from NAV 2009 R2 to NAV 2013.
The report structure is:

Customer (printonlyifdetail = yes)
-Sales Invoice Header
--Sales Invoice Line
-Sales Cr.Memo Header
--Sales Cr.Memo Line

The aim is to print all the customers that have at least a Cr.Memo or an Invoice with all the documents.
The report is designed in this way:
1 list grouped on Customer.No field that contains 2 tables. the first table has a group based on "Sales Invoice Header".No field.
For the second table it's the same but the group is based on the "Sales Cr.Memo Header".No Field.

This report works like a charm in NAV 2009 R2.
Now it's time for upgrade...
1. I export the object as .fob
2. Import the object in NAV 2013 Standard DB (localized Italy)
3. Selecting my report I press Tools>Upgrade Reports
I run report in NAV 2013 RTC and it seems to work. My problem is that if I try to see which are the group properties on List and Tables craeted in the VS2010 layout I receive an error (always the same):

_______________________________
Microsoft Report Designer
_______________________________
Undocumented Error.
Details:
Object reference not set to an instance of an object.

Does anyone of you know what I'm doing wrong?
Thank you very much.

clausl

I have seen a similar error a couple of times, and it seems to be related to the way I'm doing filters on the tables. But I have not nailed this one yet as I don't seem to get the error consistenly.

But maybe you could share your report.rdlc and dataset.xml as I described here:
http://mibuso.com/blogs/clausl/2012/06/24/offline-preview-and-debug-reports-in-microsoft-dynamics-nav-2013/
Then I could have a look at it.

/Claus Lundstrøm

Troubles_In_Paradise

clausl wrote:

I have seen a similar error a couple of times, and it seems to be related to the way I'm doing filters on the tables. But I have not nailed this one yet as I don't seem to get the error consistenly.

But maybe you could share your report.rdlc and dataset.xml as I described here:
http://mibuso.com/blogs/clausl/2012/06/24/offline-preview-and-debug-reports-in-microsoft-dynamics-nav-2013/
Then I could have a look at it.

/Claus Lundstrøm

Hi Claus, I also think it's related to filters.
Anyway I'm going to send you a PM with files you asked me.
I had to change extension to Report file from .rdlc to .txt because I wasn't able to attach it to a PM.
I continue to investigate the reason of this issue.
Thank you for the help.

Troubles_In_Paradise

I found it!!!!!!!!!!
As you said Claus, the problem is due to filters.
Developing NAV 2009 R2 report I was able to set filters on groups, tables and list with the following syntax:

Fields!MyField.Value > " "         or        Fields!MyField.Value > ""

If you upgrade a report with filters set as above it will work; but you aren't able to see Tablix properties because the error mentioned in this topic will appear.
What I did to avoid this error is to use the follwoing syntax:

Cstr(Fields!MyField.Value) > " " or       Cstr(Fields!MyField.Value) > ""

Thank you Claus for helping me.

clausl

Perfect that you nailed this one.
This is absolutely something we need to pay attention to when upgrading reports from NAV 2009.

/Claus Lundstrøm