SSRS 2012 to SSRS 2016 causing reports to show different NLS parameters (Oracle 12c (12.1.0.2.0) )

Question

We've recently updated SSRS to 2016 from 2012 - once we updated the server and installed the ODAC we noticed the NLS settings change for reports (for example if we run SELECT * FROM V$NLS_PARAMETERS locally the NLS settings default to UK however when we run this through a report it defaults to US).

This issue is causing day parameters (TO_CHAR(DATE,'D')) and date parameters ('DD/MM/YYYY') to break.

Any advice would be greatly appreciated.

Thanks

Answer 1

Always check nls_session_parameters because that will be the one finally used by the database.

  select * from nls_session_parameters;

And use for example ALTER SESSION To MATCH the parameters with REPORT or vice versa

 ALTER SESSION SET NLS_DATE_FORMAT='DD/MM/YYYY'