Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - How do I remove subtotals and blank lines in sp_report
Posted by Jack - QODBC Support on 31 March 2016 07:38 AM

Troubleshooting - How do I remove subtotals and blank lines in sp_report

Problem Description:

I'm trying to link a general ledger report in Excel. I've created the sp_report SQL query in Microsoft Query just fine, but the data it returns contains subtotals and blank lines. I know I can write a script/filter in Excel to eliminate these lines, but I can't figure out what parameters to use to do it using QODBC.


Solution:

In QODBC, You can remove subtotals and blank lines in sp_report by adding the below condition.

where RowType='DataRow'

For example:

sp_report ProfitAndLossDetail show TxnType, Date, RefNumber, Name, Memo, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisYearToDate' where RowType='DataRow'



(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).