All About SQL Server Reporting Service (SSRS)

Creating a New Report on SharePoint site


Here are the steps for creating a simple SSRS report using SharePoint list data 

  1. Create a Document Library in SharePoint.
Go to Libraries.  Click Create.  Give a specific name for the document library 


2. Allow Management of Content Types.
Click on your library. Go to Library Settings. Click on Advanced Settings.  Change the radio button for “Allow management of content types” to Yes.  Click OK.



3. Add Report Content type.
In the Library Setting under Content Types click on “Add from existing site content types”. Select and add  
  • Report builder Model
  • Report Builder Report
  • Report Data Source 
Click Ok

Create Report Builder Data Source

  Select New Document.

  From the Dropdown list select ' Report Data Source'

Give a specific Name to The Data Source Name

Select Microsoft SharePoint List From the Data Source type dropdown list

Give the connection string where your SharePoint list is located.




Select "Stored Credentials" Radio button.

Enter your user name and password

 
Checked "Use as Windows credentials" checkbox

Click "Test Connection" Button

If you get the "Connection created successfully" Message you are good to go :-)

Click Ok (Y)

 
Okay Now we have the Document library. Inside that we have a Report Data Source.. ..Lets begin to create SQL server Reports

Create Reports using Report Builder



Comments

Post a Comment

Popular posts from this blog

[SOLVED] The SharePoint Timer Service service terminated unexpectedly. Event ID : 7031

Image
The SharePoint 2013 Timer service terminated unexpectedly.  It has done this  34  time(s).  The following corrective action will be taken in 30000 milliseconds: Restart the service Login Name : System Source : Service Control Manager Event ID : 7031 Level : Error                                    Keywords : Classic User : N/A                                       Computer : MyDomain If you are getting above error. Try to do the following steps  1.  Clearing the configuration cache Stop the Sharepoint timer service Go to C:\ProgramData\Microsoft\SharePoint\Config\*GUID Back up Cache.ini Delete all the .xml file ( Do not delete the Cache.ini file ) Open Cache.ini (Edit with Nodepad) Replace the contents with the number 1 and save the file...
Read more

FIX : The password supplied with the username Domain\Username was not correct. Verify that it was entered correctly and try again.

Image
This will happen often while trying to create a new web application in SharePoint 2013 central administration site. It gives the following error This usually occur when farm account password is expire and it's password is changed or simply farm account password is changed. In that case, sometimes password stored in SharePoint database is different in Active Directory, so unable to create web application from central admin.  In order to resolve this problem you need to update SharePoint 2013 farm credentials using "STSADM" tool. For that Open PowerShell in administration mode then write the following code stsadm -o updatefarmcredentials -userlogin <UserAccount> -password <New-password> Example : Once you receive operation completed successfully message do a IIS reset !! FYI : In case if you getting an error message " stsadm not recognized as an internal command " Follow these instructions.. Happy Coding !! ...
Read more

FIX : stsadm is not recognized as an internal command

Image
If you try to run SharePoint STSADM.exe in powerShell and getting this error To resolve the error message you need to edit the profile.ps1 file Its located in C:WINDOWS\SYSTEM 32\WindowsPowerShellL\v1.0\ if the profile.ps1 file dose not exists, just create a new file and add the following code Set-Alias -Name stsadm -Value $env:CommonProgramFiles"\Microsoft Shared\Web Server Extensions\15\BIN\STSADM.EXE" Happy Coding  !!!
Read more