Procedure to Create a New SSRS Report

Burak Seyhan

12y65k22250Article

22 Comments

Join the conversation! Your thoughts help the community grow.

sunil kumar11y ago
Hhhj
- sunil kumar11y ago
  Sahi hai
Burak Seyhan12y ago
http://www.c-sharpcorner.com/UploadFile/4923b7/adding-parameters-to-ssrs-report/
Burak Seyhan13y ago
Hello Pratik I will write about your problem. Follow me
Pratik Patni13y ago
Hey Burak is there any way where I can use dropdownlist in my ssrs report? is there any such functionality provided my Microsoft? I would highly appreciate your comments on this
Christian Nwamba13y ago
Hi Burak, Follow this link and know if you can help me: http://www.c-sharpcorner.com/Forums/Post/57/visual-studio-2010.aspx
Christian Nwamba13y ago
Please i cant find the template in my visual studio.
- Burak Seyhan13y ago
  How can I help u? Send an email
Burak Seyhan13y ago
Ok Sonam Thank you
Sonam Sharma13y ago
hi burak, its seems a joke has happend with me.i jus saw your above Url just after submitting an article on reportviewer of mine.ll share the url as soon it gets approved.
Burak Seyhan13y ago
Hi Sonam you should look at my other article. Here is the link http://www.c-sharpcorner.com/UploadFile/4923b7/how-to-use-report-viewer-in-visual-studio-2012/
Sonam Sharma13y ago
hi burak..thanks anyways but i have used that reportviewer control.it works great too
Burak Seyhan13y ago
http://www.c-sharpcorner.com/UploadFile/4923b7/how-to-use-report-viewer-in-visual-studio-2012/
Kirti Srivastava13y ago
If i want to pass a user input then how can we use SSRS with stored procedures
Rushal Arora13y ago
can u pls tell how to call the above report in vs2008 through linkbutton (like simply giving querystring or report name page)w/o using reportviewer
Sourav Kayal13y ago
good slides.
Burak Seyhan13y ago
Hi Sonam In VS2010 you have to use ReportViewer tools. I will explain in my next article
Sonam Sharma13y ago
i am using vs2010,i dont see any buisness intellegence new project there to select.
Hemant Srivastava13y ago
Well explained… any beginner in SSRS can easily learn SSRS basics from this article even without opening Visual Studio !
Meet Agarwal13y ago
I like this article
- Meet Agarwal13y ago
  Nice content
Pradip Pandey13y ago
Nice article

The following is the procedure to create a new SSRS Report.

Step 1:

This is the first screen of the project and we click the "Next" button. Select Report Server Project, specify the project name and the finally click the "OK" button.

Step 2:

This screen is a Report Wizard. We need to click the "Next" button.

Step 3:

Change the Name and click the "Edit" button. The Connection properties screen will be displayed.

Step 4:

First of all choose your server name. Select your database from the Combo Box and then click the "Test Connection" button. (We will see a successful result.)

Finally click the "OK" button.

Step 5:

Click the Query "Builder Button".

Step 6:

Select one or more tables from your database and click the "Add" button. The next page is the query builder page. You can write your own query and display the results.

Step 7:

We choose the Columns from the Products table and we can see that. The next page I'm going to execute my query.

Step 8:

Step 9:

Then click the "Next" button.

Step 10:

This screen will open the option to select how the result should display. I choose tabular type. Click on the "Next" button.

Step 11:

If you will see the option here to group the data and show it. It depends on your reports structure.

Step 12:

I can drag and drop data from Available fields to Details.

Then on click the "Next" button.

Step 13:

In this page we see 6 defaults templates. I choose the Slate template and all of the users see this it. Then click the "Next" button.

Step 14:

This is the last page. We will see all the configuration settings here such as Data source information, Report type and style, and your query ext…

First of all write your Report name and click "Preview Report" (optional). Then click on the "Finish" button.

Step 15:

Here is the results.