January 13, 2009 at 12:50 am
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 make 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.
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
January 13, 2009 at 1:47 am
You can try the Subscription options available in SSRS.
- Open the report.
- Go to Subscriptions
- Select 'New Subscriptions' OR 'New Datadriven Subscriptions'
- It will show you a step by step wizard.
-Vikas Bindra
January 13, 2009 at 1:49 am
Forgot to mention that you can send offline Excel/PDF files through subscriptions.
-Vikas Bindra
January 13, 2009 at 1:56 am
Thank You very much for helping,
Can you brief me with how and what this does?
Regards
January 13, 2009 at 2:16 am
Where do i start, i don't find Subscriptions in Visual Studio when opening the report from solution explorer?
I tried the help, but still a bit lost!
Regards
January 13, 2009 at 2:22 am
Sure!
When you create a subscription for a report you will have to give the following information:
1. How to send the Report (Report Server E-mai/(one more option is there)).
2. Whom to send the Report
3. The schedule for the subscription, which will decide when to send the report. The report will be sent to everyone mentioned in step 2 at the specified schedule
You need to have a SMTP server in your environment(through which the mails will be sent) also you will have to configure the Report Server to use that SMTP server.
The following article might help you in configuring the Report Server to send mails:
http://technet.microsoft.com/en-us/library/ms345234(SQL.90).aspx
-Vikas Bindra
January 13, 2009 at 2:25 am
The subscription option will come on SSRS web site after the report is deployed on the server.
You will have to deploy and the browse the report to have the Subscription option available.
-Vikas Bindra
January 13, 2009 at 2:54 am
Thank You, too kind.
Will update, as soon as I complete the SSIS package and report in visual studio.
Regards
January 13, 2009 at 3:22 am
My friend, I need to know if there is a way using SSAS.
I just thought of it, the current excel pivot table allows the filter criteria to be dragged with in the data area. Which I don't will be possible in SSRS?
It has to be similar but more intellengent than the existing excel pivot report, where one can drill down to the lower data!
January 13, 2009 at 4:09 am
Don't know about mails through SSAS 🙁
-Vikas Bindra
January 13, 2009 at 9:07 am
You can create SSRS report tapping into SSAS cubes, then add subscription on that in Excel, which I believe it will preserve the drill down structure, I hope
Should mention what SSRS version you're discussing here. SSRS 2005/2008 has come a long way...
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply