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 |
|
jsnypa
Starting Member
1 Post |
 Posted - 2013-11-10 : 07:54:06
|
| 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. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-11-10 : 08:41:11
|
| You can do all of that - you will need SQL Reporting Services installed for generating the reports, and SQL Server Agent for scheduling the reports.Reports can be created using the Business Intelligence Studio (which should be in the program group if you installed Reporting Services), or using Report Builder - which is a web based application.Start with a basic tutorial, for example from here: http://technet.microsoft.com/en-us/library/ms167305.aspx |
 |
|
|
|
|
|
SQL REPORTING SERVICES