My app is pushing a dataset to a crystal report. In the dataset are first, middle and last names. In other uses of Crystal Reports I've just created a Formula that concantinates all these together into one field and then I put that formula in place of the three previous fields.

I'm just learning CR with .Net and when I do this, the Formula field does not always show up. In fact it only gets displayes in about 30% of the records. Is there any setting I have to make to force it to always be calculated and displayed?

Any suggestions?

Thanks,
Bernie

Answering my own question for anyone who may read this in the future with a similar problem. CR does not respond well to Null fields. VB will concantinate "Test" & Null to be "Test", CR concantinates these as a null and therefore a blank on the report. Make sure to use the isNull function on all data that you are going to concantinate together first before adding them together.

Bernie