Forum Discussion

RedTdot's avatar
RedTdot
Frequent Visitor
3 years ago
Solved

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 ' ('&tote...
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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.