SQL Server Performance Forum – Threads Archive

Charts in SQL Reporting Services

Hi, Can any one help me ASAP? I am working on line chart/graph in SQL Reporting Services. My graph is taking one parameter that is Srnumber. This Srnumber is a drop down box. In the graph on the Y-axis values are different for each and every srnumber. 1st Question:- Suppose when I select ‘D5949’ as Srnumber from drop down box then on Y-axis the interval should be 0, 700, 1400, 2100 and so on. Suppose when I select ‘E0183’ as Srnumber from drop down box then on Y-axis the interval should be 0, 10, 20, 30 and so on. Suppose when I select ‘D8916’ as Srnumber from drop down box then on Y-axis the interval should be 0, 9, 18, 27,39 and so on.
2nd Question:- For the same graph on X-axis I am displaying date.
The interval between dates are different for each and every Srnumber Suppose when select ‘D5949’ as Srnumber from the drop down box then the dates should be like the following 05-25-2007
05-27-2007
05-29-2007 and so on. here interval is 2 If I select ‘E0183’ as Srnumber from drop dwon box then the dates sholud be like the following. 05-25-2007
05-28-2007
05-30-2007 and so on. here interval is 3 Thanks,
Swetha

---

I don’t think you can get dynamic X or Y axis in Reporting services. SSRS, selects X and Y axis depending on the data available —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

]]>