[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2014-10-15
3
Medium Priority
?
692 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
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…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
Suggested Courses

607 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