Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    153

    Unanswered: Layout Trigger in Developer Report

    Hi All,

    I have written one Layout Trigger in Developer Report 6i to suppress few records ( say, display only those employee records whose salary is more than 10000) . Now bottom of the report I want the following summery information :

    Total records in table Total records displayed


    I would like to know, how to populate the second info. i.e 'Total records displayed '.


    Thanks

    Jayanta....

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    why not

    select count(*)
    from table
    where {whatever restriction you used to get the report on the first place}

Posting Permissions

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