Let us assume we have dataset with below fields:
Score can be defined as (attemptno, scored, total, rank)
Now, I want to split this score column to four columns as 'Attempts', 'Scored', 'Total', and 'Rank'. To add this column we need to add below expression to text boxes.
StudentName | Score |
A | 2,90,100,8 |
B | 1,80,100,7 |
C | 1,90,100,2 |
Score can be defined as (attemptno, scored, total, rank)
Now, I want to split this score column to four columns as 'Attempts', 'Scored', 'Total', and 'Rank'. To add this column we need to add below expression to text boxes.
=(Split(Fields!
Score.Value,",")).GetValue(0) =(Split(Fields!
Score
.Value,",")).GetValue(1) =(Split(Fields!
Score
.Value,",")).GetValue(2)
=(Split(Fields!
Score
.Value,",")).GetValue(3)
No comments:
Post a Comment