Drill Through Chart

[diasbrad]

Hi Friends,

I am trying to Create a Drill through using Chart. Here is a report that I am trying to create.

1) I have a Pie Chart showing the sales of different Products.
2) When I click on the Slice of the Pie of one Product, it should drill-through on the same report to a bar chart showing the sales trend of the last 7 days.

Is this possible to do ?

Can anyone help me out to do this.

Thanks in advance for your help.

Regards
Brad

[spmaganti]

Yes in theory. Try this:

1. Create a prompt (can hide it) with static values Pie, Bar defaulted to Pie with prompt name as 'Render'
2. Create two blocks on the report page, one for Pie and the other for Bar
3. Create string variable with the expression ParamValue('Render') and then create two values as 'Pie' and 'Bar'
4. Setup render variables for the two blocks
5. In the query create a DataItem with value 'Bar' (this will be used to pass values for drill-thru report)
6. Setup your drill-thru definitions to the same report and pass data item value for ?Render? as 'Bar'

So by default the pie chart will be loaded but then on the drill-thru since you're passing the data item value with 'Bar' for the ?Render? the paramdisplay value will be used to render the block.

Hope this makes sense