COGNOiSe.com - The IBM Cognos Community

i have 2 data items.... with names X and Y among some data items to which 2 prompts are needed to retrieve that whole data either with help of X or Y known to the user.

My report format should be like this

In report page with some data items.....
In Prompt page:

2 radio buttons like below

0 'X'
0 'Y'

If i select any one among X or Y, it should lead to another prompt which dropdown the data as per the selected 'X' or 'Y'

any good idea's ???

i came to know that i should write case statement,
how to write case statement ? and where should i write ?

Hi,

Mentioned below is the syntax for Case Statement:
CASE [Country]
    WHEN 'Canada' THEN ([list Price] * 0.60)
    WHEN 'Australia' THEN [list Price] * 0.80
    ELSE [list Price]
END

Also I have  attached the snapshot for the same to locate where exactly it is used in the Query Explorer.

There is also an other way of doing this.You can  use cascade prompts. For this you need to pass the value of the first prompt into the query of the second prompt.

Hope this helps you :)

Thanks and regards
Prerna
-----------------------------------------------------------------------------------------------
pchaudhary@infocepts.com | www.infocepts.com
-----------------------------------------------------------------------------------------------[/list][/list][/list]

Hi,

I think you can achieve this by using Cascading prompts without the need of Radio buttons.

i can do it with cascading prompts, but

2 radio buttons with names X and Y needed in a prompt and a dropdown list needed in another prompt,

the dropdown can show the data item based on the selection of the radio button X or Y

Hi,

If your implementation says you need a Radio button for X and Y, and the second prompt should be a Drop down.

1.Drag a Value Prompt,assign it with the data item with Value X and Y,in the proprieties pane select the 'Select UI' option and change it to 'Radio button group',and change the Auto Submit property to 'Yes'.

2.Drag another Value prompt,assign it with another data item you want,in the proprieties pane select the 'Select UI' option and check its a 'Drop down list'.

3.In the query of the second prompt(drop down prompt) pass on the filter of the first prompt.e.g. suppose your 1st radio button group prompt if for Product line and Drop down prompt is for Product Type. the in the Second Query in the Detail filter section add a filter as  "[Sales (query)].[Product].[Product line] = ?Product_Line?".So this would automatic cascade second prompt from the first one.

I hope you needed the same.Let me know if your requirement is different, will try to resolve that:)

Thanks,
Hitesh
----------------------------------------------------------
hthakkar@infocepts.com|www.infocepts.com
----------------------------------------------------------