Data not Shown in Group By Query

Posted by: aamirzia.charan on 27 July 2018, 1:16 am EST

  • Posted 27 July 2018, 1:16 am EST

    Dear 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.
  • Replied 27 July 2018, 5:54 am EST

    Using this component with SQL Server 2012.
  • Replied 27 July 2018, 11:18 pm EST

    Please anyone help please.......
  • Replied 29 July 2018, 10:15 pm EST

    Hello,

    Could you please let me know if the query returns the data in SQL server? Are
    Also if you do not use the Group By clause, do you see the data properly fetched into Spread control?
    It will be great if you could provide us a sample application to debug.


    Thanks,
    Deepak Sharma
  • Replied 1 August 2018, 1:35 am EST

    Thanks Dear Deepak for kind response,

    same query is returning data as well in MS SQL SERVER.

    here is attached my project, please import database in MS SQL SERVER 2012 to escalate the group clause problem.

  • Replied 1 August 2018, 1:33 am EST

    Dear Deepak,

    my file is not uploaded, please download from below link
    https://www.4shared.com/zip/dCY-bkAree/fptest.html
  • Replied 2 August 2018, 12:00 am EST

    Hello,

    I am not able to download the sample application it, when I click on Download button it does not do anything.


    Thanks,
    Deepak Sharma
  • Replied 4 August 2018, 5:37 pm EST

    Dear Deepak,

    Can you please give me your email address ? as i can able to send you my test project via Email service.


    Thanks
    Aamir Zia Charan
  • Replied 6 August 2018, 12:47 am EST

    Hello,

    You can create a ticket here and attach the sample if it is upto 5MB here:
    https://supportone.componentone.com/newcase

    Thanks,
    Deepak Sharma
  • Marked as Answer

    Replied 6 August 2018, 9:14 pm EST

    Deepak Sharma,

    ticket has been generated, your attention required.


    Thanks Dear.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels