Diilldown from a chart

trawfazzz

I am using Birt 2.6.2 I have created a simple bar chart with dates on the x axis and prices on the y axis. I want to drilldown on prices for a given date from the chart. I have done the following:
1. create a new Detail report with all the prices listed.
2. I have added an input parameter of type DateTime and a ? mark in the query to get data from a specific date
select fuelweeklysales.EMM_EPMRR_PTE_NUS_DPG,
fuelweeklysales.EMM_EPMR_PTE_NUS_DPG,
fuelweeklysales.EMM_EPMM_PTE_NUS_DPG
from fuelweeklysales
where fuelweeklysales.fuleDate = ?
3. If I test with a parameter all works fine. If I do a non-chart hyper link to detail it works fine.
4. I create the bar chart. I click interactivity from the X axis.
5. I add a mouse click url to a drill-through and I select the detail report
6. I click the report parameter and it auto populates with the correct parameter.
7. This is where it kinda breaks down. The value BIRT Expression Builder does not show access to any data bindings so I past in row["fuleDate"].
8. When I preview the report I get the chart and when I click the chart I get the detail report but the data is the same for all items I click on so the data in not being passed between the chart and the detail report.


Please any help would be appreciated