Re: Report Parameter !

[Carlton Conley <cconley@CDG-INC.COM>]

if you are using as delivered here is the flow:

{prompt-date} is defined in the setenv.sqc

So you would then by including the askaod.sqc the following:

display 'Enter the ''As Of'' Date ({Prompt-Date}) for this report or press'

  input $AsOfDate 'enter to default today''s date as the ''As Of'' date'

  etc

If the $AsOfDate is = ''
then it uses $AsOfNow which it gets from Curdttim.sqc which sets that
variable = to depending on the database, essentially the SYSDATE.

So you need to include all the sqc's mentioned and any referenced within
them to have the prompt-date = the sysdate if not filled in by the user.

Hope that helps

Carlton

> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of Hartono Sutirman
> Sent: Monday, April 12, 1999 3:16 AM
> To: Multiple recipients of list SQR-USERS
> Subject: Report Parameter !
>
>
> Hi...
>
> I'm a beginner in peoplesoft and just learning about SQR.
>
> I want to make a report with a parameter called AsOfDate, to make this
> report I copied the existing panel that already have the Parameter
> AsOfDate.
> But everytime I click the run button, the parameter already have a value
>
> ??
> Where does this value come from ???
> What I want to do is, to default the parameter to current date.
>
> Does anyone know where the program to default the parameter value is
> located ???
>
> any suggestion would very appreciated,
> thanks in advance !
>
> regards,
> Hartono Sutirman
>