Hi all.

This must look real lame but I just cannot figure out the Crystal Reports syntax. No problem at all doing this in standard SQL, but CR really baffles me.

Here's the deal

We have a shipping document, where I need to add a sum of the weights of certain hazardous goods.

The MS SQL-server does have these fields

document.NETWEIGHT,document.HAZARDCODE

I just want to have a sum of the document.NETWEIGHT where the document.HAZARDCODE is not null / empty. Or sum where there's something in the .HAZARDCODE will do just as well.

I've tried this, I've tried a lot of other things, but no joy.
Sum ({document.NETWEIGHT},{document.HAZARDCODE}, not "")

So how do I get CR to sum only those weights, and leave the non-hazardous weights out?

Cheers, Jukka

Thanks, got it working now. Sure saved me a lot of headache. I could have had it made by our CRM-provider, but working with their support is such a pain that I avoid it as far as I possibly can.

Jukka