Interaction from Chart to Table
Posted: Mon Aug 06, 2018 10:41 am
Hello,
I have a Stacked Chart with 3 series each linked with 3 different table(on page 1). Next, I need is to display the filtered table on clicking on the series.
Example: When I click on "Green" series of "B" then the next page(page 2) should display data with filter ("Green or 3" & "B").
See the attachment/image for details. The 3 tables are manipulated & generated from a single datasource i.e. "MainTable" and the table on Page 2 display data from "MainTable" but should be filtered with parameter from which series is clicked on the Chart.
I tried to do it with one series but the data on the next page does not filter properly. My filter condition for databand on Page2 is MainTable.Status == System.Convert.ToInt32(this["SeriesTag"]).
Chart Interaction details:
Drill-Down Enabled: Checked
Drill-Down Page : Page 2
Tag Data Column : GreenTable.Status
Is it possible to get 2 parameters("Green or 3" & "B") from Chart and filter the databand with these 2 parameter? If so, how?
Thanks & Regards,
Zalak
I have a Stacked Chart with 3 series each linked with 3 different table(on page 1). Next, I need is to display the filtered table on clicking on the series.
Example: When I click on "Green" series of "B" then the next page(page 2) should display data with filter ("Green or 3" & "B").
See the attachment/image for details. The 3 tables are manipulated & generated from a single datasource i.e. "MainTable" and the table on Page 2 display data from "MainTable" but should be filtered with parameter from which series is clicked on the Chart.
I tried to do it with one series but the data on the next page does not filter properly. My filter condition for databand on Page2 is MainTable.Status == System.Convert.ToInt32(this["SeriesTag"]).
Chart Interaction details:
Drill-Down Enabled: Checked
Drill-Down Page : Page 2
Tag Data Column : GreenTable.Status
Is it possible to get 2 parameters("Green or 3" & "B") from Chart and filter the databand with these 2 parameter? If so, how?
Thanks & Regards,
Zalak