Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL: SSRS Building Bar Graph

Posted on 2011-03-02
7
Medium Priority
?
788 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
Technology Partners: 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!

 

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

963 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