reporting services - SSRS SSDT I am trying to display a 2nd field (from the same dataset) in a matrix, in the same column -
The interesting problem I got stuck on is because it sounds so easy
I use Visual Studio 2010 I am
= Field! AccountName.Value & amp;
My example should display without pay: salary saving
/ code>
< P> The field is without pay (account name.value), if there is any data from there, then I would like to add a colon expression (:) if another value is coming, second value from salary saving (LeaveName.Value )Before posting anything I tried,
= Field! Accountant.Valuue + IIF (Ezines (Fields! Live Niem.Value)), ":", "")
who did not give any errors and did not even drag data into a The test is the example where I know that the person used the holiday without pay: salary saving
fix. Text box added to the expression under property
= Field! Accountant.value + iif (IsNothing (Fields! LeaveName.Value), "": + Fields! LeaveName.Value)
Also if necessary were required to play with the Cry group Tablix properties went to 1. Filter the Tablix A. Expression > = Fields! AccountName.value + iif (IsNothing (Fields! LeaveName.Value), ":," + Fields! LeaveName.Value) Or if it does not match anything, it may be: = Field! AccountName.Value + Field! Skip Name Value
b << Skip with Pay
c expression = field! AccountName.Value + Fields! LeaveName.Value
D
= Field! AccountName.Valuue + iif (Trim (Sextract (Fields! Live NAmView)) = "", "", ":" + + Field! Revname Value)
Comments
Post a Comment