|Re: Query Option not displayed in Edit-DataSet Option [message #1015277 is a reply to message #1014983]
||Thu, 28 February 2013 02:30
| Michael Williams
Registered: July 2009
In the main report, you'd create your main query and create your pie chart, like normal. In the chart editor, you'd go to the format chart tab and add interactivity to your series to drill down to your detail report.|
In your detail report, you need to make a report parameter to accept the value from the main report. Then, you'd make a query like: select customers from sales where product = ?
The '?' creates a dataSet parameter. In the dataSet editor, you'd go to the parameter section and double click on the automatically created parameter. In the link to drop down, select your already created report parameter.
Now, go back to your main report and go back into the drill down you created and pass the category value through the parameter to the detail report.
This should do it. Let me know if you have questions or if you get stuck because I missed a step.
Developer Evangelist, Silanis
Powered by FUDForum
. Page generated in 0.01911 seconds