?
Solved

Dynamically Move Chart Legend in SSSRS

Posted on 2010-11-19
4
Medium Priority
?
370 Views
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?  
thanks!
0
Comment
Question by:badrhino
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 4

Expert Comment

by:BostonMA
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.
0
 
LVL 1

Author Comment

by:badrhino
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.  
0
 
LVL 4

Accepted Solution

by:
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.
0
 
LVL 1

Author Comment

by:badrhino
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.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying 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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month11 days, 3 hours left to enroll

770 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