Chart URL Action? Easy question ... I hope!

I am trying to create a chart action to do a URL drill into bar chart. But I
can not figure out how to get the name of the clicked bar.
Example: If the diagram below were a chart, when I click on the "two" bar, I
want to create the url: http://www.bonzo.com/foo.aspx&PICKEDBAR=Two
One == Two ==== Three ========
Is it possible to do this?Your Jump to navigate action you can use the RS global collections. Assuming
that One, Two, etc. are category groups, you can use Fields!<your database
field>.Value
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"billd" <billd@.discussions.microsoft.com> wrote in message
news:43521AC0-1DE9-4980-B579-16F0DF651586@.microsoft.com...
> I am trying to create a chart action to do a URL drill into bar chart. But
I
> can not figure out how to get the name of the clicked bar.
> Example: If the diagram below were a chart, when I click on the "two" bar,
I
> want to create the url: http://www.bonzo.com/foo.aspx&PICKEDBAR=Two
> One ==> Two ====> Three ========> Is it possible to do this?|||Thanks ... excactly the answer I needed.
You are the MVP.
"Teo Lachev [MVP]" wrote:
> Your Jump to navigate action you can use the RS global collections. Assuming
> that One, Two, etc. are category groups, you can use Fields!<your database
> field>.Value
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "billd" <billd@.discussions.microsoft.com> wrote in message
> news:43521AC0-1DE9-4980-B579-16F0DF651586@.microsoft.com...
> > I am trying to create a chart action to do a URL drill into bar chart. But
> I
> > can not figure out how to get the name of the clicked bar.
> >
> > Example: If the diagram below were a chart, when I click on the "two" bar,
> I
> > want to create the url: http://www.bonzo.com/foo.aspx&PICKEDBAR=Two
> >
> > One ==> > Two ====> > Three ========> >
> > Is it possible to do this?
>
>

Chart Drill Through?

Is it possible to build a report that displays a chart and if a particular
bar or slice of the chart is clicked we can present the details for the data
associated with the Bar or SLice of the chart?Yes it can be done. After creating the charts go to the properties and then
data tab and then values and then edit individual values you can see the
"action" there you can give the link or jump to report.
Amarnath
"Steven H" wrote:
> Is it possible to build a report that displays a chart and if a particular
> bar or slice of the chart is clicked we can present the details for the data
> associated with the Bar or SLice of the chart?
>
>

Chart Drill Through Bug?

I have a peculiar problem with a line chart that has a "jump to report"
action. The chart basically shows sales by month, with two different
lines for 2004 and 2005. When a user clicks on a specific month, it
jumps to a detailed report for that month. This works beautifully
except for one problem:
The first month is the starting point of the line graph, call it
December. Clicking on the line anywhere between December and January
jumps to the January detail report. In a way, I guess this sort of
makes sense because otherwise I guess you wouldn't be able to drill to
the last month on the graph. What I'd really like to be able to is not
make the "line" interactive at all. I'd rather define the drill
through in the point label itself. So that when you click on the point
label for December, then you go to the december report.
Does anyone know of way to do that? Maybe by directly defining it in
the rdl?Did you look into using datapoint "markers"? They can help to improve line
charts to make the drillthrough links more obvious (especially if the
markers are bigger than the line width).
The described behavior (the line is also interactive) is inherent to design
of the chart control and cannot be changed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"jordo" <jordan_mccall@.hotmail.com> wrote in message
news:1107300323.493686.4760@.z14g2000cwz.googlegroups.com...
> I have a peculiar problem with a line chart that has a "jump to report"
> action. The chart basically shows sales by month, with two different
> lines for 2004 and 2005. When a user clicks on a specific month, it
> jumps to a detailed report for that month. This works beautifully
> except for one problem:
> The first month is the starting point of the line graph, call it
> December. Clicking on the line anywhere between December and January
> jumps to the January detail report. In a way, I guess this sort of
> makes sense because otherwise I guess you wouldn't be able to drill to
> the last month on the graph. What I'd really like to be able to is not
> make the "line" interactive at all. I'd rather define the drill
> through in the point label itself. So that when you click on the point
> label for December, then you go to the december report.
> Does anyone know of way to do that? Maybe by directly defining it in
> the rdl?
>|||Brilliant! This works quite well. Thank you for your help!