Number Conversion in SSRS
<p>I have a requirement where I convert an ID (decimal example, 536879311820 )  and display in SSRS table after conversion using expression builder as shown in the figure.<a href="https://i.stack.imgur.com/Qlqyj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Qlqyj.png" alt="enter image description here"></a></p>

<p>The rule for conversion is like this:</p>

<ul>
<li>Convert the number to Hexadecimal and take right 8 digits
(536879311820 to 00802BCC)</li>
<li>Convert the taken 8 digits to decimal and take right 5 digit
(00802BCC to 8399820)</li>
</ul>

<p>So 536879311820 should be displayed in report as 99820.  I tried up to the following expression in the expression builder, </p>

<pre><code>=Right(HEX(Fields!PersonId.Value), 8)
</code></pre>

<p>Since the result of this expression is hexadecimal number as string, I can't find any function in common functions category in expression builder.</p>