Remove the "*" in SSRS report Design...
Many Time we need to convert the amount in to the words but in this case we got the value with some *** . to remove these *** from the value we can use below expression.
=Replace(Left(First(Fields!Field.value , "DatasetName"),Len(Fields!AmountInWords.Value)-10),"*","") + "Only"
we can use the same logic in any value.
Many Time we need to convert the amount in to the words but in this case we got the value with some *** . to remove these *** from the value we can use below expression.
=Replace(Left(First(Fields!Field.value , "DatasetName"),Len(Fields!AmountInWords.Value)-10),"*","") + "Only"
we can use the same logic in any value.
No comments:
Post a Comment