Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    11

    Unanswered: Showing last 12 out of 100 records

    I have a table having TDate, TCode, Bill, Rcvd fields with 100s records
    I want to show last 12 records of a particular TCode in CR 8.5
    Please help me
    Farooq

  2. #2
    Join Date
    Sep 2006
    Location
    Liverpool, UK
    Posts
    15
    hafizfarooq -

    Did you find a solution to this? I'd be very interested in you answer as I'm trying to do something similar!

    Thanks.
    If you're too busy to go fishing . . . . . then you're too busy ! ! !

  3. #3
    Join Date
    Sep 2006
    Posts
    30
    you have to take the total no of records and from that using a formula field u can print the last 12 or n records.
    ex:
    whileprinting;
    if recordno > recordcount-12 then true else false;

    recordno is the present record no and recordcount is the total no fo records.

    this may solve ur problem.

    Pavan
    Pavan.ponnapalli@cognizant.com

Posting Permissions

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