Convert to Percentage
I have just produced a percentage calculation in TSQL and want to view the results in SSRS 2005 as a percentage Raw Results 0.0554542 0.058371 0.121307 0.049364 0.109037 0.165925 I want the results to be shown like this below... is this possible? 5.55% 5.84% 12.13% 4.94% 10.90% 16.59%
October 5th, 2010 12:02pm

Follow these steps 1. Right click on the tablix or matrix column 2. Select the textbox properties 3. Select Number 4. In the format to be used select "Percentage". These value will be converted into the required format automatcially.
Free Windows Admin Tool Kit Click here and download it now
October 5th, 2010 12:09pm

Hello, Use this format =Format(Fields!ColumnName.Value,"P") Hope its helpful....Pavan Kokkula Infosys Technologies Limited.
October 5th, 2010 12:10pm

neither of them work
Free Windows Admin Tool Kit Click here and download it now
October 5th, 2010 12:29pm

Whats the output after applying the format, could you provide more information....Pavan Kokkula Infosys Technologies Limited.
October 5th, 2010 1:15pm

Then it looks like , the data you are having is text. Convert the data to Float and then apply the format on top of it. For my solution , use the below expression first in the column and then apply the format =CDbl(Fields!Columnname.Value) For Pavan's Solution , Use the below expression itself =Format(CDBL(Fields!ColumnName.Value),"P")
Free Windows Admin Tool Kit Click here and download it now
October 5th, 2010 1:31pm

Hi Sam, Click the cell of that data, and locate its Format property in the Properties window, type "P2" (without the double quotation mark), which will format the data as you want. See http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx for more information about Standard Numeric Format Strings in reporting services. thanks, Jerry
October 7th, 2010 4:15am

Hi Sam, Another simple alternative could be to multiply the result with 100 and append "%" to the resultset at the dataset level itself. This seems to me as simple solution for your problem. Regards, Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2010 6:14am

This can also be achived in the SSRS report itself. Write the expression for that cell to do the calculation and append % to the expression. Ex : ((Fields!Columnname1.Value/Fields!Columnname2.Value) * 100) & "%"Dinesh Behera If this post answers your question, please mark it as an Answer.
October 7th, 2010 6:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics