Hi,
Im using DataEnvironment to create reports. Ive used command named DailySales_Grouping which is grouped by Bill Number. The following is the code to filter data is placed in the cmdShowReport click event. The problem is that it displays error saying Failed getting rowset from the current datasource. Could someone help me with this?

Code:
  DataEnvironment1.rsDailySales_Grouping.Filter = "Date = " & frmInvoice.lblDate.Caption & ""
  rptDailySales.Refresh
  If rptDailySales.Visible = False Then rptDailySales.Show