Re: Resticting Parameter LOV in Reports
From: MarkyG <markg_at_mymail.tm>
Date: 12 Nov 2001 00:42:23 -0800
Message-ID: <ab87195e.0111120042.5d47d203_at_posting.google.com>
Date: 12 Nov 2001 00:42:23 -0800
Message-ID: <ab87195e.0111120042.5d47d203_at_posting.google.com>
You can,
If you have 2 related fields and the LOV on the second depends on what was entered on the first field, you can write a query referencing the first field.
e.g Select username from dba_tables where username = :block.username;
HTH, Mark
heidecarrier_at_oasas.state.ny.us (heide) wrote in message news:<1005319766.439678_at_proxy.storm.co.za>...
> In developing my parameter screens, I need the ability to restrict the
> list of values in "parameter #2" based on the value entered in "parameter
> #1". Has anyone had any success in doing this, or is it just not possible?
>
> Posted via www.orafocus.com - Focusing on the World of Oracle
Received on Mon Nov 12 2001 - 09:42:23 CET