Re: Reports 2.5: User Parameter, Initial Value --> today's date

In article <344e6e93.79586197_at_news.rice.edu> bkane_at_rice.edu (Brian Kane) writes:
>From: bkane_at_rice.edu (Brian Kane)
>Subject: Re: Reports 2.5: User Parameter, Initial Value --> today's date
>Date: Wed, 22 Oct 1997 21:31:06 GMT
 

>Dmitri-
 

>I am aware of the before parameter form trigger, but I have not been able to
>make it work in this situation. Here is what I tried for this
 

> function BeforePForm return boolean is
> today DATE;
> begin
> today := to_char(SYSDATE);
> return (TRUE);
> end;
 

>This compiles, but I have no way of using this value (today) in the Initial
>Value field. Report triggers must return a boolean value, and they don't
>allow arguments.
 

>Any further thoughts?
 

>Thanks,
>Brian

Your before parameter form should look like this

begin
:P_date_desired := trunc(sysdate);
return(true);
end;

where :P_date_desired is the name of your parameter. You don't need an initial value since this trigger will fire before you can access the parameter form. Received on Thu Oct 23 1997 - 00:00:00 CEST