Error While Passing Parameters to DataReport

[mehtarohit]

I am using DataEnvironment to create DataReport. I am passing Parameters to DataReport but I am getting error. My DataReport is Grouped

For command in DataReport i have the following sql statement :

select * from PurchaseDetails

and in the Click event I have the following code...

DataEnvironment1.rsPurchaseDetails_Grouping.Filter = "PurchaseInvoice.Name='" & cboName.Text & "'"

rptPurchaseDetails.Show



I am getting the following Error :

"Failed getting Rowset(s) from Current Data Source"

--------------------------------------------------------------------

Also I tried using the following code...


sql = "SELECT * FROM PurchaseInvoiceDetails where VoucherDate between #" & from_date & "# and #" & to_date & "# and Name like'" & cboName.Text & "'""

DataEnvironment1.rsPurchaseDetails_Grouping.source = sql
DataEnvironment1.rsPurchaseDetails_Grouping.Open



But still it gives me an Error as field not found as it checks for grouping field in DataMember. In my Details section of report, I am using "PurchaseDetails" as my Datamember.



Any one who could let me know the problem...

Regards.