not all items from the dataset are being shown are the bar chart

I have a bar chart with 11 items in the dataset but only 6 of them are being shown on the barchart.  Why?

this is the barchart
this is the data

Capture.JPG
vbnetcoderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nico BontenbalCommented:
That's strange. Did you create that report yourself, or are you updating the report of someone else?
There are a few reasons I can think of.
1. The query you use to test does not use the same database and/or logon as the report
2. There is a filter on the Dataset in the report
3. There is a filter on the Chart (looks like a pie to me, not a bar)

When you add new table to the report based on the same dataset. Are all the records shown in the table. If not it's probably 1. or 2.
If all the records are shown in the table you can create a new chart based on the same recordset. That chart should show all the items and then you know it must be one of the properties of the chart.
Can you upload the report here so we can see if we can reproduce the problem?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vbnetcoderAuthor Commented:
I had done a copy and paste from a pie chart i used with a different report and then changed the dataset. The reason i did this was because the needed to look exactly the same.  Juts for a test i started with a new chart and it worked correctly.  Thanks for your suggestions.
0
vbnetcoderAuthor Commented:
ty
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.