/
View the SQL query used by a Report

View the SQL query used by a Report

Owned by Nick Snyder (Unlicensed)
Feb 06, 2015

All reports within the TallySales Management System use a single query to display the report Data except for spreadsheet based reports.  A spreadsheet based report opens directly in a spreadsheet application such as Microsoft Excel and not the TallySales Report Viewer.  An example of the a spreadsheet based report is the Register Activity report found in the Financials section of Reports Explorer.

 

Step-by-step guide

  1. Open the TallyReports Report Explorer.
  2. Highlight the report to retrieve the SQL query from within the tree view.
  3. From the Quick Access Toolbar (QAT), Select the Edit Report icon (The Report Designer window appears.)
  4. From the Report Explorer Pane, Expand Data Sources
  5. Expand TallySalesDatabase
  6. Right click on ReportFields and Select Edit (The DataSet window appears at the General page.)
  7. Select the Query page.
  8. Retrieve the report query from the Query section.
  9. Select Cancel (The DataSet window closes and returns to the Report Designer.)
  10. From the Menu, Select Close (The Report Designer closes and returns to the TallyReports Report Explorer.)

Report Explorer pane
DataSet's General page
DataSet's Query page

 

Related content