Post reply

is it possible in SSRS ?

  • October 7, 2010 at 1:21 am

    #229137

    Hi,

    Is it possible to Render maybe 10 reports in a single EXCEL file in 10 sheets ?

    Thanks & Regards,

    Amar S

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

  • October 7, 2010 at 7:08 am

    #1233516

    I seem to recall reading that 2008R2 would export sub reports to different tabs. I am not sure about it, and I don't have the R2 version to test it with.

  • October 7, 2010 at 11:00 am

    #1233777

    thanks 4 the reply daniel.

    but i wanted to ask if i have to render 10 different reports (no subreport) in excel format there would be 10 excel files. but i want a single excel file with output of all the 10 reports on different sheets in that file.

    so, is it possible ??

    Regards,

    Amar S.

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

  • October 7, 2010 at 11:07 am

    #1233781

    Maybe what was meant was to create an 11th report with 10 sub reports and try doing it that way.

    Also in a tablix, you can add a group with page breaks, which will make 1 excel sheet per page break.

    I doubt you'll be able to use option 2 but just in case...

Viewing 4 posts - 1 through 3 (of 3 total)

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