Share via

In SQL Server Reporting Services how do I add comments to a dataset query?

Stephen Schleyer 60 Reputation points
2023-11-09T19:56:19.2233333+00:00

I am creating a report in SQL Server Reporting Services in Visual Studios 2019. When creating a query within the dataset properties, how do I add a comment line?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,196 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,940 questions
Accepted answer
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-11-10T01:19:55.5266667+00:00

    Hi @Stephen Schleyer

    The way you add comments in SSRS queries should be similar to adding comments in sql queries.

    I found this link for you: https://qawithexperts.com/article/sql/sql-comments-comment-in-sql-query/410.

    I did a simple test and these comments can be saved.

    User's image

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.