Help with this expression

Redwan Omer 1 Reputation point
2022-10-06T18:51:31.42+00:00

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

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-10-07T06:06:25.737+00:00

    Hi @Redwan Omer ,
    I'm not familiar with expressions in crystal reports, please tell me what the report design in your SSRS looks like, and what value you need to get from the expression. Please attach screenshots and description for more help.
    Best Regards,
    Joy

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.