November 10, 2013 at 3:29 am
Hello All...
Please I would like help on the following regarding reporting services...First here are the basics..
I work as data entry/database admin..am not too vast in SQL am just learning it now.I have installed SQL 2012 on my windows 7 laptop and I can run simple queries from there.
Now I want to automate the reports I send to the various departments from SQl..and I need your help.
1. Is it possible to automate the report such that sql extracts the report from the database at a given time and also sends to specific receivers at a specified time.....
2. is it possible to make my windows 7 laptop on which a installed the sql 2012 a report server,if yes please what do I need to do( Please also note that my laptop is joined to the domain)
Please email address is james.enock@hotmail.com or omojesu89@yahoo.com......Please I really need this help I would be glad if you can help me.
November 11, 2013 at 2:02 am
1. Is it possible to automate the report such that sql extracts the report from the database at a given time and also sends to specific receivers at a specified time.....
Yes, it's called "report Subscription". Look it up in BOL (SQL Server help).
2. is it possible to make my windows 7 laptop on which a installed the sql 2012 a report server,if yes please what do I need to do( Please also note that my laptop is joined to the domain)
You need to install Reporting Services and configure the service through the Reporting Services Configuration Manager.
Please email address is xxxxxxxx@hotmail.com or xxxxxx@yahoo.com......Please I really need this help I would be glad if you can help me.
Don't post your email here. Wait for replies on the forums.
If you don't want spammers hitting your mailbox, edit your post and remove your addresses.
-- Gianluca Sartori
November 16, 2013 at 10:38 am
am so grateful for this.....Please how can I reach you so that we can talk more...Please this would help me keep my Job and also increase my Knowledge....I await your response
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply