Results 1 to 2 of 2

Thread: How to get the Top N of a certain report

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2006
    Posts
    274

    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:
    1. Dim xCR as New TopExams xCR.SetParameterValue("FromDate",CDate(ExamTop.dtpFrom.Value.ToShortDateString))
    2. xCR.SetParameterValue("ToDate", CDate(ExamTop.dtpTo.Value.ToShortDateString))
    3. 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.

  2. #2

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2006
    Posts
    274

    Re: How to get the Top N of a certain report

    anyone please?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width