SYMPTOMS
Printing a report in NAV 2009 RTC creates only a blank page
EXAMPLE
- 1. Create a new Customer in your database with an alphanumeric customer number. (this is very important!)
- 2. Example Customer D-0001 Name etc.
- 3. Create a new order for this customer and change the Ship to address. (This causes that both addresses will be printed on the sales shipment document.)
- 4. Create an order line and choose Post – Shipment
- 5. Print the Shipment (Preview or Print)
ERROR
You will get a blank report page
CAUSE
In the layout of Report 208 Sales – Shipment there is a table using the following expression in the visibility property.
=IIF(Fields!Sales_Shipment_Header___Bill_to_Customer_No__.Value,False,True)
This expression returns always False as long the Bill to Customer No. is numeric. If you using an alphanumeric value it returns an (not visible runtime-) error. The report execution will stop, but you will get no error message.
Attention: This means, in every RDLC Report in NAV 2009, if you are using an expression which will cause a run time error, you will get no output but rather a blank page.
RESOLUTION
Resolution for Report 208 is to modify the visibility property expression in the report so that it is valid. For Example:
=IIF(Fields!Sales_Shipment_Header___Bill_to_Customer_No__.Value<>Fields!Sales_Shipment_Header___Sell_to_Customer_No__.Value,False,True)
Take care using expressions in properties!