1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Group filter

Discussion in 'Oracle Forms and Reports' started by oramac, Mar 2, 2015.

  1. oramac

    oramac Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    I'm trying to apply a filter on a complex report.
    But it doesn't seem to work on a simple tabular report with a filter that shows a few rows.
    The filter doesn't seem like it's firing. Does this function need to be called from a trigger? I'm running from the paper layout.

    function GroupFilter return boolean is
    begin
    :cnt := :cnt+1;
    if :cnt <= :10 then
    return (TRUE);
    else
    return(FALSE);
    end if;
    end;
     
  2. oramac

    oramac Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    ANSWER: Set the filter attribute on the group filter properties (drop down) to PLSQL. Attach the function.
    The filter is applied immediately when compiled.