Dynamically Move Chart Legend in SSSRS

Posted on 2010-11-19
Medium Priority
Last Modified: 2012-05-10
I am building a report in SQL Reporting Services that has a line chart in it.  Currently, I have the legend in the chart area (upper-left corner) where it is out of the way most of the time, but occasionaly covers some of the lines.  Is there a way that I can move the legend dynamically if it covers up the lines in the line chart?  
Question by:badrhino
  • 2
  • 2

Expert Comment

ID: 34175041
I would probably create a copy of the Chart and have one version with the legend in one spot, and the other with the legend in a different spot.  Then put one chart exactly over the other chart and add a parameter to toggle the visibility of the one you want.  Thats the easiest solution.

Author Comment

ID: 34175363
Thanks for your reply.  Your suggestion won't workin this case because I've got this report set up on a subscription and the report is generated and then exported to a file share as an image were people access this via simple html tags.  

Accepted Solution

BostonMA earned 2000 total points
ID: 34175395
Then there is no way to accomplish exactly what you are asking.  

If you want the chart to look reasonable and complete this task so you can move on you need to set a trigger point so that the report knows when to put the legend on the bottom or on the right. If you notice that whenever the count of sales > 100 that the legend looks best on the bottom, then you could set the visibility to toggle the chart with the legend on the bottom only when sales are greater than 100.

Author Comment

ID: 34175461
This may give me something to work with--If not for this project perhaps for others in the future.  Thanks for the response.

Featured Post

Get your problem seen by more experts

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

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

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…
Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…
Suggested Courses

621 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