I'm using WebServiceDataSource to connect with database through odata. In database there is InventoryDocDetail table which has Product property referenced to Product table.
I'm connecting to InventoryDocDetail and printing the product's Sku property on my report. The problem here is InventoryDocDetail.Product may be null. In this case, I just want to print nothing. Currently it gives null reference exception error(See attached Error.JPG file).
I saw many forums, but no one helped me. For example, I wrote like this expression in textbox: = iif(Fields.Product is null, "this is null", Fields.Product.Sku), but it still showing error when product is null.
1. How can we solve the issue?
2. Can we use C# expression here like this: "= Fields.Product?.Sku" ?