I am trying to make a report which provides drill down facility for each slice inside the pie chart.If the slice refers to USA then another report should be opened which will provide detailed information about orders placed in USA.But it is not working.
I have created two reports.In the first report I have created a report with pie chart and each slice as hyperlink.
In the second report I have displayed details about the orders based on the country.
For this I have used a parameter 'shipcountry' and I have used it as a prompt.
when I click on the slice for a particular country in the first report ,the name of the country should be passed to the second report and orders from that country should be displayed in the second report .
I am not able to pass 'country name ' to second report.I don't know what 'Hyperlink Reference Expression' should be used.I have tried many things but not getting the desired output.