How can i generate reports to mail or the local path.

Question

Post reply

How can i generate reports to mail or the local path.

CH&HU-1021641

Ten Centuries

Points: 1387
More actions
March 3, 2009 at 9:21 pm

#128235

Please help !
How can i generate DashBoard, All sessions...etc., reports of the Production server to my local machine or the same machine. Will this be possible through MStudio only ? or any other process?
Am struck in doing this manually. I want this to be automated.
Thanks,
CH&HU.

Viewing 6 posts - 1 through 5 (of 5 total)

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

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 1

Hi,

Go to Subscriptions TAB and Click New Subscription and fill out details like below...

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

CH&HU-1021641 Ten Centuries Points: 1387 More actions · Answer 2

Hi,

Thanks for the information provided.

Is that possible from Management Studio ? The process you have pasted was that with MStudio ?

as we never used Reporting services. Am doing manually everytime ?

Thanks,

CH&HU.

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 3

Hi,

Same is possible in Management Studio. Refer this MSDN article

http://msdn.microsoft.com/en-us/library/ms159699(SQL.90).aspx

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

kgaudana Grasshopper Points: 16 More actions · Answer 4

Hello,

Can you tell me if i want user to send a report by email directly when they open Report, is it possible?

Regards,

Kaushal

CH&HU-1021641 Ten Centuries Points: 1387 More actions · Answer 5

Hi Kaushal,

Yes it will done by using reporting services. there we can subscribe the reports to mail address. Iam working on the same to subscribe the reports of performance dashboard.