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.
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
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")
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.
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