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.
<script type="text/javascript" >concat_text();</script>
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.
But after that if user clicks on the Button, which we have added to call the Variable screen then this Javascript is not getting executed. The page refreshes with selected variable value and displays the actual data without any manipulation.
I tried adding the calling the script in <body onload="“javascript:concat_text();" > but it doesn't work.
Please let me know if you any solution to trigger the function after entering the Variable selection.
Regards,
Nitin S.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.