AR 15 Web Designer - ODBC Datasource parameters not working as expected

AR 15 Web Designer - ODBC Datasource parameters not working as expected

Posted by: nicolaas.coetzee on 4 April 2022, 9:08 am EST

• 

  nicolaas.coetzee

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 April 2022, 9:08 am EST - Updated 30 September 2022, 4:26 pm EST

  Hi

  We are using the AR 15 Angular Web Designer and Viewer along with a custom implementation of the report service. And we are trying to pull data from a PostGreSQL DB. I have confirmed that this scenario works when no parameters are used.

  In the breaking scenario it is a simple view with a single parameter as a DataSet trying to pull data from a ODBC DataSource as seen in this image

  

  1490×660 113 KB

  However, the report immediately breaks when trying to preview.

  We have setup the same scenario with MS SQL and Oracle with and without parameters and everything works as expected. According to this doc https://www.grapecity.com/activereportsnet/docs/v15/online/parameters.html ODBC parameters should work the same as “SQL Client” parameters.

  Any guidance would be appreciated
  
  Thanks

• 

  nicolaas.coetzee

  • Post Options:
  • Link
    Copy

  Posted 4 April 2022, 9:23 am EST

  For reference the error thrown by the viewer states the following “ERROR [42703] ERROR: column “dat” does not exist; Error while executing the query”

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 5 April 2022, 5:54 am EST - Updated 30 September 2022, 4:26 pm EST

  Hello Nicolaas,
  
  Please use “?” instead of “@dat” in the query? I have shared a screenshot for reference.
  
  Also share your observations with us so we can report this to the concerned team.
  
  Regards,
  
  Akshay
  
  

  

  812×675 18 KB

• 

  nicolaas.coetzee

  • Post Options:
  • Link
    Copy

  Posted 5 April 2022, 7:52 am EST

  Hi Akshay

  Thank you for the promt reply. I have tried your suggestion and it seems to be working, much appreciated.