Solved

SSRS STACKED BAR CHART shows zero at begining and end of each bar

Posted on 2014-10-15
3
486 Views
Last Modified: 2014-10-28
I have SSRS 2008 r2 Report built using report builder. My data source is sharepoint list.
I created a stacked bar chart to show employees status between specific time period. I have "assigned to" multi valued parameter. Start and end date filters. Report shows data correctly but adds a zero at the beginning and end of the each bar. Attched screen shots and rdl file for your reference .Please guide me how to fix the issue. Any help will be appreciated.
stackedbarchart-error.png
HelpCentreStatusReport-prod---Copy.rdl
0
Comment
Question by:asrithap
  • 2
3 Comments
 
LVL 3

Expert Comment

by:prequel_server
ID: 40383587
aren't those zeros just the data labels for your chart?

you're using a stacked bar of three series Assigned, Closed, Onhold

Randal has 0 Assigned and 0 Onhold so the zeros show
and Elliot has 1 Onhold.

-you can change the position of your data labels or change your visualization all together.

what would you like to see for the cases where someone only has one type of status? eg. Randal
0
 

Accepted Solution

by:
asrithap earned 0 total points
ID: 40399728
I wrote series expression to fix this.
=IIF(Count(Fields!Assigned_To.Value)=0,"",Count(Fields!Assigned_To.Value))
0
 

Author Closing Comment

by:asrithap
ID: 40407971
i found the expression to fix the issue
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

815 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

8 Experts available now in Live!

Get 1:1 Help Now