Post reply

opening ssrs straight into excel

  • August 14, 2012 at 9:17 am

    #266002

    Hi

    I would like to open an ssrs report directly in Excel via a link.

    I have tried &rs:Format=EXCEL and it doesnt seem to work.

    Does anyone have any ideas?

    thanks in advance

  • August 15, 2012 at 1:40 am

    #1525886

    bump

  • August 15, 2012 at 2:04 am

    #1525895

    The only way I would of thought to do that, would be to have a subscription which runs the report and exports to excel and saves it on a file share.

    Don't think you can get it to open dynamically in excel.

  • August 15, 2012 at 2:04 am

    This was removed by the editor as SPAM

  • August 15, 2012 at 3:45 am

    #1525925

    thats a pity

    thanks for the replies

  • August 15, 2012 at 4:15 am

    #1525931

    You could design the equivalent report in Excel, and connect it to a SQL datasource.

    Not sure Excel has all the functionality you'd get from SSRS Report Designer though.

  • August 15, 2012 at 4:42 am

    #1525939

    Thats a cracking idea thanks

    why didnt i think of that 🙂

  • August 15, 2012 at 4:55 am

    #1525943

    No problem. Just be cautious because you'll lose a lot of the protection from misuse that SSRS can give you!

  • August 15, 2012 at 5:00 am

    #1525945

    Gazareth (8/15/2012)

    No problem. Just be cautious because you'll lose a lot of the protection from misuse that SSRS can give you!

    Yeah ive thought about that

    what i have proposed is that i create a spreadsheet that can be downloaded from the intranet and when it is opened it refreshes the data and then any links to the database are removed

    i just need a bit of vba in the spreadsheet 🙂

  • August 15, 2012 at 5:08 am

    This was removed by the editor as SPAM

  • August 15, 2012 at 5:45 am

    #1525953

    If you're doing that, why not leave the report in SSRS as it is and people can export it to Excel if required?

  • August 15, 2012 at 7:04 am

    #1525974

    Stewart "Arturius" Campbell (8/15/2012)

    erics44 (8/15/2012)

    Gazareth (8/15/2012)

    No problem. Just be cautious because you'll lose a lot of the protection from misuse that SSRS can give you!

    Yeah ive thought about that

    what i have proposed is that i create a spreadsheet that can be downloaded from the intranet and when it is opened it refreshes the data and then any links to the database are removed

    i just need a bit of vba in the spreadsheet 🙂

    Please bear in mind that this implies that whoever will open the spreadsheet will require at least datareader privileges on the underlying tables in the database.

    yep it will at opening time

Viewing 12 posts - 1 through 11 (of 11 total)

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