Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL: SSRS Building Bar Graph

Posted on 2011-03-02
7
Medium Priority
?
785 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

704 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