Preview Content - log in or Buy Access Pass

SSRS subreport

In this SSRS tutorial I will show you how to create subreport in SSRS. I will use SSRS 2008 R2 but this tutorial should also work in SSRS 2008 and SSRS 2012.

Just to clarify a subreport is a report which we want to display (embed) in main report.

First picture shows a report with sparkline which takes one parameter @date. In this tutorial I will use this report and emded it into main report.


Make sure that you have Dataset, Data Source and Parameter setup already.

In our example we will create a dataset called TrendWeeks which actually will contain only 1 row! We will use it to force a table to display a one cell we will add our subreport.

NOTE: Normally you would use real life dataset and display a subreport once or multiple times (many rows) with different parameters.

Our subreport takes one parameter "date" and in our main report we will create the same parameter "date" and pass it to the subreport.

NOTE: Very often you will pass either parameters to a subreport which is presented in this tutorial or you will pass values from a field which we will try to cover in a separate SSRS tutorial.

Below is a screenshot from where we start:

To access members only content...
Log in (active member) or buy Access Pass
Learn as much as you like
Unlimited learning access pass*
* Secure one off payment, no re-occuring payments, no need to cancel!
T-SQL SSIS SSRS 79 Mini Courses 529 Pages 287 Videos 314 Articles
Forum Live Webinars 12 Webinar Recordings DIY Projects Progress Tracking
New member joins every 8 hours

60 days, 100% money back guarantee
NO risks, NO questions asked, NO hard feelings

I can't speak highly enough of the quality MSBI materials industry practitioners with varying level of experience and exposure can benefit from this website. Their structured learning plan and courses, DIY projects, webinars and relevant resources go a very long way. I've gained a whole new perspective on delivering client BI projects to highest standards by employing best practices recommended on this website. Best quality MSBI training online suite I have used and least expensive too.

Franklin Demilade Osinowo

Best and affordable BI Training platform in the web. KEBI Academy doesn't provide training on BI rather their approach is to make you learn BI by yourself. Self Learning is always the best approach and I recommend KEBI Academy.

Jaiyaram Mahendran

You both are doing a great job by sharing your knowledge and experience, it helps many people who want to learn MSBI from the starting point and also for an experienced person to get to know more about MSBI. Thank you and keep sharing your MSBI knowledge and experience.

Shweta Patel

Great work on the videos. I have been enjoying them.

Patt Nelson

Did you find this page useful?
+2  |  -0
(2 Votes)