How to create SSRS project in Visual Studio

1. Create new SSRS project.

2. Right click on report to add new item.

3. Select the report project template and click Add.

4. You will see the solution as following.

5. You can get your toolbox menu in via the view tab.

6. Click on the report data. Report data missing in the menu tab?? Just mouse over the arrow down icon on the bottom of the view tab, then you will found the tab as the lowest selection in the menu.

7. Add new data source from the report data.

In case you have this error in query designer .

8. Add in the information as follow. You can use the windows credentials or provide the user name and password. ( the user name and password that you key in during the installation of the SQL management tools. Then click ok upon done. You can also customized to prompt user to key-in credential.

9. Done, and you shall see the following.

10. Similar to step 7, now, add new data set. Fill in the following details.

11. Add the table to the designer window.

12. Select the columns to display.

13. Drag and drop the data field to the column.

14. Right click to insert extra columns.

15. You can preview the created report by viewing it at the preview tab.

16. Visual studio will compile and you will have the following preview.

17. This is how to change the property for SSRS column’s text box. Right click on the column and select the text box properties.

18. In this example, I format the textbox to have the date properties. Click ok after you have done with formatted and customized your field.

19. This is what I get after I changed the format.

20. That’s all to create a simple SSRS. If you wish to do more with the SSRS report, you can also add grouping and etc.

21. Here is how you can add total / grouping for the report. First, make sure you have this grouping menu, if not, right click on the design window and check for the grouping.

22. Drag the column from the report data to the ‘row groups’ window.

23. After add the column, an extra column will add automatically.

24. Change to preview, and you will noticed that there is a column that you can remove. Which is the data field added earlier.

25. Delete the column by right click on the column header , and delete.

26. The report is prettier now. ;)

27. You can do more, for example , adding filters  or count. Optionally, you can publish the project.

Reference