Posted 27 July 2018, 10:16 am ESTDear Concerns,
I am using spread sheets 8.0, i want to show my data for report purpose from below mentioned query,
rssale.Open "Select Ledger.VoucherDate, sum(LedgerDetail.Debit) as Amount From Ledger, LedgerDetail where Ledger.VoucherDate between '" & Text3.Text & "' and '" & Text4.Text & "' and Ledger.Ledgerid=LedgerDetail.Ledgerid and Ledger.dataentrystatus = 1 and Ledger.VouchertypeId = 9 Group By Ledger.VoucherDate", conn, adOpenKeyset, adLockOptimistic
Set fg.DataSource = rssale
when executing this query, no any data showing in fpspread sheet, although i have tried in default component flex grid its working fine there.
please guide how do i solve this issue.