Re: concatenating a % in reporting services
- From: amish <shahamishm@xxxxxxxxx>
- Date: Wed, 17 Jun 2009 07:28:05 -0700 (PDT)
On Jun 17, 4:08 pm, Mike P <mike.p...@xxxxxxxxx> wrote:
I have a column in my SSRS report that I want to add a '%' to. It seems
to work fine for where the percentage is less than 100. But for some
reason, when the percentage is greater than 100 I get some weird
results.
For example, there is a row where the percentage is 26/20, so this
should display as 130%. It calculates as 130 when I don't concatenate
the %, but when I add the %, I get a result of 1313000%.
The expression I am using is =Fields!FieldName.Value & "%". Can anybody
help?
*** Sent via Developersdexhttp://www.developersdex.com***
On the text box just pass value =26/20
Right click on box select properties
select Format tab
click ... button for format code , select percentage as format.
Amish Shah
http://shahamishm.blogspot.com
.
- References:
- concatenating a % in reporting services
- From: Mike P
- concatenating a % in reporting services
- Prev by Date: Re: Alter table command vs table copy/rename
- Next by Date: Re: Alter table command vs table copy/rename
- Previous by thread: Re: concatenating a % in reporting services
- Next by thread: Re: concatenating a % in reporting services
- Index(es):
