Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have declared two state1 and state2 for the two list boxx of week_num1 and week_num2
in the straight table i have given 4 expresions, out of these 4 expression i have given 2 expresion for the state, remaining two expression dosen't required states
my requirement is to compare the week wise data in column wise
exp1 have state1
exp2 have state 2
exp3 is simply called the filed name
exp4 is simply called the field name.
now my requirement is not meeting, since i didn't give exp3 and exp4 with state.
how this can be resolved ?
that means
what is happening is that
my records getting duplicated
id | des | amt w1 | base_amt w2 | first name | last name |
1 | aaa | 100 | - | - | - |
2 | bbb | 200 | - | - | - |
3 | ccc | 300 | - | - | - |
1 | aaa | - | 100 | - | - |
2 | bbb | - | 200 | - | - |
3 | ccc | - | 300 | - | - |
1 | aaa | - | - | Mano | D |
2 | bbb | - | - | kriwin | S |
3 | ccc | - | - | kenniy | M |
the first name and last name getting null but its being duplicated. this has to come in the w1 and w2
can any one reply me
We don't know about Data model which you done. Will you able to provide sample inline memory or may be QVD;s >>
data model is single table only.
simple concept
out of 4 expression i given state for the exp1--state1 and exp2,--state2
remaining exp3 and exp4 are simply calling the field didnt assign the state