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

Stephen Schleyer 60

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?

Chuck Roberts 105 Reputation points

2024-09-25T12:16:40.29+00:00

You can also use comments in the SQL query like this: /* This is a comment. */ It can be a single or multi-line comment.

Accepted answer

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.

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
Please sign in to rate this answer.

1 person found this answer helpful.
AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor

2023-11-13T09:08:43.06+00:00

Hi @Stephen Schleyer

Did the answer help you? If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.

Best regards,

Aniya
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

0 additional answers

Your answer