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
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:
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:
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!!
ReplyDeleteGreat Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
thanks dude..
ReplyDeleteLove to see all your articles... Great work!, I love you Vishal Jharwade :)
ReplyDeletehi..
ReplyDeletei 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."
Typically this error happens when the outer tablix doesn't have anything setup in the Group Expressions in the Group Properties.
DeleteThis is still very usefull. Thanks again! from November 2015..
ReplyDeleteYou are my angel who help me out from a big mess! Great review!
ReplyDeletenice article
ReplyDeleteHow can you paste three columns into a merged cell? I think something is missing...Can you explain in detail?
ReplyDeleteIX. 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.
Thanx!! This explanation matched what I was attempting perfectly
ReplyDeleteThanks a million !!!! You made it so simple and easy ! Saved my day !!!
ReplyDeletefantastic Article and great help Thank you.
ReplyDeleteWish this would work if sub tablix was against a different dataset
ReplyDeleteI tried and found it didn't work
DeleteThank you very much
ReplyDeleteHi ,
ReplyDeleteFor me the grouping is not working . only the header of the second tablix is showing . Detail is not coming.. Please reply as soon as possible.
how to create tablix inside tablix with different dataset.anyone please suggest.
ReplyDeletegmp certification in delhi
ReplyDeleteISO Certification in Noida
iso certification in delhi
ce certification in delhi
iso 14001 certification in delhi
iso 22000 certification in delhi
iso consultant in delhi
rohs certification in delhi
website designing services
seo serivces in delhi
we have provide the best fridge repair service.
ReplyDeletefridge repair in faridabad
Videocon Fridge Repair in Faridabad
Whirlpool Fridge Repair in Faridabad
Hitachi Fridge Repair In Faridabad
Washing Machine Repair in Noida
godrej washing machine repair in noida
whirlpool Washing Machine Repair in Noida
IFB washing Machine Repair in Noida
LG Washing Machine Repair in Noida
we have provide the best ppc service.
ReplyDeleteppc company in gurgaon
website designing company in Gurgaon
PPC company in Noida
seo company in gurgaon
PPC company in Mumbai
PPC company in Chandigarh
Rice Bags Manufacturers
ReplyDeletePouch Manufacturers
wall putty bag manufacturers
Lyrics with music
Just adding my thanks...
ReplyDeleteIf you are looking to do master / detail work for SSRS then this is the only place I've found and easy and comprehensible way of doing it!
Aivivu vé máy bay giá rẻ
ReplyDeletesăn vé tết 2021
ve may bay di my gia re
đường bay từ Việt Nam sang Pháp
giá vé máy bay từ việt nam đi hàn quốc
vé máy bay vietjet đi nhật bản
bay từ việt nam sang Anh mất bao lâu