combination of drop downs

[nancysinghal]

Hi All,

I have a requirement, where I have two data drop downs:
1) Region: X,Y,Z
2) Program:A,B,C,D

Also, I have a list that displays region, program and App Count.

I have taken a data deck and place list inside that, and connected the deck to both the dropdowns.
On default selection, list displays all regions and programs. But when user selects any particular region and run the report. The output is displaying data for the selected region and only one program, but it should show all programs under that Region.

Can anyone please suggest. How to get rid of this automatic selection of second dropdown.

Regards,
Nancy

[MFGF]

Hi All,

I have a requirement, where I have two data drop downs:
1) Region: X,Y,Z
2) Program:A,B,C,D

Also, I have a list that displays region, program and App Count.

I have taken a data deck and place list inside that, and connected the deck to both the dropdowns.
On default selection, list displays all regions and programs. But when user selects any particular region and run the report. The output is displaying data for the selected region and only one program, but it should show all programs under that Region.

Can anyone please suggest. How to get rid of this automatic selection of second dropdown.

Regards,
Nancy

Hi Nancy,

You need to stop and consider what you have asked your report to do here. When you use a data deck, it's like having a pack of cards. You can only ever see one card in the pack. Whatever item or items you use to drive the data deck will dictate what cards are included in the pack. As you have based your data deck on both the Region and Program items, you will get one card for each combination of Region and Program values, eg
X and A
X and B
X and C
X and D
Y and A
Y and B
Y and C
Y and D
Z and A
Z and B
Z and C
Z and D

So these are the 12 cards you have asked your data deck to contain. It also sounds like you have added a Default Card which is displayed when neither active report variable has a value, and on this default card you have included a list showing all the Regions and Programs? So these are the 13 cards your data deck has.

When you select a Region, what happens? You are then asking your data deck to display a card for that region. Does it contain a single card that holds a list for that one Region and all Programs? As you can see above from the list of cards, the answer is no. It has four cards for the selected region (one for each Program), so which card do you end up seeing? The first one - that's the behaviour you are seeing right now.

How can you achieve the result you require? The easy answer is to dump the data deck and have the two active report controls filter your list directly. Make sure when you set this up, you select the option to filter, not select.

Cheers!

MF.