Hello,
To enable the tooltip drill down, in the chart tooltip properties I've added
iframe src=tooltip.aspx?ROW=DATA_ROW&COL=DATA_COLUMN
and my tooltip.aspx page_load is something like this where value1, value2, and value 3 are session variables I obtain from the parent page and GetData is the function which has the database connectivity and SP information.
Dim ROW As Integer
Dim COL As Integer
If Not Page.Request("ROW") Is Nothing Then
ROW = CInt(Page.Request("ROW"))
End If
If Not Page.Request("COL") Is Nothing Then
COL = CInt(Page.Request("COL"))
If periodvalue Is Nothing Or facvalue Is Nothing Or provvalue Is Nothing Then
Dim dt1 As DataTable = GetData("Stored_Proc", 4, 0, 0, 0, 901, 0, 0, 0)
Me.chtTest.Data.DataSource = dt1
Me.chtTest.Data.DataBind()
Else
Dim dt As DataTable = GetData("Stored_Proc", 4, value1, value2, 0, value3, 0, 0, 0)
Me.chtTest.Data.DataSource = dt
My question for you is, the chart on tooltip is now currently showing the same data as on the parent chart. To drill down, I need to show the tooltip chart so that it displays the data below the parent chart. I am not sure how to capture that value and pass it to the SP. Row and Col bring back the row and column on the SP, but the Stored procs do not accept those params. Please advice.
Thanks
You can try using WebChart Client-Side Events:
http://help.infragistics.com/Help/NetAdvantage/NET/2008.3/CLR3.5/html/WebChart_Client_Side_Events_CSOM.html
I have a similar Question. I have a chart that is data by month. How can I identify what month value is being hovered over?
In the sample in our help:
Me.UltraChart1.DataSource = GetBarData() Me.UltraChart1.DataBind()
Me
In GetBarData() function you need to get new data based on ROW and COL, that you are getting with:
Dim ROW As Integer Dim COL As Integer If Not Page.Request("ROW") Is Nothing Then ROW = CInt(Page.Request("ROW")) End If If Not Page.Request("COL") Is Nothing Then COL = CInt(Page.Request("COL")) End If
As Integer
Dim
If Not
Is Nothing Then
CInt
I'm not sure what in your data, but this can be something like:
Dim dt1 As DataTable = GetData("Stored_Proc", 4, ROW, COL, 0, 901, 0, 0, 0)
Thank you for the reply.
I understand that, but as you can see, I am already using the same code as that in the link. The issue is, the tooltip chart is showing me the same data as the parent chart as opposed to the drill down chart info. How can I get around to get the tooltip chart to display the drilldown info? What does the function GetBarData() do?
You can try looking at:
http://help.infragistics.com/Help/NetAdvantage/NET/2008.3/CLR3.5/html/Chart_Use_ToolTips_in_Drilldown_Charts.html