<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I have got a stored procedure which has got the Service Area, Percent Completed and Month End columns. <br />
<br />
The percent column in stored procedure contains something like (60,70,80) etc but the report is adding an extra zero in vertical axes. I am using <b>0'%';(0'%') </b> to show the percent sign.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827284/TimeCard.JPG" target="_blank" title="SSRS Displays an extra zero (42 KB)"><img alt="SSRS Displays an extra zero" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827284/TimeCard.JPG" /></a><br />
Regards,
</div>
</div>


TimeCard.JPG

Hi guys,

I have got a stored procedure which has got the Service Area, Percent Completed and Month End columns. 

The percent column in stored procedure contains something like (60,70,80) etc but the report is adding an extra zero in vertical axes. I am using 0'%';(0'%')  to show the percent sign.



Regards,

SSRS Adding Extra Zero (0) in Vertical Axis

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.