Post reply

Extracting output in Multiple worksheet from SSRS

  • March 10, 2016 at 2:39 am

    #313922

    Hi Folks,

    I am trying to create SSRS report which will extract output the multiple worksheet.

    I have to create two worksheet:

    1. Base data - Base data of my output

    2. Summary - Summarization of data based on Base data worksheet

    Please let me know how can i do this.

  • March 10, 2016 at 6:45 am

    #1864221

    Hi,

    To divide output over different sheets you use the PageBreak property. To label the Sheets you can use the PageName property.

    If the data and summary are different tablixes change the PageName of the first one. Then for the second tablix set the PageBreak -> BreakLocation property to "Start" and change the PageName again.

    It should output to Excel as separate worksheets.

Viewing 2 posts - 1 through 1 (of 1 total)

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