Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys.
I have 2 tables splited, one of my tables has a primary key with the name of a instance, my second table has thousands of columns that represent components of this instance, almost all collumns are empty but some of thems have a text called OK, the columns that have content depend of the selection of the primary key, my doubt is how i present only the field that match the content based on the selection of my primary key.
To give a better example i give a example of the table:
Instance | App1 | App2 | App3 | App4 | App5 | App6 |
---|---|---|---|---|---|---|
Instance A | OK | |||||
Instance B | OK | |||||
Instance C | OK | OK | ||||
Instance D | OK |
I want that when i select the Instance A in my list appears a text objects with the Field name App3.
This is possible?
This should be feasible to do using Cross Tab in the script.
Thanks,
SP
Yes,
If you have a data similar to this
Are you expecting something like this ??
SP
Are you going to use 1000 columns in this? One way to show the columns conditionally is to use write a show condition in expression tab - Conditional checkbox.
I expect the following result:
Instance | Component |
---|---|
Instance A | App3 |
Instance B | App2 |
Instance C | App5;App6 |
This should be feasible to do using Cross Tab in the script.
Thanks,
SP
Perfect,
Thats is what i was looking.
Thanks for your help