Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


REPORTING SERVICE


REPORTING SERVICE

Author
Message
omojesu89
omojesu89
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 7
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.
spaghettidba
spaghettidba
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5732 Visits: 13305

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

How to post T-SQL questions
spaghettidba.com
@spaghettidba
omojesu89
omojesu89
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 7
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search