Post reply

SSRS Export whole underlying dataset to excel.

  • July 30, 2014 at 4:59 am

    #297207

    Basically my reports are formatted displays of underlying datasets.

    How do I make the full (preferably not just the fields actually on the formatted report), dataset available to the end user, to be exported to excel.

    (The dataset can be exported be parameters, eg using stored procedures)

    I have tried putting in hidden tables in the report - this seems a cumbersome method.

    I would strongly prefer the option of the underlying data to be available, alongside the SSRS report - so end users went to the same place for formatted report, or basic data.

    Any pointers in the right direction would be gratefully accepted. THanks

  • July 30, 2014 at 5:06 am

    #1733517

    Hi Adam

    Have you considered going the other way?

    SSAS OLAP cube with a custom action which allows users to run a formatted SSRS report?

    That way users can interrogate data and if they want a formatted report they can just run it.

    [font="Arial Narrow"]MCITP Sql Server 2008: Business Intelligence. 4 Years +
    Jason Vollaire[/font]

  • October 27, 2014 at 4:37 am

    #1754881

    Hi,

    Any ideas on this. How to export entire dataset to excel. In my SSRS report, i have results at aggregated level. Whereas the requirement is to export the report at Detailed level.

    Thanks,

    Sundar

  • October 27, 2014 at 4:55 am

    #1754889

    I suggest that you post your question in a new thread to increase its visibility.

    -- Gianluca Sartori

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

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