How to chain Text with field from database in Expressions.
Hello
my Memo looks liek that
this works well, however i need to Add Text in that expression and no matter what iam doing it doesnt work so far, i tried "+" and variants of known operators as well.
In Pseudocode it should look like that:
Result should be: 14 Tage 2% Skonto
EDIT: Got it!
u CAN make strings in the iif expression, BUT ONLY if u dont mix them up with Integer values.
Otherwise you have to use FormatFloat ....
my Memo looks liek that
[IIF (<frxDBDataset1."S1TAGE">=0,'',iif(<frxDBDataset1."S1TAGE">>=1,<frxDBDataset1."S1TAGE">,'FALSE'))]
this works well, however i need to Add Text in that expression and no matter what iam doing it doesnt work so far, i tried "+" and variants of known operators as well.
In Pseudocode it should look like that:
[IIF (<frxDBDataset1."S1TAGE">=0,'',iif(<frxDBDataset1."S1TAGE">>=1,<frxDBDataset1."S1TAGE">+'Tage'+<frxDBDataset1."S1Skonto"+'%'+'Skonto'>,'FALSE'))]
Result should be: 14 Tage 2% Skonto
EDIT: Got it!
[iif (<frxDBDataset1."S1TAGE">=0,'',FormatFloat('0',<frxDBDataset1."S1TAGE">)+' Tage '+FormatFloat('#,##0.00',<frxDBDataset1."S1PROZENT">)+' %')]
u CAN make strings in the iif expression, BUT ONLY if u dont mix them up with Integer values.
Otherwise you have to use FormatFloat ....