Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

opening ssrs straight into excel Expand / Collapse
Author
Message
Posted Tuesday, August 14, 2012 9:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 6:44 AM
Points: 286, Visits: 573
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
Post #1344800
Posted Wednesday, August 15, 2012 1:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 6:44 AM
Points: 286, Visits: 573
bump
Post #1345142
Posted Wednesday, August 15, 2012 2:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:40 AM
Points: 5,221, Visits: 5,116
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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1345151
Posted Wednesday, August 15, 2012 2:04 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:35 AM
Points: 4,043, Visits: 5,360
One cannot open SSRS directly in Excel. the only exception is when there is a subscription, which generates an Excel spreadsheet and makes this availalbe for opening and use.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1345152
Posted Wednesday, August 15, 2012 3:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 6:44 AM
Points: 286, Visits: 573
thats a pity

thanks for the replies
Post #1345187
Posted Wednesday, August 15, 2012 4:15 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 2,020, Visits: 3,474
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.
Post #1345193
Posted Wednesday, August 15, 2012 4:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 6:44 AM
Points: 286, Visits: 573
Thats a cracking idea thanks

why didnt i think of that :)
Post #1345202
Posted Wednesday, August 15, 2012 4:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 2,020, Visits: 3,474
No problem. Just be cautious because you'll lose a lot of the protection from misuse that SSRS can give you!
Post #1345206
Posted Wednesday, August 15, 2012 5:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 6:44 AM
Points: 286, Visits: 573
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 :)
Post #1345208
Posted Wednesday, August 15, 2012 5:08 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:35 AM
Points: 4,043, Visits: 5,360
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.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1345211
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse