sgalaise

I have solved this before by auto-pressing the standard reload button from javascript embedded in the report. Note that it is not picked up by the 'click' event, but by the 'mouseup'. Brilliant! I was going to use the dom to hide the row, but it never occurred to me to dispatch an event! Works beautiful! (Not sure why I can't comment on your answer....)

We have some custom javascript added to our report that performs some backend updates to our database. The benefit is that our report is now interactive, but I am trying to determine how to refresh the current report (similar to the refresh button in the report header) once our API call returns since the action changes the dataset being returned. Anyone have any ides? Thanks, Scott EDIT: For reference, I chose to go the route that Yama818 suggested, but this can be done using the javascript Report object. Open a report in the browser and open up the dev console and type the following: Report.refreshReport();[/code]You will see the report refreshes. I chose not to go this route because I have added an additional event listener on the mouseup event since we are populating part of the DOM after the fact (This lisetener function will now fire if a user manually refreshes the report or we do it programatically). It would be a lot easier if we could embed custom javascript in the report itself instead of creating global javascipt functions in the ViewReport.jsp and manipulating the DOM to trigger events that way.

There is a need to embed some javascript in our repots. I have tried a textfield and am applying a javascript function using the hyperlink reference expression, butcan't seem to format it correctly to apply properties. I have also learned about the now deprecated htmlcomponent, which seems promising, but documentation on how to install that on studio and the server is hard to find. Ultimately, we need to make an ajax call to an internal API passing specific report parameters and row level field values. Looking for any recomendations on which direction to take from the community. Studio: 6.9 Server: 7.1 Thanks, Scott

We have added a connection pool in front of our database (pgbouncer). We have it setup for transaction level pooling, but unfortunately that means PreparedStatements do not work. We can disable it using the parameter "prepareThreshold=0" on the data source url, but that only works for a while and then we start getting errors again: "org.postgresql.util.PSQLException: ERROR: prepared statement "S_1" does not exist". Does anyone have a solution for this? Thanks, Scott