Hi gurus
I am in need to create a chart report in report studio.
I need to create 3 chart report and make it as one query,then i will be having year and revenue column in first chart,and in second chart i will be having revenue and prdocuct line,Then in third chart i will be having revenue and country.
Now i am in need to drill down the first chart year by year and it should drill to quarter level and accoring the the revenue should change in all other two charts..., how can i accomplish this...
please help me...
Thanks in advance....
I think just adding a drill through and passing year data item's value should be enough.