Good day everyone.I am using vb.net 2005Pro as my front end and Access2003 as my back end for my application.Using CrystalReport that comes with the VS package I am able to generate my report with date parameters and it goes something like this:The whole thing was doing fine.Now I want to add a new Parameter named Top which values would come to the user's input.Say if he only wants the Top10 exams during the span of two dates, then the first 10 in my list within that dates would show.Hope we can work on this one.Thanks.VB Code:
Dim xCR as New TopExams xCR.SetParameterValue("FromDate",CDate(ExamTop.dtpFrom.Value.ToShortDateString)) xCR.SetParameterValue("ToDate", CDate(ExamTop.dtpTo.Value.ToShortDateString)) xCR.DataDefinition.RecordSelectionFormula = "{TopExam.MaxOfDateOrders1} >= {?FromDate}AND {TopExam.MaxOfDateOrders1}<={?ToDate}"


Reply With Quote