using a reportitem.parent in an IIF function

[Joe]

Here is my expression...

= IIF(ReportItem.Parent.DataObject.SoldtoAddress.CustKey = "ADEEL", "M3","") + Fields.RollID

As-is, the expression works. But, if the expression is false and I put anything in the empty quotes, the report won't run and gives the error, "Object reference not set to an instance of an object."

Am I doing something wrong? Thanks!

[Plamen Mitrev]

Hello Joe,

I am sorry to hear about this unexpected behavior with the expression you are using. I tried to reproduce it on my end in the Standalone designer, by using columns of different type (string or integer) in all combinations. All of my tests produced expected result and I did not have any errors.

=IIF(ReportItem.Parent.DataObject.A="Apple","It was an apple", "5") + Fields.int

There might be something specific to the report or data, that I am missing, and I will be happy to investigate it further. Please prepare a sample report that reproduces the issue and attach it to this thread.

I am looking forward to hearing from you and continue this discussion.

Regards,
Plamen Mitrev
Progress Telerik