8 Replies Latest reply: Mar 15, 2016 1:37 PM by dav w RSS

    export every list box field to a excel report tab

      Can anybody help me with the following questions? Thanks upfront.

      I tried to export an excel report with tab of fields of a list box. If I do it manually, it is like I select one value in list box and the real report will change with the list box. Then I export the Excel report. I will go though all the value in the list box.


      I can use pass the variable into list box, but list box value will change with grey out which was not selected.


      The expression in the list box is =If(PreferedField = GivenVariableValue, PreferedField) .

      For example, if I give GivenVariableValue = Apple, the Apple will show in the list box display but not selected.


      Can anyone help me with this issue please? Thanks again.