Hmmm....! Try this:
In the script where you added the dummy field, instead of "Click here" use:
Dual("Click here",RecNo()) or maybe an If() statement or Evaluate(). Basically, the second parameter for Dual() needs to be a different number for each of the rows in your attached image (Previous Orders etc).
Then, in the script instead of adding DummyField as a dimension add an expression:
This will ensure all rows are always displayed when you make a selection in DummyField. Now, when you click on one of the "Click here" entries, the number you set in the Dual() function will be selected. You can use this number to conditionally show/hide your text boxes.
I'm on a train and can't test this so I'm not actually sure it'll work! Or if it's really want you want...hope it helps though!
I tried your method.
I added the dual statement in the script.
it added a field into my fields with the name dual("click here" . it does not make any sense.
can u please look into my file
Attached here is the qv file
test.qvw 2.0 MB
LOAD * INLINE [
i have added the above script which added a field Dual("Click here" in my field list... i think there is some problem with the above Dual expression..... I have removed the dimension and added the expression as you guided...but due you to problem with above expression i can not the number assigned by Dual ()
I think you need to put the Dual() line in with your OrderKPI table:
LOAD kpi_id as order_kpi_id,
kpi_name as order_kpi_name,
kpi_format as order_kpi_format,
kpi_indent as order_kpi_indent,
show_in_main_table as order_show_in_main_table,
Dual("Click here",RecNo()) AS DummyField
(ooxml, embedded labels, table is detail_orders);