<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">Hi everybody </span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial"> </span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">I need to implement a multilanguage solution for a report compiled in Crystal Eclipse. To this end I created a new table with columns for KEY, LANGUAGE and TRANSLATION. Since I am new to reporting I don't understand how to implement the equivalent of the following SQL statement, preferably in a formula:</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">SELECT<span> </span>`TRANSLATION` FROM `CR_LABELS` WHERE `LANG`='de' AND `KEY`='someText'</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">I tried to solve the problem with the following formula:</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">someText</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">if({?Language}={CR_LABELS.LANG} and {CR_LABELS.KEY}='someText') then</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial"><span> </span>{CR_LABELS.TRANSLATION}</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">of course this is unusable as long as I don't either suppress the<span> </span>empty rows (don't know if this is possible for a string value) or - more efficently - let the formula terminate after finden a value.</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">Is there a standard solution to multilanguage support? I am really curious to learn how the rest of the world handels internationalization in this day and age of globalisation.</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">Your help is highly appreciated....</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">Regards</span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial">Peter for Zurich, Switzerland </span></p>