Hi
I've trying to create a PDF invoice from an SQL database using a ASP.NET web application.
I've copied the Invoice example and have problems with the Freight value! It is mostly set to NULL within our database and I get an IndexOutOfRange exception when the field is returned. Delete the field in the designer, save the file and it works!
I've tried using the following to stop the NULL
IIF(IsNull(FreightAmount),"Test1","Test2")
But it still has the same issue.
Cheers
Dave