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 email@example.com or firstname.lastname@example.org......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.
How to post T-SQL questionsspaghettidba.com@spaghettidba