sql - Drill through reports in SSRS -
i making report takes in date parameters filter result , shows result in pie-chart. want create drill-through (could drill down or other type) if user clicks on part of pie chart divided agent names (as shown in image) second report should open takes in date parameter first report , agents name area of chart user clicks pie chart.
i have managed pass date parameters latter part, passing agents name need help.
so if click on lets grey area, other report should open records assigned agent.
yes - can done.
on charts, series properties, use action tab , go report. choose drill through report , add parameters.
for agent parameter, use
=fields!assignedto.value
as parameter value. pass selected pie slice assignedto agent in drill through report.
Comments
Post a Comment