Crystal reports - missing fields?

OK I am not sure I understand the full extent of your problem but let's start with the Country and Company name and see if I can get you moving forward. Instead of putting the Country field directly on the report you could use a formula field and do something like this: IF {@BookingRef} = "001" Then "UK" Else IF {@BookingRef} = "002" Then "Germany" Else "Unnamed" Now you just put the formula field where the country field used to be and it will put the right country in bases on the BookingRef code. This, however, is only practical if you are working with a small number of Country / Company Names or possibly a big list that never changes although I would caution against the latter.

The other thing you could do is create a table in any database that holds the BookingRef, Company and Country values, link the BookingRef fields from both "databases" and then just drop the fields on your report. If I am missing the point of your question please be real specific about what it is you are trying to accomplish and what is and is not working in your current solution.

Thanks..ended up writing report without country and immediatly left for a long holiday! That solution wouldn't work because it assumes booking are from unique countries and also the talking about no less tahn 200 counries to code:) – cKK Jun 7 at 7:57.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.