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.

enter image description here

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

Popular posts from this blog

symfony - TEST environment only: The database schema is not in sync with the current mapping file -

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -