Display number as percentage in a textbox

Question

User-1210839387 posted

using VS.Net 2005

I am returning a number from a stored proc (Numerator/denom) and I would like to display this in a textbox as a percentage.  Is there a property to do this or do I just convert this number to a decimal?

thanks

MC

Answer 1

User1732514203 posted

I believe you can do this in .Net 2.0.

textBox1.Text = number.ToString("p");

Hope this helps,
Stuart 

Answer 2

User-1210839387 posted

thanks for feedback.

I'm converting the report in VS.net using a report project but then uploading using SSRS report admin page so I'm not really doing any processing using the VS.Net C# or VB.net, so I'm looking to do this in the report itself

Answer 3

User1732514203 posted

Sorry, didn't realise this was in the SSRS forum.

I haven't got access to SSRS at the machine I'm on but can you not right-click your textbox > properties > number and then set the format here?

EDIT:

Like this (ignoring the bit about negative numbers)

http://www.bidn.com/blogs/kylewalker/ssis/796/additional-formatting-to-percentages-in-ssrs

Answer 4

User-1210839387 posted

what i'm doing now:

right click textbox and go to properties

click on format tab and elipses

under standard choose percentage

but when I do this I am getting an error:

<ERROR>

the properties for this currently selected item are not valid.  Please correct all errors before continuing.

</ERROR>

what errors does that refer to and how do I found out what they are?

thanks

MC

Answer 5

User-1528094326 posted

What version of SQL Server or RDL are we taking here? 2005? 2008 or 2010?

Is the data in the textbox an expression or is it just pulling from a specified dataset? What type of data is it? A string or is it an actual number or integer data type?

Answer 6

User-8475372 posted

Dear User, 

Yes, this can be done at the report level itself. All you need to do is  (Num/Den) & "%"  in your expression of that textbox.

Appending % symbol.