is there an area that allows you to view the sql that creates this report in reckon account 2014

Caleb Donald_8336184
Caleb Donald_8336184 Member Posts: 24 Novice Member Novice Member
edited October 2024 in Reckon Accounts (Desktop)
is there an area that allows you to view the sql that creates this report in reckon account 2014

Comments

  • Zappy
    Zappy Accredited Partner Posts: 5,256 Accredited Partner Accredited Partner
    edited August 2019
    Nope. Well unless you want to shell out for the sdk and become a developer partner. Good luck
  • Chris McGregor
    Chris McGregor Member Posts: 138 Novice Member Novice Member
    edited August 2016
    I would hit up the QODBC website and sp_report. Best go google it for faster searching. Basically the deal is there is no direct SQL queries again the reckon account database as it all gets intercepted by the SDK as Kevin mentioned and the QODBC uses the SDK as a bridge to get data out of reckon account. When using most apps for reporting such as crystal you can select odbc as the data source and either select the desired tables or add SQL script. Also heaps of online examples Cheis
This discussion has been closed.

Categories