SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
rockstar283
rockstar283
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1014 Visits: 669
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
debrucer1
debrucer1
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2392 Visits: 136
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.

Thanks,

David Russell
Oracle Since 1982
SQL Server Since 1998
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)

Group: General Forum Members
Points: 380335 Visits: 42968
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
debrucer1
debrucer1
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2392 Visits: 136
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.

Thanks,

David Russell
Oracle Since 1982
SQL Server Since 1998
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)

Group: General Forum Members
Points: 380335 Visits: 42968
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
rockstar283
rockstar283
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1014 Visits: 669
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 Sad 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 Sad
rockstar283
rockstar283
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1014 Visits: 669
OK..Problem solved..solution was converting the data to Integer BigGrin

silly me..Thanks a lot guys Smile
mike.gibson-1007997
mike.gibson-1007997
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 35
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
rockstar283
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1014 Visits: 669
I converted the data to be displayed into integer..that solved my problem:-)
abigail.tomlins
abigail.tomlins
SSC Journeyman
SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)

Group: General Forum Members
Points: 77 Visits: 44
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search