Creating Dataset in VS2020 using SQL query rather than visual designer

Thomas Benson 0 Reputation points
2024-05-08T11:12:55.34+00:00

I'm creating .rdlc reports using the extension in Visual Studio 2022, but when creating Datasets, I'm only able to do using the graphical designer and cannot create or edit Datasets by writing my own SQL. What am I missing?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,723 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,835 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,941 Reputation points
    2024-05-09T01:20:39.9666667+00:00

    Hi @Thomas Benson

    Not clear about your issue, could you please give more details?

    From my side, when creating dataset, we could directly write the query or import from files or use query designer.

    User's image Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.