Post reply

Exporting details directly into Excel

  • May 16, 2011 at 5:10 pm

    #237420

    Hi All,

    I have a summary report with totals for each month, example:

    Month TotalCalls

    Jan-2011 52

    Feb-2011 38

    Is it possible to be able to click on the TotalCalls value (i.e 52) and when you click on this link it automatically exports the detail (52 records) for Janaury into an excel spreadsheet?

    In the past i have had to create a separate detail report, which the user could then could manually export using the standard 'export to' functionality provide by SSRS.

    Look forward to hearing if this would be possible with SSRS.

    Regards,

    Robbie

  • May 16, 2011 at 7:12 pm

    #1325547

    Set your Action for that cell to Go To URL, and build the URL pointing at your sub-report, with a rendering option of Excel. (see BOL for more details here: http://msdn.microsoft.com/en-us/library/ms154040.aspx)

    You'll have to do some manipulation while you're building the string to pass in the parameters to show that detail specifically, but it might be possible that way.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

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

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