The Business Intelligence Blog

November 20, 2009

Building Subreport in Reporting Services

Filed under: SSRS — Tags: , , , — Shahfaisal @ 11:22 am

This blog post has been moved to



  1. but inline subreport doesnot work in ssrs 2005 for me.

    Comment by sara — June 9, 2010 @ 12:02 am

  2. Thanks so much for the article, very helpful !!

    Comment by Tembi — July 7, 2010 @ 3:33 am

  3. how can i add Subreport in the header Section of main Report kindly tell me plz

    Comment by Aqeel — July 28, 2010 @ 12:56 am

  4. Nice Articles.
    Keep posting on..

    Comment by Randhir Singh — October 22, 2010 @ 1:58 am

  5. Thanks for the steps you have explained.Excelent steps for subreport for SSRS i have never seen steps like this thanks one once its helped me a lot.

    Comment by Varma — December 27, 2010 @ 7:18 am

  6. Excellent tutorial. Thank you very much for your work.


    Comment by Marco Yandun — March 15, 2011 @ 5:08 pm

  7. aite aite

    Comment by boota — April 26, 2011 @ 11:11 am

  8. Chandrakanth(India-Vayalpad)

    Hi Grt tutorial,i am doing in 2008 But i can’t get Data Layout Preview i am getting Design and preview i tried table drag and drop ….But ?

    Comment by chandrakanth — June 27, 2011 @ 6:11 am

  9. Nice article clearly detailing the steps required to use a subreport. It is good to know how to do this. However I’d caution those reading this & considering using a subreport. In this example & in most real-world situations you will get the same look with much better performance by just embeding a data region inside another Data region. eg: It is possible to put a Table inside a cell of another table. OR perhaps a Chart inside each cell – to create a sparkline effect. (if you aren’t running the latest version of SQL that ships with sparklines as a standard feature.)

    Comment by Dave — June 29, 2011 @ 8:12 am

  10. Iam using VS 2008 with MS SQL 2005. Iam not getting the data tab as mentioned in the step to add the “Where ” condition. Could you please give me an idea on how i can do it

    Comment by Sid — July 12, 2011 @ 5:40 am

    • Hi Sid,

      If you are using 2008, you should be able to see that in the Datasets section. Go to View ->Report Data to open up the Report Data section.

      Hope this helps.

      Comment by Shahfaisal — July 12, 2011 @ 8:55 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Blog at

%d bloggers like this: