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:
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.
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.
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.
Great work on the videos. I have been enjoying them.