Exporting SSRS Report into New Excel Work Book

  • It is possible for a SSRS Report to generate each new excel workbook for each record..??

    Eg: 100 ID into Excel Book 1 and then 101 record into new Excel workbook 1 in this way....

  • Never tried that. But must be feasible through custom code. Please post the solution if you resolve it.

  • Seems like the wrong tool for the job: SSIS seems to be more appropriate.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • If you mean worksheet then you can add a group (with page break set) with an expression based on rownumber.

    If you mean workbook then no.

    Far away is close at hand in the images of elsewhere.
    Anon.

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

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