DB Null's DplxWebForm

Skip Navigation LinksHome  /  Support  /  Forums  /  DynamicPDF ReportWriter for .NET (v5.x)  /  Display Thread

DynamicPDF ReportWriter for .NET (v5.x) Forum

 Jul 01 2010 12:18 PM
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
 Jul 01 2010 1:23 PM
Posted by a ceTe Software moderator
Hello Dave,

You should be able to display the fields having null values without any problem. Please try using the latest build of our product. You can get the latest build from our CustomerArea by logging in using your current serial number. If you are still having a problem then please send over the dplx file and the code you are using to our Support Team so that they can look into it further.

Thanks,
ceTe Software Support Team.
 Jul 01 2010 1:34 PM
Hi

Thanks for the quick response. Looks like it was down to "_" (underscores) in my table column names. I've added alises for each column in the SELECT and got it working.

Cheers

Dave

All times are US Eastern Standard time. The time now is 3:03 PM.