Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Comments in SSRS Report Expressions

Tags:

I'm using some complicated expressions in Reporting Services to control the value, format etc of data in a report (see MSDN).

Is it possible to insert code comments into these expressions, and if so, what is the syntax?

By code comments I mean something like:

// single line comment /* or multi line comment */ 
like image 689
Sophia Avatar asked May 20 '09 03:05

Sophia


People also ask

How do you comment code in SSRS expression?

Try using apostrophe to write a comment. 'This is a sample comment. EDIT: VB doesn't really have multiline comment. EDIT2: Also, it seems that comment should be in the end.

How do I comment in RDL file?

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.

How do I use IIF in SSRS expression?

Using IIF Function in SSRS We are going to add a new field to the report data set to determine if the Order Year is the Max or Current Year. As shown below, the dataset properties window is opened, and the Fields tab is selected. After clicking Add, at the bottom of the list a new field is added.

How do you write if else condition in SSRS report expression?

Value = “2”, TRUE, FALSE)) SSRS: IIF expression with several ORs Employ the syntax beneath to use Multiple OR in an IIF expression in SSRS. =IIF((Condition1) OR (Condition2) OR (Condition3), True, False) In SSRS, we have two choices for determining whether such a parameter is BLANK or EMPTY: =IIF(Len (Parameters!


1 Answers

It looks like VB Code.
Try using apostrophe to write a comment.

'This is a sample comment.

This is a guess :)

EDIT: VB doesn't really have multiline comment.
However, try using the following to see if it works

  'This is a sample comment _ followed by a new line _ and the comment ends  

If that doesn't work, you could do

 'This is a sample comment 'followed by a new line 'and the comment ends 

EDIT2: Also, it seems that comment should be in the end.

like image 79
shahkalpesh Avatar answered Sep 18 '22 17:09

shahkalpesh