Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have attached a sample file along with this post.
what my requirement is
I have listboxes like this
T1: A: B: C:
A 1 4 7
B 2 5 8
C 3 6 9
If I may select from T1 either A/B/C or A,B/B,C/C,A or A,B,C.
Now I want to to display only the selected columns along with those values in a seperate tablebox or Straight table.
I think you understand my explanation and what i want.
Note: My system is not having the full version. so,please send details with explanation.
is it possible to do like that?
Can any one help in this?
Thanks.....
Hi,
Check the attached file...
Hi Shans,
thanks for your response.
Sorry to say this , that my system doesn't have fullversion.So, i am not able to open your file.
Can you please send me the logic briefly .
Thanks....
We can implement your requirement in straight table using the conditional show option
1. Cretae a Staright table with A, B, C and an dummy expression like 1
2. Then use conditional show to hide or display the selected column like
For A -wildmatch(getfieldselections(T1),'*A*')
For B -wildmatch(getfieldselections(T1),'*B*')
For C -wildmatch(getfieldselections(T1),'*C*')
Hi,
Create a Straight table.
In that take Dimensions as A,B,C.
Expression as 1
Then go to presentaion tab:
In that For A Column:
Choose the conditional Option and use this Expression:
if(index(concat(distinct T1), 'A')<>0, 1, 0)
For B Column:
Choose the conditional Option and use this Expression:
if(index(concat(distinct T1), 'B')<>0, 1, 0)
For C Column:
Choose the conditional Option and use this Expression:
if(index(concat(distinct T1), 'C')<>0, 1, 0)
Hi Shans,
Thanks for your response
You came clouser to my requirement
What exactly i want is What ever i select from A,B,C should be displayed in the straight table .
Like this
If I am selecting 1 from A, 6 from B, 8 from C.
Then table should be displayed as
A B C
1 6 8
But here it displayed Here i am checking A,B,C and whatever i select from A/B/C those corresponding values from other listboxes are displayed.
Hope so you understand...
Is it possible to do like that?
Thanks...
Hi Jain,
Thanks for your response
You came clouser to my requirement
What exactly i want is What ever i select from A,B,C should be displayed in the straight table .
Like this
If I am selecting 1 from A, 6 from B, 8 from C.
Then table should be displayed as
A B C
1 6 8
But here it displayed Here i am checking A,B,C and whatever i select from A/B/C those corresponding values from other listboxes are displayed.
Hope so you understand...
Is it possible to do like that?
Thanks...