Solved

SSRS Adding Extra Zero (0) in Vertical Axis

Posted on 2014-01-09
1
400 Views
Last Modified: 2014-01-09
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.

SSRS Displays an extra zero
Regards,
0
Comment
Question by:shah36
1 Comment
 

Accepted Solution

by:
shah36 earned 0 total points
ID: 39767667
Thanks for looking into it. Actually i noticed that my stored procedure was returning the repeating rows and the the value field in the series was Sum(Pcomp) i changed it to Max(Pcomp) and it works fine now.

regards
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now