Forum Discussion
SSRS Report
THIS IS THAT IS USED IN CRYSTAL REPORT AND I WANT TO USE IT IN SSRS EXRESSION OR PAGINATED REPORT
{Allotment_Details.DIST_TYPE} &
(if isnull ({Allotment_Details.ALLOT_PCT}) then '' else
' ('&totext({Allotment_Details.ALLOT_PCT},2)&'%)')
LOOKING TO CONVERTED TO SSRS EXPRESSION
Hi RedTdot
Users in Power BI community may have no experience in CRYSTAL REPORT, so they may have difficulty understanding what this formula does. Can you use some examples to explain what you want to get?
If I understand it correctly, perhaps you can try
=Fields!DIST_TYPE.Value & IIF(IsNothing(Fields!ALLOT_PCT.Value),"","("&Format(Fields!ALLOT_PCT.Value, "F2")&"%)")
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
1 Reply
Hi RedTdot
Users in Power BI community may have no experience in CRYSTAL REPORT, so they may have difficulty understanding what this formula does. Can you use some examples to explain what you want to get?
If I understand it correctly, perhaps you can try
=Fields!DIST_TYPE.Value & IIF(IsNothing(Fields!ALLOT_PCT.Value),"","("&Format(Fields!ALLOT_PCT.Value, "F2")&"%)")
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.