Dim strWhere as String = ""
strWhere = "{qryLoan.IssueDate} IN #" & dtpBegDate.Value & "# TO #" & dtpEndDate.Value & "# "
mReport.Load("..\Reports\loan.rpt")
mReport.RecordSelectionFormula = strWhere
Here I am generating report using query called "qryLoan" and vaule selection form column called "IssueDate" in between "dtpBegDate" to "dtpEndDate" using datetimepicker controls. hope this will help those who are unable to solve the problem.
any question just comment it. thanks.
No comments:
Post a Comment