SSRS simple drill-down tablix group:

SSRS provides grouping options and one of them is drill-down,

You can easily add a drill- down option on a report from Report Wizard. But once report wizard closed, you cannot return on it, you have to create a drill-down manually.

Here are some Steps for creating drill-down on a report manually:

Step 1:

Create a report; add your query and your tablix:



Step 2:

Add your group:

image002 (1)

image003

image004

Step 3:

Add Drill-Down Option to the group:

Select the group you want to hide (Here: Details -> Product ID and Desc)

On group properties, select visibility

Select Hide, Display can be toggled by this report item, and select the Textbox group Name (Here LanguageID)

And preview!

image007

 

image008

Advertisements
This entry was posted in SSRS and tagged , , , , , , , , , , , , . Bookmark the permalink.

2 Responses to SSRS simple drill-down tablix group:

  1. Rajesh says:

    how to hide the columns (Product Id,Desc) intially. Only on click + image it should display.Please let me know how to achieve this

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s