Crystal 9. Missing report data.

[SundancerKid]

When I run a report against a database some of the information is skipped if one of the fields is Null. How can I fix this problem??

When I take the same data and run it though a newley created report everything prints out correctly.

Please help.

Thanks,

Rick P.

 

[SundancerKid]

I found it. There was a problem with my select statement. I was using a * to select all. But it was not pulling in the Blank/Null records. I Changed the select statment to use an if then statment for selection. Works Great now.