Link to home
Start Free TrialLog in
Avatar of nicecats
nicecatsFlag for United Kingdom of Great Britain and Northern Ireland

asked on

How do I count the number of series in the Series Group in a SQL Server Reporting Services Chart

HI All,

I have a simple question on SQL Server 2005 Reporting Services, I have a chart that has a Series Group in it that is linked to a department hierarchy. What I am doing is setting the action in the values in the chart to jump back to the same report with the value of the department I clicked on the report as parameter hence progressing down the hierarchy, this works fine but when I get to the lowest level department in the tree I need to count the number of series, which should now be one, to branch off to another report, how do I do this.

Many Thanks in Advance.
ASKER CERTIFIED SOLUTION
Avatar of nicecats
nicecats
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial