SSRS Chart issue..Bars dont show up but data does

Question

SSRS Chart issue..Bars dont show up but data does

rockstar283

SSCrazy

Points: 2704
More actions
May 11, 2012 at 1:32 pm

#392244

I have created a column chart in which the data is showing up properly on the x and y axis but, the actual bars dont show up..any idea what the cause might be?? Thanks in advance

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

debrucer1 SSCertifiable Points: 5366 More actions · Answer 1

sounds flaky. clear the cache and try again. you also might try a different browser (before and after clearing the cache there). If not displaying, restart all the SQL services, and if still not showing, restart the server.

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 2

BWAAA-HAAAA!!!! If you have to restart the services and/or the server just to get the bars of a chart to show up, then there's a serious flaw in SSRS! 😉 I'd like to recommend that you try to at least find out what the problem might be before resorting to such tactics.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

debrucer1 SSCertifiable Points: 5366 More actions · Answer 3

it was my experience two weeks ago, when Report Server was only displaying down to the orange/blue line, no admin controls, no menus. Restarting the services corrected the first problem. The DB had been stepped on, and a restore was required; but, nothing below the line was visible until the services were restarted. SSRS certainly is not the best product, and it is Microsoft. Not restarting, in most circumstances, is foolish.

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 4

debrucer1 (5/13/2012)
it was my experience two weeks ago, when Report Server was only displaying down to the orange/blue line, no admin controls, no menus. Restarting the services corrected the first problem. The DB had been stepped on, and a restore was required; but, nothing below the line was visible until the services were restarted. SSRS certainly is not the best product, and it is Microsoft. Not restarting, in most circumstances, is foolish.

What do you mean by "the DB had been stepped on"? And not finding the root cause before restarting is usually more foolish especially when the goal is 24/7 on certain servers.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

rockstar283 SSCrazy Points: 2704 More actions · Answer 5

Thank you so much for the reply guys..

As many of you suggested..I restarted the services..then rebooted the computer..but still nothing worked..

I changed the values of x and y axis, but that didnt work either.

The problem is..

In this report, I have a chart and a table..Table contains the values and chart shows the graph of how the values changed over the time..so the table is showing the correct values..and chart's xa dn y axis are showing correct values..but the only problem is the bars are not appearing 🙁 which is very weired..

Edit..Its a simple column chart..not a bar chart..sorry for the confusion and I am also using a line chart and facing the same problem with it as well..

I have a similar report and it is showing all the values and columns/lines correctly..

Here is a screenshot of the report in designer mode..

When I preview this report..the columns dont show up..neither the data lables 🙁

rockstar283 SSCrazy Points: 2704 More actions · Answer 6

OK..Problem solved..solution was converting the data to Integer 😀

silly me..Thanks a lot guys 🙂

mike.gibson-1007997 SSC Rookie Points: 37 More actions · Answer 7

I am having the same issue, where some of the data does not render in the chart, but it is ok in a table. Can you explain a bit more about your solution? Did you change all of the series output into integer? or did you change the grouping to integer? Any help is greatly appreciated.

--// EDIT

I figured out the issue that I was having. I was overlooking a warning of aggregate function trying to sum multiple data types. I then found this article that helped me visualize the issue:

http://blogs.msdn.com/b/sql_pfe_blog/archive/2009/07/10/sum-of-a-sql-analysis-services-calculated-measure-within-a-reporting-services-report-gives-error.aspx

So, I updated my series value with =SUM(CDBL(xx.xx.value)) and all is well in the world....

rockstar283 SSCrazy Points: 2704 More actions · Answer 8

I converted the data to be displayed into integer..that solved my problem:-)

abigail.tomlins SSC Enthusiast Points: 199 More actions · Answer 9

Forgive me if this is a simple problem to solve, I am having the same issue, please can you tell me how to change so the data into an integer? My chart is looking at views (so I think it is already looking at integers) but it's not working so I'm going to try changing it. Any help is much appreciated!

Thanks

Abbie

CPiacente SSC Eights! Points: 863 More actions · Answer 10

CPiacente

SSC Eights!

Points: 863

April 12, 2018 at 1:49 pm

#1986676

Post Deleted

sgmunson SSC Guru Points: 110640 More actions · Answer 11

CPiacente - Thursday, April 12, 2018 1:49 PM

Heck, even your POST didn't show up.... :hehe::hehe::hehe:

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

CPiacente SSC Eights! Points: 863 More actions · Answer 12

hahah I think I tried to delete it and posted it elsewhere and it wouldn't delete from here

sgmunson SSC Guru Points: 110640 More actions · Answer 13

CPiacente - Friday, April 20, 2018 12:07 PM
hahah I think I tried to delete it and posted it elsewhere and it wouldn't delete from here

Yeah, you can't delete a post, but you can Edit it, and then just say EDIT: Post deleted.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

cp.selvi Newbie Points: 1 More actions · Answer 14

I've tried with all the suggested changes. But none helped me out. Finally, I just adjusted the vertical axis range on the column chart by disabling the Always Include Zero option from vertical axis property as below. The minimum value should not be changed from Auto.

This will display the range from negative to positive instead of starting in from 0. After doing this I able to view the bars for lesser values in PDF.

Capture