Solved

SQL: SSRS Building Bar Graph

Posted on 2011-03-02
7
768 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
  • 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

762 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now