Display Field name Based on Content

[#1]

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?

[Anonymous]

Yes,

If you have a data similar to this

Are you expecting something like this ??

SP

[vishsaggi]

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.

[#4]

I expect the following result:

Instance	Component
Instance A	App3
Instance B	App2
Instance C	App5;App6

[Anonymous · Accepted solution]

This should be feasible to do using Cross Tab in the script.

Thanks,

SP

[#6]

Perfect,

Thats is what i was looking.

Thanks for your help