Post reply

SSRS 2005 - Splitting excel sheets while export a report

  • September 29, 2011 at 3:22 am

    #258026

    Hi All

    I have a RDL with details with 5 regions.

    It all details come in a single sheet while i export to excel.

    I have to specify each sheet for each region. ( Split into 5 sheet in a single excel file)

    Is it any possible? If yes, please advice me.

  • September 30, 2011 at 1:48 pm

    #1389012

    visual.prabu (9/29/2011)

    Hi All

    I have a RDL with details with 5 regions.

    It all details come in a single sheet while i export to excel.

    I have to specify each sheet for each region. ( Split into 5 sheet in a single excel file)

    Is it any possible? If yes, please advice me.

    Yes, force a page break before each region.

  • October 4, 2011 at 4:03 am

    #1390043

    Thanks. It works.

  • October 4, 2011 at 7:22 am

    #1390121

    visual.prabu (10/4/2011)

    Thanks. It works.

    Sure, no problem.

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

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