• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 791
  • Last Modified:

SQL: SSRS Building Bar Graph

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
InfoTechEE
Asked:
InfoTechEE
  • 5
  • 2
1 Solution
 
itcoupleCommented:
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
 
InfoTechEEAuthor Commented:
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
 
InfoTechEEAuthor Commented:
Nevermind...the server is 2008 R2, but the SQL is a standard 2008.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
InfoTechEEAuthor Commented:
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
 
InfoTechEEAuthor Commented:
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
 
itcoupleCommented:
Hi

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

Regards
Emil
0
 
InfoTechEEAuthor Commented:
Replacement image for comment http:#a35020792
1.bmp
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now