Wednesday, March 14, 2012

SSRS - How to show a tablix inside a tablix

1.     Background

This article describes how we can show a tablix inside a tablix. Cascade tablix report is very useful in such cases where we need to show summary and detail data within the same report. One tablix can be used for summary data and another tablix can be used for detail data. The advantage of this kind of report is that we don’t need to create sub report to show detail data.

Let’s consider the below data for the article. Below table having information about Country, city and its population with respect to male and female:


2.     Steps to create cascade tablix report


                    I.            Create a data source that points to required server and database.

                  II.            Create a dataset having the below SQL query:

    SELECT * FROM Population

 Dataset output is same as above mentioned table.

Create a simple tabular report having two columns Country Name and Total Population:


               III.            The above report is simple report does not having any groupings. Now we will add a group for Country Name. For Grouping, Go to grouping paneè Row Grouping èright click on the Details groupè Group propertiesèGeneral tabè Group on should be “Country Name”è click.


                IV.            Now go to report layout and add sum function to numerical value(Population field):


                  V.            Preview the report. We can see all country names with total population. So this report is showing summary data for country and its population.



                VI.            Now create one more tablix using the same dataset that above report is using for showing detailed data:
              VII.            Preview the report. We can see first tablix showing summary data and second tablix showing detail data.

            VIII.            Go to Report layout è first tablixè right click on left most of the row è Insert rowè Insert Group below:


 It will add a new row to tablix within the same grouping:

                IX.            Merge the cells of newly created row:

                  X.            Right click on the second tablix, copy and paste on newly created row of first tablix. We can remove country column as it is already available in first tablix.



                      Preview the report:


                XI.            For better visibility, we can add drill down also. For adding drilldown,  right click on the row where second tablix is pastedèRow VisibilityèChange the display option – When the report is initially run to “Hide” and display can be toggled by Country Name textbox and click ok:


              XII.            Now preview the report. We can see the drilldown in the report. When initially report runs, it will show summary data:

            XIII.            For seeing the detail data, we can click on (+) sign :

3.     Conclusion


 We can show a tablix inside a tablix by inserting the tablix in any group of the parent tablix.

 ----------------------------------------------------End of Article---------------------------------------------------


16 comments:

  1. Thank you!! I have been wasting time with complex grouping and subreports while looking for this answer everywhere with no luck. My report is finally working now!!

    ReplyDelete
  2. Love to see all your articles... Great work!, I love you Vishal Jharwade :)

    ReplyDelete
  3. hi..
    i tried this one. but i am getting this error..
    Plz help me out..

    "Error.....The tablix ‘Tablix30’ has a detail member with inner members. Detail members can only contain static inner members."

    ReplyDelete
  4. Thanks, searching for a guide like this for a while

    ReplyDelete
  5. Côte d'Ivoire, also known as the Ivory Coast, is a West African country that requires visitors to obtain a Cote D'ivoire Visa prior to arrival. necessary to obtain. And usually a valid passport, filled application form and other supporting documents are required. Visa fee varies depending on the length of stay and purpose of visit. Côte d'Ivoire offers visitors a rich cultural experience and opportunities for wildlife safaris, beaches and vibrant markets.


    ReplyDelete
  6. I have been a reader for a long time and your quality has never faltered. Cappadocia Welcomes 140,000 Tourists in Just 5 Days, showcasing its timeless allure. The region's enchanting landscapes and rich history continue to captivate tourists from all corners of the globe.

    ReplyDelete
  7. Seychelles citizens can obtain an Indian visa for tourism, business, or medical purposes. India Visa for Seychelles Citizens. Apply online or at the Indian Visa Application Center. Prepare required documents, pay the fee, and attend an interview if needed. Processing time varies. Check eligibility and guidelines before applying. Enjoy your visit to India!

    ReplyDelete
  8. Obtaining a Turkey visa from Iraq is a fundamental step for Iraqi travelers seeking to immerse themselves in Turkey's diverse culture, historical heritage, and breathtaking landscapes. This process ensures that Iraqi passport holders can explore Turkey's enchanting attractions with ease. Travelers from Iraq can apply for their visas through the Turkish consulate or embassy in Iraq, following the required documentation and procedures. Alternatively, the convenient e-Visa system offers a simplified and user-friendly application process, streamlining travel planning to Turkey. With the appropriate visa, Iraqi adventurers can embark on exciting journeys, creating lasting memories in this captivating country.

    ReplyDelete
  9. Hii everyone, Navigating the Azerbaijan visa process for Indian travelers is essential for a smooth and hassle-free visit to this vibrant Eurasian nation. This guide outlines the steps and requirements for obtaining a visa to Azerbaijan, ensuring a seamless travel experience.

    ReplyDelete

  10. Hello! Your blog posts are truly enjoyable to read. Azerbaijan visa on arrival for Indian travelers is available through the ASAN visa system, simplifying the process for seamless exploration of this Eurasian gem's history, culture, and landscapes.

    ReplyDelete
  11. Hello everyone, Embark on your journey to the United Kingdom with ease through the UK Visitor Visa from India. Our simplified application process ensures a hassle-free experience for your travel plans.

    ReplyDelete
  12. This article provides a step-by-step guide on cascading tablix reports in SQL Server Reporting Services (SSRS). It explains the benefits of this approach, including summary and detail data display, and includes screenshots and instructions for user-friendly implementation. The article emphasizes the importance of SSRS in creating complex reports. Fatal Accidente de Semirremolques Hoy

    ReplyDelete