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

SSRS-VS 46 Reputation points
2023-05-16T08:22:36.9366667+00:00

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.

imagen

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

imagen

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

imagen

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

imagen

And I select a stored procedure that expects parameters

imagen

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":

imagen

But don't the other options:

imagen

ASP.NET
ASP.NET
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
    2023-05-16T09:22:12.2833333+00:00

    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
    2023-05-17T05:48:33.47+00:00

    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

    0 comments No comments