Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

REPORTING SERVICE Expand / Collapse
Author
Message
Posted Sunday, November 10, 2013 3:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 9:20 AM
Points: 2, Visits: 6
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.
Post #1512956
Posted Monday, November 11, 2013 2:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:14 AM
Points: 5,018, Visits: 10,527

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

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1513035
Posted Saturday, November 16, 2013 10:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 9:20 AM
Points: 2, Visits: 6
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
Post #1514931
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse