Problems to create DataSources And Add Dataset with Stored Procedure with parameters

Question

I have my asp.net web project and I want to use paginated reports.

I insit: an asp MVC.net project (not a report project). For this task, I add the extensions Microsoft RDLC Report Designer and Microsoft Reporting Services Projects.

Then in my project I add a report. But I have a lot of problems.

First of all. I can't add a data source. I right click on "Data Source" folder but nothing appear

I can only add DataSets (and parametes and images):

Yes, when I select to add DataSet, I can stablish the dataconnection and select my SQL Server DB and tables or stored procedures.

And I select a stored procedure that expects parameters

But now how can I send the parameters to the stored procedure?

I see in other places tutorials of how to do it. But all do the same:

1. They create a datasource (I can't do that, I right click on DataSource folder, but nothing appear)
2. They create the dataSet and specify that is a stored procedure (this image don't appear)

1. They create the parameters
2. They send the parameters into de dataset (this image don't appear)

What is happening?

In the properties of the DataSet only appear "General":

But don't the other options:

Answer 1

Microsoft RDLC Report Designer

RDL C = Client rendering of the report, they work slidly different then reall RDL reports for SSRS = Server rendering.

Answer 2

Hi @SSRS-VS

Yes, as Olaf said, the process of creating an RDLC report is somewhat different from the process of an RDL report.

You can refer to this official document: https://learn.microsoft.com/en-us/sql/reporting-services/create-drillthrough-rdlc-report-with-parameters-reportviewer?view=sql-server-ver16.

If you want to retrieve a dataset using a stored procedure, you can also refer to the discussion here: https://social.technet.microsoft.com/Forums/en-US/04d58240-7ae7-4cf7-a6f0-b5067225b0ad/can-we-filter-the-custom-data-source-using-report-parameter-in-rdlc-files?forum=sqlreportingservices.

Best regards,

Aniya