Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Add New Chart Area

Author  Topic 

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2008-10-24 : 06:12:27
Is it possible to Add New Chart Area in Reporting Services 2005 similar to:
http://msdn.microsoft.com/en-us/library/cc627527.aspx

I have results for Year 1 and Year 2. At the moment 2 different charts being created.
I've done this by adding the Year into "Series Groups" and put day_field into Expression and Year into Parent Group.
So I have 2 different charts - one for the each year, each chart has 5 lines for Mon, Tues, Wed, Thurs, Fri.

I'd like the a single chart with an upper and lower section for each year so the values can be more easily viewed.
The finished report will have a lot of charts so this would group them together better for comparison between years.

I've tried:
"Right-click anywhere on the chart and select Add New Chart Area"
as link says, but I can not see this option.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-24 : 07:07:20
Seems like you dont have this feature until sql 2008.We had a similar requirement previuosly and had to use third party control for adding more than one chart area.
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2008-10-24 : 07:35:08
Pity. Is it possible to get a similar look with-out add-ins?
Do you know is it possible to group the charts by series group. At the minute I have 3 charts each showing twice for the 2 years.
At the moment order is:
Year1 chart1, Year1 chart2, Year1, chart3, Year2 chart1, Year2 chart2, Year2, chart3
I would like:
Year1 chart1, Year2 chart1, Year1, chart2, Year2 chart2, Year1 chart3, Year2, chart3
Go to Top of Page
   

- Advertisement -