how to get display charts by selecting different chart
hi all
when ever i click on A.Fijalkowski(salesrepresentative) i should get all his customer related information in a pie chart and when ever i click on one particular customer i should get his sales in different divisions in a pie chart how could achive i
pls say me a solution
below is my screen shot
vandana
September 1st, 2012 6:39am
Hi Vandana,
you can achieve this functionality by two ways :Before that create a different report for the graph which accepts the desired parameter.
1) Sub-report functionality if want Drill down effect. Add the sub report tool in the main report and call the graph report which you created.
check below link for adding sub- reports:
http://msdn.microsoft.com/en-us/library/ms159837%28SQL.105%29.aspx
2) Right Click on the cell from which you want to open the report and work on the action tab properties , as shown in the below figure :This will give you Drill Through effect.
Hope this will solve your problem , let me know if more explanation required.*Regards*
*Samay Shrivastava*
*Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.*
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2012 7:10am