Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2009-01-12 : 02:31:11
|
| Hi, I need help please. Currently have an SSIS package the output to an excel pivot table, reason being that the report can be emailed/distributed to all users that are offline or does not require access. I was asked to changes to the repot as well as look at a new method of outputting the report. The report has to filter as well as drill down to the raw data.Management is not keen on SSAS as we are still using Cognos Powerplay.I'm keen on going SSRS, then make the report Offline - so that i can email/distribute the report?The report can initially be online but needs to be distributed in an offline file!Please Any advise ideas best way forward, and some detail explanations of how to implement this. Thanking in advance, Regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-12 : 02:44:24
|
| seems like what you ned is to set report level subscriptions. read about report level susbcriptions in books online |
 |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2009-01-12 : 03:19:09
|
| Thank You for the assist, I tried google but don't get anything usefull. Can this not be done in SSRSRegards |
|
|
|
|
|
|
Offline SSRS or Offline SSAS