How to create a SSRS report using sql server query

Pardhu2020
Posted by in Sql Server category on for Beginner level | Points: 250 | Views : 2897 red flag
Rating: 5 out of 5  
 2 vote(s)

Hi friends today we are going to have a walk through on how to create SSRS reports using SQL queries

Introduction


Hi friends today we are going to have a walk through on how to create SSRS reports using SQL queries.

  1. Click on the file and select project to create a new project.

  1. Select the report server project wizard for creating SSRS report .
  2. Type the required project name in name text field….
  3. Click on Browse button and select the destination path to save the project ..
  4. Click on ok button to save and proceed .
Welcome to the report wizard:


  1. Welcome wizard is the 1st step to create report . if you don’t want to see this window for every report click on Don’t show this page again . 
  2. Click on NEXT button to continue .
Connection Properties:


  1. Server Name: Select the server name from where you are generating report . Enter the server name in that drop down box . 
  2. Log on to the Server:  Select in which mode  authentication is required . if you click on user windows Authentication then user name ,Password . if you click on use sql server authentication then we need to enter both user name and password .
  3. Click on Test Connection to test wither connection was established are not 
  4. Once all the information is filled OK Button will be enabled .


  1. Have a Look on Test Connection succeeded popup . Click ok and continue
  2. Click on ok Button and continue the report .

Report Wizard:



  1. Past the required Query at Query string . 
  2. Click the Next Button to continue .



  1. Select which type of report is required . Click on tabular for table format report . 
  2. Click on Matrix for matrix format report.

Design the Table:



  1. Available fields: At available fields area we will see all the columns where we can select and move them based on the requirement if u want them in page format ,Group them or you need a Details view . select the and move them in the required boxes …
  2. Once the column is selected them click on Details button and move them into Displayed fields . 
  3. Click on Next button to continue .

  1. All the colunm from available fields are movied into Details text box .
  2. Click on Next Button to continue.

Choose the table Style:

  1. Click on different styles and see the preview based on your requirement select the report style . 
  2. Preview window for the report style.
  3. Click on Next button to continue.
Choose the Deployment Location:

  1. Deployment folder : Folder name where our SSRS project is going to deployed . 
  2. Click on next button to continue.

Completing the Wizard:



  1. Report Name: Enter the SSRS report name. 
  2. Click on finish button to complete the SSRS Report.

Preview of SSRS Report:



Conclusion:


In this article we have seen how to create SSRS report from SQL query. Next article we will discuss  how to create SSRS report from stored procedure with filters.

Page copy protected against web site content infringement by Copyscape

About the Author

Pardhu2020
Full Name: Pardha Saradhi
Member Level:
Member Status: Member
Member Since: 3/19/2013 2:21:22 PM
Country: India

http://www.dotnetfunda.com

Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)