Post reply

Subreports within table/matrix cells are ignored.

  • September 25, 2006 at 8:05 am

    #114588

    Hi All,
     
    Can anyone provide a solution for error while exporting data to excel from SQl Reporting Services 2000.
     
    Sub report data is not displayed in excel, instead excel cell shows "Subreports within table/matrix cells are ignored " error.
     
    Regards,
    Sujaya.

  • September 25, 2006 at 11:45 am

    #662324

    If the subreport is inside the table and that subreport has another table in it... it wont display... alternative is to change your subreport... remove the table inside the subreport and convert it into List's with text boxes... try that ... hope that helps  


    Moe C

  • February 7, 2007 at 12:24 pm

    #688371

    this is a limitation of SQL Reporting services

  • February 9, 2007 at 5:44 am

    #688784

    Yes, this is a documented limitation in SQL Server Reporting Services.

     

    Prasad Bhogadi
    www.inforaise.com

  • July 20, 2007 at 7:39 am

    #721119

    Any word on a fix for this "Documented Limitation"?

  • July 24, 2007 at 1:19 pm

    #722029

    They've known about it for 3? years now.  I doubt they are going to do anything about it any time soon.

  • February 28, 2008 at 6:00 am

    #783106

    hi,

    I use the sub report with list boxes only as you said,but still I am getting the same error.

    Please suggest me the solution.

  • February 29, 2008 at 1:42 am

    #783637

    Exporting to Excel with a subreport within the report is a limitation. It does not mather what kind of subreport it is.

    So my question to you is why are you using a subreport?

    Niels Naglé

    Info Support

  • February 29, 2008 at 4:56 am

    #783681

    Hi,

    thanks for your reply.

    I have a matrix in my main report.Inside the matrix I have placed this subreport.Because the data displayed by the subreport is from a different data set.If I try to place the data directly in the matrix then it is showing an error.But my requirement is to place the data generated by a different dataset inside the top left of the matrix,so that it is shown in all the pages if I export to PDf.

  • February 29, 2008 at 5:11 am

    #783687

    hi,

    What kind of data do you have in your subreport and isn't it possible to build up your report with nested lists?

    Niels Naglé

  • February 29, 2008 at 8:39 am

    #783828

    thanks for the reply.

    No Its not possible.I can have only matrix in my main report.

    Is there any other way to put the data from another dataset into the matrix.

  • March 1, 2008 at 12:56 am

    #784127

    Yes it is possible as far as i know in sql server 2008 with the new tablix (not 100% sure of it)

    But I wonder if it's possible to combine the two datasets in the query (but then i need some more information on the datasets)

  • January 28, 2010 at 10:46 am

    #1110226

    Hi!

    My solution to this problems was very simple. I don't know is suit for all situations but, you'll could try, and tell me what do you think about this.

    I was using a Table, my main report use 4 subreports, I created 1 row and merge the columns, put a rectangle and after put all subreports in the rectangle, and that is.

    When I export the report to excel, all subreports were shown

    Regards,

    Alex :hehe:

    Visit:

  • February 4, 2010 at 10:42 am

    #1113877

    I think Alex's solution works with SSRS 2005

    But SSRS 2005 wont support the nested report items, while exporting in to Excel.

    That limitaion was fixed in SSRS2008. if you could able use SSRS 2008, you will see that difference.

  • July 12, 2010 at 5:36 am

    #1191402

    Hi,

    Its a limitation in SSRS 2005.. but it works fine in SSRS 2008

    Regards,
    Gayathri 🙂

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply