Parameters

[Former Member]

Hi All,

Please suggest hoe to do this.

I have a report where I need to show a drop down with 2 parameter values male and female.

If I select male it should show male values with another drop down list.

If I select female it should show female values with another drop down list.

Here male and female are column names.

Please suggest

[abhilash_kumar]

Hi Divya,

You need a table that has values mapped to either 'male' or 'female'. E.g:

Gender     Name

Male           AA

Male           BB

Female       CC

Female       DD

If you have a table like this, then you just need to create a 'Dynamic Cascading Prompt'.

Create a new prompt and set its 'List of Values' option to 'Dynamic'. Then under the 'Value' column choose the 'Gender' column first. On Row two of the same column choose 'Name' column. Click the option 'Click to create parameter' as well.

You would also need to add a Record Selection Formula if you wish to filter the records based on the selection.

-Abhilash

[Former Member]

Hi Abhilash,

My table structure is like this.

Male          female

aaaa           bbbb

cccc           dddd

eeee           ffff

I need to show a drop down list with male and female.

And based on selected values I need to show respected values for male or female.

[abhilash_kumar]

Hi Divya,

Try this:

1) Create a SQL Query with this code:

Select 'Male' Gender, T1.Male from Table T1

UNION

Select 'Female', T2. Female from Table T2

2) Add this query to the report via the Add Command option and DO NOT join it to the other tables

3) Create a 'Dynamic Cascading Prompt' as suggested above pointing to these two columns.

Hope this helps.

-Abhilash

[Former Member]

Hi

Tyr this ,

1.Parameter

type@Select distinct gendertype from table

2.Parameter

name@select name from table where gendertype=''@type'

-Rajesh N