Home » Developer & Programmer » Reports & Discoverer » discoverer
discoverer [message #89036] Wed, 06 August 2003 08:46 Go to next message
Messages: 2
Registered: June 2002
Junior Member
I would like to select distinct values from a colon but,,
date intervall must be a parameter and user should enter them before the report run (in discoverer viewer),
and according to this interval I should select distinct values of the colon

how can I do This?
Thank you
Re: discoverer [message #89097 is a reply to message #89036] Thu, 18 September 2003 07:27 Go to previous message
Messages: 324
Registered: January 2003
Senior Member
create a parameter called InputVarDate.
create a field on the header with source InputvarDate so the user can input a date when starting the application.
your code should be then:
select distinct(colon)
from myTable
where varDate=:parameter.InputVarDate
Previous Topic: Printing Watermarks with Oracle Report Services
Next Topic: how to pass a parameter from 'Parameter Form' to the query, where 'IN' Clause is used
Goto Forum:

Current Time: Sat Sep 23 20:06:20 CDT 2023