Question about displaying strings

[rahavtom]

Hello!

 

I'm using VB.NET 2003 and Crystal Reports and I have a problem / question with displaying strings in a win report.

I have a win report based on mdb database file. I want to print an address string for example, so I created a formula filed that contains:

 

trim({cities.cityName}) & ' ' & trim({personalDetails.street}) & ' ' & trim({personalDetails.house})

 

When I print the report, it displays the address correctly only if all 3 fields are filled in the database, but if just one of them is empty, nothing will be displayed!

Can someone tell me why is this and why it doesn't work as it should, meaning displaying the city and house only if street doesn't exist and so on ... ??

 

Thanks!

Tom Rahav.

[jayceepoo]

Not too sure what the problem could be since I don't use Crystal Reports, buy my guess is that you are trying to concatenate to something that is a NULL value. If that is the case, you can change your query to replace NULL values with an empty string, and that should work...