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

SSRS-VS 46 Reputation points

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

I insit: an asp 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)

User's image

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

User's image

What is happening?

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


But don't the other options:


A set of technologies in the .NET Framework for building web applications and XML web services.
3,362 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,386 Reputation points

    Microsoft RDLC Report Designer

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

    0 comments No comments

  2. AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor

    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:

    If you want to retrieve a dataset using a stored procedure, you can also refer to the discussion here:

    Best regards,


    0 comments No comments