Solved

SQL: SSRS Building Bar Graph

Posted on 2011-03-02
7
784 Views
Last Modified: 2012-05-11
I tried to take a snapshot of the bar graph I have. I tried to delete the last names of the AEs, but you can still see the allignment issue between the Name of the Sales Rep and the actual bar.

How can I fix this allignment issue?
1.bmp
0
Comment
Question by:InfoTechEE
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 10

Expert Comment

by:itcouple
ID: 35020319
Hi

Are you using 2008 or 2008 R2? (Try clicking the section in design view and see if you can fidn alignment property, try grouping properties by category (button at the top of the properties pane) and see if there is anything under appearance or similar.

I would normally go with a table and a databar (r2 feature). With 2008 I would still do the same but embed small line graph in a cell and remove formatting.

Just a suggestion.... from data visualization point of view I would remove the bar white "slashes" and tried to keep font colours the same.... it is usually much easier to read the data if it is presented in clean and consistent manner.

Here are some SSRS samples if you are interested.
http://www.itcouple.com/ssrs-reports-examples.aspx

and a little bit of data visualization
http://www.itcouple.com/data-visualization.aspx

p.s. Sorry for sending you more info then you wanted.... but thought you might maybe find it useful.

Hope that helps
Emil
0
 

Author Comment

by:InfoTechEE
ID: 35020475
We do have 2008 R2.

I grouped properties by category, and found an alignment property of the "Account Executive" axis textbox. It had a property called VerticalAlign, but no matter how I would change that, it would not affect the needed allignment.

I'm not sure what you mean by table and databar. I think the graph I chose is the bar graph, and below it, I do have a table with the results as well.

Thanks for all the userful feedback, I appreciate it.
0
 

Author Comment

by:InfoTechEE
ID: 35020602
Nevermind...the server is 2008 R2, but the SQL is a standard 2008.
0
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 

Author Comment

by:InfoTechEE
ID: 35020664
Can you elaborate more on this: With 2008 I would still do the same but embed small line graph in a cell and remove formatting.

0
 

Author Comment

by:InfoTechEE
ID: 35020792
Not sure if this is what you meant by doing in 2008 version, but I decided to use a bar graph. It looks almost like a data bar, except the lenths are not correctly matching the numbers. Any way around this?

For associated image please see http:#a35038946
* thermoduric - EE Moderator
0
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
ID: 35021862
Hi

Yes. You can set maximum on the mini chart using expression for chart max value =MAX(Fields!ValueField.Value,"datasetname")

Regards
Emil
0
 

Author Comment

by:InfoTechEE
ID: 35038946
Replacement image for comment http:#a35020792
1.bmp
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question