| discoverer [message #89036] |
Wed, 06 August 2003 08:46  |
Erdem
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  |
magnetic
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
