SQLTeam.com | Weblogs | Forums

Is it possible to create drilldown report

Lets say i have report that gives a total sum of 10K and the user wants to know how this 10K amount has been arrived. So the user click the amount 10K, another report should be displayed to give the details. Is it possible to do in sql? kindly reply. its urgent. I am new to SQL.

Which report tool are you using?
This facility is available in the SSRS, Tableau kind of the reporting tools.

Thank for your reply. I am using SSRS or Report builder. May i know how to do that? if possible pls share some sample document, which would be very helpful for me.