Birt graph drill through on dates

[MikeDel001]

Hi all,

Hopefully someone can put me out of my misery here as i have been trying this on and off for a week or 2 now.

I have designed a graph which groups installs by date and status. So, i have a graph that will show in Aug 23 there may be 30 COMPLETE, 12 CANCELLED, 3 ACTIVE. thats all well and good.

What im trying to do is when i click on the ACTIVE bar for example, it will show the 3 ACTIVE jobs but it doesnt...I can only seem to get it to work on a day basis. so if i ungroup them by month/ year and just have it as days, it provides the correct result on the drill through. The Issue there is i have a graph with THOUSANDS of bars.

How can i get the graph to get the min date within that month and the max date within that month and then show me everything between those dates?

Sorry if i have rambled a bit, if you need any more info let me know.

Thanks,

Mike.