Post reply

Can we export Sub reports to excel?

  • May 4, 2010 at 2:47 am

    #386841

    Hi All,

    I have a report which calls two subreports.

    Can I export the detail reports to excel?

    I want to do this along with master. i.e i must put them in a single excel.

    Is is possible?

  • May 4, 2010 at 10:56 am

    #1161954

    Hi,

    I think it is possible , provided you are using the Subreport object from the Tool set rather than using the Jump to Report option in the report main report.

    Thanks & Regards,
    MC

  • May 5, 2010 at 3:12 am

    #1162301

    oh sorry i must have mentioned it in my post.

    i have actually used Jump to Report option itself.

    So its not possible 🙁

    Is there any other way by which i can export such reports?

  • May 6, 2010 at 9:19 am

    #1163339

    No, it cannot be done in SQL Server 2005.

    See the BOL: http://technet.microsoft.com/en-us/library/ms157399(SQL.90).aspx

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

  • May 7, 2010 at 2:01 am

    #1163856

    Only just starting out on the sql server BI road but I've acheived this by exporting to CSV and then linking to this from an excel workbook.

  • May 7, 2010 at 3:32 am

    #1163897

    thanks for the reply. could you please give more details on this?

  • May 7, 2010 at 3:44 am

    #1163904

    Instead of exporting directly to excel which doesn't contain the subreport data I export to CSV. I then have a workbook saved that uses the csv data as a datasource and updates when opened. In a way it kinda defeats the point of using reporting services to format a report - but its the only solution I found when users want the report in an excel format.

  • May 11, 2010 at 7:52 am

    #1165548

    You can't export subreports directly to Excel in SSRS 2005, but you can do it in 2008.

Viewing 8 posts - 1 through 7 (of 7 total)

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