Link to another report on point labels in Pie Chart

Hello. I am new to SQL Server Reporting Services. The short explanation of what I want to do: In a pie chart, I have turned on point labels. I want each of the point labels to be a link. When you click on the link, you are taken to another report (in table format) that is more information about the data in that wedge of the pie.
If that is unclear, maybe it will help if I explain what I'm trying to do. The pie chart is a chart showing the status of developer issues in an issue tracking database. (Open, In-Progress, Awaiting Verification, Closed, Rejected, etc.) Each wedge of the pie has a point label that shows the number of issues that fall into the category (8 issues opened, 12 issues IP, etc.) When I click on the label that shows the number, I want to be taken to a table that shows what the issues in that category are.
Is this possible with SQL Server Reporting Services? Thanks in advance.Yes. Check out Chart Properties Dialog -> Values -> Edit -> Edit Chart Value
dialog box -> Action tab. You can choose Jump To Report option here and
specify the target report. You can also pass parameters to the target report
from this location.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Justin30519" <Justin30519@.discussions.microsoft.com> wrote in message
news:BC5B49B6-2B72-4D9C-A4B0-0CA3356E8114@.microsoft.com...
> Hello. I am new to SQL Server Reporting Services. The short explanation of
what I want to do: In a pie chart, I have turned on point labels. I want
each of the point labels to be a link. When you click on the link, you are
taken to another report (in table format) that is more information about the
data in that wedge of the pie.
> If that is unclear, maybe it will help if I explain what I'm trying to do.
The pie chart is a chart showing the status of developer issues in an issue
tracking database. (Open, In-Progress, Awaiting Verification, Closed,
Rejected, etc.) Each wedge of the pie has a point label that shows the
number of issues that fall into the category (8 issues opened, 12 issues IP,
etc.) When I click on the label that shows the number, I want to be taken to
a table that shows what the issues in that category are.
> Is this possible with SQL Server Reporting Services? Thanks in advance.|||Thank you very much for your reply. It was very helpful. My report works now.
Justin

Line Chart X-Axis has too many point

Hi All,
I have a Chart line report that works great except when there are too many
data points. The x-axis labels then get too cramped and become unreadable.
I saw from another post that to fix this, you right mouse click on the chart
object, select properties, select "X Axis" tab, set "Major tick mark" to
"None" and "Minor tick mark" to "None". So I have "Major tick mark" set to
"None" and "Minor tick mark" set to "None" and also set on my "X Axis" tab
is: Checkbox "Show labels" is "Checked" and "Scale Minimum" = 0 (nothing
else is specified). However, this is not solving the problem (i.e. the
x-axis labels are still cramped together and unreadable).
I called Dundas Software and their tech support department said they cannot
provide technical support to me since I am using the Chart control packaged
with SQL Reporting Svsc 2005.
Can anyone offer any advice on how I can solve this?
Thanks in advance.Hello,
Since SQL Server 2005 has not been publicly released yet, we do not support
SQL Server 2005 in the newsgroup. For any SQL Server 2005 and related
issues, you could post here
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us
Thank you for your patience and cooperation.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Sorry, typo...I am on SQL Reporting Svcs 2000.
"Anthony LaMark" <anthony@.eXcSoftware.com> wrote in message
news:%23xWn$y%23tFHA.3252@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a Chart line report that works great except when there are too many
> data points. The x-axis labels then get too cramped and become
> unreadable. I saw from another post that to fix this, you right mouse
> click on the chart object, select properties, select "X Axis" tab, set
> "Major tick mark" to "None" and "Minor tick mark" to "None". So I have
> "Major tick mark" set to "None" and "Minor tick mark" set to "None" and
> also set on my "X Axis" tab is: Checkbox "Show labels" is "Checked" and
> "Scale Minimum" = 0 (nothing else is specified). However, this is not
> solving the problem (i.e. the x-axis labels are still cramped together and
> unreadable).
> I called Dundas Software and their tech support department said they
> cannot provide technical support to me since I am using the Chart control
> packaged with SQL Reporting Svsc 2005.
> Can anyone offer any advice on how I can solve this?
> Thanks in advance.
>|||Hello,
Please reproduce this issue with the sample AdventureWorks2000 database,
then post here the detailed steps to reproduce the issue. Send the report
to me so I can check the issue on my side. My email address is
v-sguo@.microsoft.com. After checking it I will let you know the results.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||It sounds like your are NOT using a timescale/numeric x-axis. You can solve
the issue with too many labels on the x-axis by setting the x-axis MINOR
interval value to e.g. 5 (i.e. one label per 5 categories / data samples).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Anthony LaMark" <anthony@.eXcSoftware.com> wrote in message
news:eTarYvGuFHA.3500@.TK2MSFTNGP09.phx.gbl...
> Sorry, typo...I am on SQL Reporting Svcs 2000.
> "Anthony LaMark" <anthony@.eXcSoftware.com> wrote in message
> news:%23xWn$y%23tFHA.3252@.TK2MSFTNGP10.phx.gbl...
>> Hi All,
>> I have a Chart line report that works great except when there are too
>> many data points. The x-axis labels then get too cramped and become
>> unreadable. I saw from another post that to fix this, you right mouse
>> click on the chart object, select properties, select "X Axis" tab, set
>> "Major tick mark" to "None" and "Minor tick mark" to "None". So I have
>> "Major tick mark" set to "None" and "Minor tick mark" set to "None" and
>> also set on my "X Axis" tab is: Checkbox "Show labels" is "Checked" and
>> "Scale Minimum" = 0 (nothing else is specified). However, this is not
>> solving the problem (i.e. the x-axis labels are still cramped together
>> and unreadable).
>> I called Dundas Software and their tech support department said they
>> cannot provide technical support to me since I am using the Chart control
>> packaged with SQL Reporting Svsc 2005.
>> Can anyone offer any advice on how I can solve this?
>> Thanks in advance.
>