How To Create Simple SSRS Report

The Window given below will open. Now, don’t change anything and click the Next button. If you find the default SharedDSource, it needs to be selected. If you have not added Shared Data Source, you need to add New Data Source for the specific report.

Click the Query Builder button.

After Clicking the Query Builder button, the Window given below will open. Now, click Edit as Text option.

In the Window given below, you will get two options for the retrieval of your data, where one is Text and the second is Stored Procedure.

• Text. In Text, you need to add your selected query.
• Stored Procedure. In the Text, you need to add your procedure.

Now, I am using a stored procedure because all the stuff and complexity can be written in the stored procedure.

Now click the “!” symbol. The Window given below will open. Currently, I am using the procedure, so there is one parameter @EmpID, which is available in my procedure. Click the Pass Null check box, select it, and then click the OK button. Now, I am passing a null value for the time being.

The output given below will be displayed. Now, click the OK button.

Click the Next button.

Continue with Tabular and click the Next button.

In this Window, select available fields and add to Display Fields content by clicking the Details button.

Now, click the Next button.

Click the Finish button.

The report given below will be displayed.

There are options available; one design, where you can modify your report as per your requirement, and another one is Preview, where you can see your report preview.

The final output is given below.

I hope you enjoyed this article. Please provide your valuable feedback & suggestions.