Drill Down in SSRS Reports

By
roopesh.valluru
-
115
8122
DrillDown Report
DrillDown Report

Friends,

A drill down report is a type of report that displays summary data with links to related detail data in other reports. If a report has at least one group column the we can set Drilldown functionality to that report. You have to use VISIBILITY property to implement drilldown functionality in your report. Lets see how to configure Drilldown in a report. I dsigned a report with three group columns(category,subcategory and product) and few details. PFB the screenshot of the same.

DrillDown Report
DrillDown Report

In the above screenshot you can see the three groups created. Now PFB the steps involved in implementing drilldown feature for this report.

1) Right click on GROUP2 and select Group Properties.

2) Select Visibility option, select Hide from the options given for When the report is run initially:label, check the check box of Display can be toggled by this report item: label and select Group 1 from it’s drop down list as shown in below screenshot.

Drill Down Report
Drill Down Report

3) Repeat the same step for Group3 and select Group2 for this in the drop down list.

4) Now Preview the report and you can see Drill down report a s shown below.

Drill Down Report
Drill Down Report

That’s it and it is as simple as this. This is easy to configure but a very powerful feature in SSRS. Happy Coding !!

Regards,

Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

115 COMMENTS

  2. dissertation crossword clue
    [url=”https://accountingdissertationhelp.com”]phd dissertation help download[/url]
    phd dissertation help download

  4. dissertation chapters
    [url=”https://customdissertationwritinghelp.com”]dissertation help online free[/url]
    doctoral dissertation help your

  6. writing a dissertation abstract
    [url=”https://dissertationhelpexpert.com”]cheap dissertation help in los angeles[/url]
    best dissertation writing service

  11. help with masters dissertation
    [url=”https://helpwithdissertationwritinglondon.com”]dissertation proposal methodology example archived[/url]
    uf thesis and dissertation

  12. write my dissertation for me
    [url=”https://professionaldissertationwriting.com”]dissertation title generator[/url]
    best dissertation writing service review

  15. L’esdeveniment està format d’un període formació-entrenament i una jornada de competició, és per aquest motiu que volem realitzar un equip representat de la vostra escola o pots crear el teu propi equip amb els teus amics.

  18. writing a literature review for a dissertation
    [url=”https://writingadissertationproposal.com”]cheap dissertation writing services[/url]
    dissertation help articles

  27. online casino with free signup bonus real money usa no deposit
    [url=”https://ownonlinecasino.com”]play blackjack online money[/url]
    online casino bonus

  39. pharmacie aix en provence club hippique therapie de couple haguenau pharmacie bordeaux quinconces , pharmacie lafayette toulouse l’union therapie cognitivo comportementale montreal , pharmacie bordeaux pas cher pharmacie de garde marseille castellas pharmacie en ligne rouen Comprar Prednisolone 20 mg genГ©rico, Prednisone precio Venezuela [url=https://www.dismoimondroit.fr/questions/question/prednisone-precio-venezuela#]Compra Prednisone a precios mГЎs bajos[/url] Comprar Prednisone 20 mg sin receta Prednisone barato en la farmacia. pharmacie bailly act therapy cards Neurontin precio Miami, Neurontin precio Miami [url=https://www.jotform.com/build/222347193175053#]Neurontin Neurontin 300 mg[/url] Neurontin precio sin receta Comprar Neurontin envГ­o libre. pharmacie hotel de ville boulogne billancourt pharmacie lafayette wilson , pharmacie amiens livraison therapies comportementales cognitives et emotionnelles en 150 fiches 40 Mg prix Canada, Clenbuterol bon marchГ© [url=https://www.jotform.com/build/222362398178060#][/url] Clenbuterol prix sans ordonnance Clenbuterol sans ordonnance Canada. pharmacie fontenaille aix en provence pharmacie boutouga argenteuil .

  50. pharmacie en ligne rouen traitement zona pharmacie en ligne ussel , pharmacie auchan eaubonne traitement gale , pharmacie yvrac therapies cognitivo-comportementales pharmacie aeroport paris beauvais pharmacie de garde tours traitement covid 19 act therapy bus metaphor .
    pharmacie ile seguin boulogne billancourt pharmacie lafayette st malo pharmacie ouverte franconville , pharmacie.auchan therapies holistiques . pharmacie palette tholonet aix en provence pharmacie lafayette gambetta pharmacie ouverte sarcelles therapies comportementales et cognitives poitiers . konjac pharmacie lafayette medicaments derives du sang medicaments immunosuppresseurs , pharmacie lafayette elbeuf pharmacie leclerc herbignac , pharmacie de garde aujourd’hui arras traitement lithium pharmacie en ligne drive Vente Stilnox 10 mg bon marchГ©, Equivalent Stilnox sans ordonnance [url=https://www.kiva.org/team/vente_stilnox_10_mg_bon_march#]Stilnox prix sans ordonnance[/url] Stilnox vente libre Acheter Stilnox 10 mg en Suisse. pharmacie ouverte clichy pharmacie auchan val de fontenay pharmacie proche beauvais traitement lithium therapie de couple tournai , therapies comportementales et cognitives (tcc) pharmacie ouverte orthez . pharmacie lafayette elbeuf pharmacie precheur aix en provence act therapy bus metaphor

  62. We must attach it to the parcel, International Postal Law requires it tadalista vs cialis While all sites asked whether customers were currently taking nitrates, only 4 specifically asked about recent myocardial infarction, and only 2 of those used the lay term heart attack

  65. At the beginning of the decision, a hundred wastes are waiting Barbarian Xl Shop viagra coupon 3 free pills to be revived comprare cialis online A literature review was performed to identify all published randomized or non-randomized controlled trials that compared tadalafil with sildenafil for the treatment of ED and to assess the quality of the studies

  75. As with sildenafil, the use of tadalafil is contraindicated in patients receiving nitrate therapy because of the potential for significant hypotensive effects buy cialis online from india The pharmacokinetics of sildenafil in patients with severely impaired hepatic function Child-Pugh Class C have not been studied

  77. i need a emergency loan today, i need loan embassy finder. i need a money loan with bad credit i need loan, i need a payday loan direct lender, cash advance loans reviews borrow money now [url=https://www.borrowmoneyok.com/#]borrow money online[/url], cash advance loans colorado springs, cash advances, cash advance, cash advance loans what do i need. Business is typically viewed money, designed for companies. i own my home outright and need a loan [url=https://ineedloan.me/#]i need a loan online[/url] payday loan direct deposit.

  82. They will be eligible if they meet the following inclusion and exclusion criteria. otc provera clomid It took us a while, and we did have to change treatment plans a number of times but eventually we not only conceived again multiple times but also welcomed our first take home baby back in Oct 21 a little over 4 years after that first miscarriage.

  83. Verywell Family uses only high-quality sources, including peer-reviewed studies, to support the facts within our articles. clomid 100 mg My personal opinion is that if after 3 4 rounds without success, that you d want to move on to IUI or FSH and HCG so that the final 2 3 rounds use clomid in connection with IUI.

  91. to something whereas someone, she involved whilst discovered the fluctuations upon their banks . plaquenil medication [url=https://plaquenilnon.quest/#]buy Plaquenil covid[/url] establish fab do eye eye, He discovered me the tide episodes than musser matches, [url=http://mail.portailoniria.com/node/18#comment-12534056]culture can be defined as[/url] bea502d pharmaceutical adaptations, into the location replication 59-61 because customer 114-127 .

  105. ak88bet เป็นคาสิโนออนไลน์ที่เหมาะสมที่สุดเป็นต้นฉบับและไม่ได้ก็อปปี้ มาจากเว็บอื่น พร้อมสัมผัสควา มสนุกสุดมันส์ กับ เกมที่น่าตื่นเต้น และได้ เงินกับ pg slot-th.com แตกง่ายได้เงินจริง

LEAVE A REPLY

Please enter your comment!
Please enter your name here

+ 69 = 70