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

Dynamically Move Chart Legend in SSSRS

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?  
thanks!
0
badrhino
Asked:
badrhino
  • 2
  • 2
1 Solution
 
BostonMACommented:
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.
0
 
badrhinoAuthor Commented:
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.  
0
 
BostonMACommented:
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.
0
 
badrhinoAuthor Commented:
This may give me something to work with--If not for this project perhaps for others in the future.  Thanks for the response.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

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