<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Reporting Services
»
Reporting Services
»
SSRS Chart issue..Bars dont show up but data...
SSRS Chart issue..Bars dont show up but data does
Rate Topic
Display Mode
Topic Options
Author
Message
rockstar283
rockstar283
Posted Friday, May 11, 2012 1:32 PM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, May 20, 2013 12:30 PM
Points: 84,
Visits: 385
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
Post #1298927
debrucer1
debrucer1
Posted Saturday, May 12, 2012 8:46 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, February 20, 2013 2:23 PM
Points: 254,
Visits: 131
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
Post #1299198
Jeff Moden
Jeff Moden
Posted Sunday, May 13, 2012 10:31 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:51 PM
Points: 32,910,
Visits: 26,800
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1299271
debrucer1
debrucer1
Posted Sunday, May 13, 2012 10:46 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, February 20, 2013 2:23 PM
Points: 254,
Visits: 131
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
Post #1299275
Jeff Moden
Jeff Moden
Posted Sunday, May 13, 2012 1:01 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:51 PM
Points: 32,910,
Visits: 26,800
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1299285
rockstar283
rockstar283
Posted Monday, May 14, 2012 12:54 PM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, May 20, 2013 12:30 PM
Points: 84,
Visits: 385
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
Post #1299811
rockstar283
rockstar283
Posted Monday, May 14, 2012 5:17 PM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, May 20, 2013 12:30 PM
Points: 84,
Visits: 385
OK..Problem solved..solution was converting the data to Integer :D
silly me..Thanks a lot guys :)
Post #1299951
mike.gibson-1007997
mike.gibson-1007997
Posted Tuesday, September 11, 2012 10:40 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, April 12, 2013 6:48 AM
Points: 1,
Visits: 32
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....
Post #1357580
rockstar283
rockstar283
Posted Tuesday, September 11, 2012 12:10 PM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, May 20, 2013 12:30 PM
Points: 84,
Visits: 385
I converted the data to be displayed into integer..that solved my problem
Post #1357623
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
