Search This Blog

Saturday, 16 July 2011

Crystal Report RecordSelectionFormula + vb.net

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