I am using v6 QODBC + Enterprise Edision v6 + 200Mb DB

I am running report something like this

sp_report CustomerBalanceDetail show Date, RowData, Amount, AmountDifference,  DueDate, OpenBalance, PaidStatus, TxnType, SalesRep parameter DateMacro = 'All' where PaidStatus = 'Unpaid'

using Crystal + QODBC

It takes HOURS to get this report. Is this something wrong with my query or how it should work. Also I've read about V7 and performance. It will help if I will have v7? Significantly or how? Any ideas about performance?

Thanks

Vitali

The QODBC optimizer doesn't optimizer QuickBooks reports called using sp_report. I suggest you limit your date filter using DateFrom={d'2006-01-01'}, DateTo={d'2007-06-01'} instead of DateMacro = 'All', ie:-

sp_report CustomerBalanceDetail show Date, RowData, Amount, AmountDifference,  DueDate, OpenBalance, PaidStatus, TxnType, SalesRep parameter DateFrom={d'2006-01-01'}, DateTo={d'2007-06-01'} where PaidStatus = 'Unpaid'

Thank you for  your help.
Is there any other way, such as:

replace sp_report with SQL query and use next version of QODBC, correct? If yes, we have 6.0 do you have upgrade for new version?

Thanks,

Vitali