How to get the Top N of a certain report
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:
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}"
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.
Re: How to get the Top N of a certain report