Data not Shown in Group By Query

Data not Shown in Group By Query

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

• 

  aamirzia.charan

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.

• 

  aamirzia.charan

  • Post Options:
  • Link
    Copy

  Posted 27 July 2018, 5:54 am EST

  Using this component with SQL Server 2012.

• 

  aamirzia.charan

  • Post Options:
  • Link
    Copy

  Posted 27 July 2018, 11:18 pm EST

  Please anyone help please…

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  aamirzia.charan

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  aamirzia.charan

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  aamirzia.charan

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  aamirzia.charan

  • Post Options:
  • Link
    Copy

  Posted 6 August 2018, 9:14 pm EST

  Deepak Sharma,

  ticket has been generated, your attention required.

  Thanks Dear.