Solved: SSRS Report

RedTdot · ‎10-06-2022

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

v-jingzhang · ‎10-07-2022

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.

View solution in original post

v-jingzhang · ‎10-07-2022

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.