Skip to Content
0
Former Member
Jan 18, 2012 at 08:44 PM

parameter driven report

44 Views

Good Day All,

I have a parameter driven report, but with a twist.

They do not want the users to have to know what each parameter stand for.

Here is the break down.

If the user select

1. (this will spool out all transaction types) (transtype (1,3,6,8,99))

option 2

2. ( this will spool out all transaction types except transtype 3) (Transtype (1,6,8,99))

option 3

3. (this will spool out transtype 3) ( transtype(3))

I've created a parameter call transtype -


type(Number)

list of value static is clicked (*)

Value field I left as (NONE) Description Field (NONE)

Under the value Description

1.00 All Transaction Type

2.00 All Transaction type excluding Money Market

3.00 Only Money Market

Here is where my problem begins, I can't use select expert or maybe I can, I don't know.

How do I select TransType that reflects the parameter the user selected.

So if the user select option 1 all transtype will be select , if the user select option 2 all transtype excludeing transtype 3

and option 3 only transtype 3 will be select.

Kind Regards,

Dmarz