WAD - Script doesn't execute after re-submission with variable values
Requirement: We have a requirement to manipulate the output of the WAD report as these cant be met with standard functions available in Query Designer i.e. namely concatenate cells, color certain cells and change text, and hide some columns after data manipulation.
Solution: We changed the analysis item to Display Mode = Plain HTML.
Added Script Item and wrote a Java script which does the requisite functions and changes the output and format of table at Client side.
We have added the script tag before the </body> tag it works fine when we execute the WAD report for the first time.
Problem: The Function works and manipulates the data only during the first execution i.e. once the WAD report is executed and user enters the variable values and executes it.
Please let me know if you any solution to trigger the function after entering the Variable selection.