Announcements
No record found.
Hi, im trying to convert the value of a field to be shown in my ssrs report in %, anyone can provide me the full expression.
THANKS
Hi Mounir, I didn't tested it but you can try ssrs expression specified in this article
stevethompsonmvp.wordpress.com/.../
Hi, i checked but the pictures are not opening, maybe if u can help, my expresion in the report design in coming like this: =Fields!Ex_LineDiscAmount.Value
i need to change this expression to convert to %. is that possible u provide me with the correct exp using my scenario?
thanks
Hi Mounir,
Refer to the below link and see if it helps.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c90223e1-96a6-475b-891a-8046bda596dc/ssrs-format-with-percent-sign?forum=sqlreportingservices
Thanks,
Girish S.
Try the below code in the field expression in report and change Format property to P for that field.
= FORMAT(Fields!Ex_LineDiscAmount.Value, "F2") & "%"
hi, i tried this method: .
but when i print report im getting 380000.00% while decimal value is 3800.
As per article, if you use F2, it will show 3800 instead of 38000. You can also try adding 2 in Decimal places instead of 0.
Try setting decimal place as 2 in the same property window.
a sales order has a unit price value of 20 000 with 1 quantity in the sales order line. we did a line discount amount for 2000 which means 10% if you we need to convert it to percentage. then, we did another line discount but this time the line discount percent for 10%. this line discount percent will be deducted from the value resulted by the deduction of the line discount amount from the unit price. after we did the line discount amount for the unit price 20 000, the item has value now of 18 000. then, we do the line discount percent of 10%, the amount value is now 16 200. if we convert it all to amount, the value deducted from the sales item is 3800 which equals to 19%. so the line discount amount is converted to 10% and the line discount percent of 10% is actually 9%, so a total of line discount percent after conversion is 19%
Right, in that case, you need to divide LineDisc (3800) with Unit Price and multiply with 100 to get the percentage. (3800/20000) * 100 = 19%.
You can apply same formula in LineDisc Textbox in report.
yes i did it, but the value is coming 1900% not 19% while decimal place is 0
here is my exp: =((Fields!Ex_LineDiscAmount.Value/(Fields!Qty.Value*Fields!SalesPrice.Value)))*100
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 797
André Arnaud de Cal... 610 Super User 2026 Season 1
Subra 534
