If you are unable to create a new account, please email support@bspsoftware.com

 

data tab control filtered by selected item in data drop down list active report

Started by curious, 28 Nov 2014 07:04:43 AM

Previous topic - Next topic

curious

I created a query consisting two items : country and cities
I duplicated this query

In a data drop down list it is possible to select the country.
I want the cities of that country to be displayed as tab-labels in a datatab control.

When I want to create a connection between the list and the data tab control I only can select "Select" as a behavior while I want to "filter"
I have tried a lot of values for the data-item in source- and target control but nothing works. what am I doing wrong ??

Because I want to describe my problem a simple as possible this is a theoretical description of the issue i am facing.

MFGF

Quote from: curious on 28 Nov 2014 07:04:43 AM
I created a query consisting two items : country and cities
I duplicated this query

In a data drop down list it is possible to select the country.
I want the cities of that country to be displayed as tab-labels in a datatab control.

When I want to create a connection between the list and the data tab control I only can select "Select" as a behavior while I want to "filter"
I have tried a lot of values for the data-item in source- and target control but nothing works. what am I doing wrong ??

Because I want to describe my problem a simple as possible this is a theoretical description of the issue i am facing.

Hi,

You cannot filter a data tab control because the tabs are determined and rendered as the MHT file is created (ie when the report is run from Cognos Connection). What you are attempting to do here in filtering a data tab control is not possible in this form. An alternative would be to put your data tab control within a data deck. Have the data deck driven by Country, and the data tab control having Country in its query and Cities driving the tabs. Set up a master-detail relationship between the data tab control and the data deck based on Country. Your data drop-down list can then select the data deck, and you will end up seeing a card for the selected country, populated with a data tab control showing tabs for the cities in that country.

Cheers!

MF.
Meep!

curious

that was an option I tried too.
After your answer I created a report from scratch.

A data list box with countries to select and a data deck.
To check if things did not went wrong I place country in the datadeck.
The connection between list and data deck is country and I can select filter as "behaviour"

Unfortunately the displayed value of the country in the data deck does not change when i select another country in the list box
When I filter another listbox with the selected value of the first list-box everything works fine.


I really need a weekend   ;)

MFGF

Quote from: curious on 28 Nov 2014 08:37:21 AM
that was an option I tried too.
After your answer I created a report from scratch.

A data list box with countries to select and a data deck.
To check if things did not went wrong I place country in the datadeck.
The connection between list and data deck is country and I can select filter as "behaviour"

Unfortunately the displayed value of the country in the data deck does not change when i select another country in the list box
When I filter another listbox with the selected value of the first list-box everything works fine.


I really need a weekend   ;)

Hi,

Your data list box variable needs to SELECT the data deck, not filter it. Your variable needs to select a card so SELECT is the option to use.

MF.
Meep!

curious

Oeps, that did it. Thank you very much.

The original report has a lot of repeaters etc. So I hope everything works now as intended.