Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do you comment out a line in a reporting services function?

Nothing I have tried so far has worked...

like image 638
NibblyPig Avatar asked Sep 23 '09 12:09

NibblyPig


People also ask

How do you comment out an expression in SSRS?

Comments in SSRS Expressions are implemented with a single quote. Comments can be added either on the same line as the expression or on the next line. Comments cannot be added in the beginning or middle of the expression. There is no concept of multi-line comments.

What is IsNothing in SSRS?

Functions are almost always used at some point within an expression. A particular function we are going to touch on in this article is called IsNothing. This function will let you inspect the value of an object to find out if it is NULL or not.

What is report expression?

Report expressions are the powerful features of JasperReports, which allow us to display calculated data on a report. Calculated data is the data that is not a static data and is not specifically passed as a report parameter or datasource field.

How do I create a parameter in SSRS report?

To add SSRS Report Parameters, Right Click on the Parameters Folder present in the Report Data tab will open the Context Menu to select Add parameters.. option. Once you click on Add parameters.. option opens a new window called Report parameter Properties to configure the parameter properties in SSRS.


1 Answers

To comment out source code that is placed within the code section of the Page Properties of a Reporting Services .rdl file simply place an apostrophe in front like so.

'ADD YOUR CODE HERE

Take a look at the following article on SQL Server Central:

Adding Custom Code to Reporting Services

You can also use an apostrophe to place comments in an Expression withing Reporting Services controls. This only appears to work if the comments come after the expression defintion. For example:

= "Test"
'Add Your comments here
like image 124
John Sansom Avatar answered Nov 01 '22 02:11

John Sansom