Monday, March 10, 2014

Concenate the expresion in SSRS reports in Dynamics AX 2012

Sometime when we create report in SSRS, often we must concenate string with variabel or the the expression.

by the example : ssrs expression in the textbox

first way..
create texbox and enter this expression
="Mars Odyssey was launched in "& First(Fields!AsOfDate.Value) &" to hunt for past or present water on the red planet."
second way..
create texbox and enter this expression only
=First(Fields!AsOfDate.Value,"TCN_RencanaFillingDP")

after that insert the text before the expression
Mars Odyssey was launched in

and then insert the other text after the expression
to hunt for past or present water on the red planet.

like this pictures below



i am prefer the second way.
:Dpr

READ MORE - Concenate the expresion in SSRS reports in Dynamics AX 2012