how to create nested (+working!) functions
Hello out there (and sorry for my bad english)!
I need a bit help with FR.NET, cause i just startted to use this tool (but some skills in crystal reports basic are available) [img]style_emoticons/<#EMO_DIR#>/wink.gif" style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" /> Now my problem: I have a field [ReportDataCraft.SMeasure]. This field contains strings like "20 Stk.", "50 m", "100 l", ..., but sometimes this field is empty Now I only want to display the strings containing "Stk." at the end. Unfortunately i not found a function to extract elements from the entire string. [RIGHT([ReportDataCraft.SMeasure],4)] to extract the last 4 letters of the string did not work[/img][img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" />. So i tried [IIf((Length([ReportDataCraft.SMeasure]))==0;"";[IIf((Remove([ReportDataCraft.SMeasure],1,(Length([ReportDataCraft.SMeasure]))-4))="Stk."),[ReportDataCraft.SMeasure],"")))] But i only get errors if i switch to preview. May someone help me to fix that. And to prevent those questions in the future: Can anyone tell me a good website where i can read more about the syntax for the queries in fast reports? Regards eggat[/img]
I need a bit help with FR.NET, cause i just startted to use this tool (but some skills in crystal reports basic are available) [img]style_emoticons/<#EMO_DIR#>/wink.gif" style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" /> Now my problem: I have a field [ReportDataCraft.SMeasure]. This field contains strings like "20 Stk.", "50 m", "100 l", ..., but sometimes this field is empty Now I only want to display the strings containing "Stk." at the end. Unfortunately i not found a function to extract elements from the entire string. [RIGHT([ReportDataCraft.SMeasure],4)] to extract the last 4 letters of the string did not work[/img][img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" />. So i tried [IIf((Length([ReportDataCraft.SMeasure]))==0;"";[IIf((Remove([ReportDataCraft.SMeasure],1,(Length([ReportDataCraft.SMeasure]))-4))="Stk."),[ReportDataCraft.SMeasure],"")))] But i only get errors if i switch to preview. May someone help me to fix that. And to prevent those questions in the future: Can anyone tell me a good website where i can read more about the syntax for the queries in fast reports? Regards eggat[/img]