Send SSRS Reports in Email as attachments in SharePoint 2013 Integrated mode

After creating your SSRS reports and saving them in SharePoint report library, sometimes it is require to send them as an email attachment by using Timer job. this piece of code will help to get this done.
// coming soon 

Steps to Configure SSRS in SharePoint 2013 in integrated mode

-    Download and install .mssi

-        Configure SQL server and add reporting feature

-        Run Power shell Commands

-        Create A service Application in central admin

-        Create a new Document library for storing reports and add SSRS related Content Types

-        Create Reports

-        Deploy reports

-        Show Reports in SharePoint Page in Web Part

Download and install rsSharePoint.msi

Download and install the rsSharePoint.msi. from here http://www.microsoft.com/en-in/download/details.aspx?id=35583

So that, PowerShell can recognise your ssrs related commands, else you will keep getting this error

“The term 'Install-SPRSService' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again”.

Make sure you are downloading the appropriate version of the installable.

 

 

Configure SQL server and add reporting feature

Now, go to your SQL server installation centre

-Select new sql server standalone installation or add feature to your existing installation

-In choose media option select your set up (or .exe) folder.

-keep going till feature selection section.

- Now, under feature selection select

Reporting service – SharePoint

Reporting service add in- SharePoint

img

Press next.

-        Now under installation of report add in select “ Reporting service SharePoint integrated mode”

img

-        And finish the installation.

Run Power shell Commands

Run these PowerShell to get the option of creating a new SSRS Service application and proxy in SharePoint central admin

1.Install-SPRSService

2.Install-SPRSServiceProxy

3.get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance

Create a SSRS service Application in central admin

-        Go to Central admin -> application management -> manage service application

-        Now, click on new and select SQL server reporting application.

-        Give and name like SSRS and create a new APP Pool.

-        Select the Web Application for which you want to configure SSRS.

Configuration is done.

Now, to create reports follow these steps

Create a new Document library for storing reports and add SSRS related Content Types

Activate a Project Server feature 
Create a document library and add these content types

Report Builder model

-Report builder report

-Report datasource

-Now go to your Document Library ->files-> click new

Choose “Report Builder Report”

Deploy reports and show reports in Page

Now you can create and design the reports and save them in your document library. To Show the reports in a page just add and configure “sql server reporting service web part”.