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 data
this is the data
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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?
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?
Premium Content
You need an Expert Office subscription to comment.Start Free Trial