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

 

Associating Data Dropdown lists (cascading), Tab Control and Data Deck

Started by Khagender, 28 Aug 2014 12:40:12 PM

Previous topic - Next topic

Khagender

I'm trying to create an Active report, which contains various crosstabs - and these crosstabs are different from each other and uses different queries. I want to display each crosstab on different tab using a tab control(NOT Data tab). And all these crosstabs needs to be filtered based on the selections made on the two Data drop down lists(cascading).

I'm able to achieve the above functionality only when I include the data items that are being filtered on Data dropdown list, in the crosstab. But, I don't want to show them on the report output. Also, hiding them (using Box type: none) makes the look and feel of the crosstab, a bit weird.

The other way I'm trying to achieve this is by adding a Data Deck. I'm unable to associate the two Data drop down lists(cascading) with Tab control and/or Data deck.

Can someone can please guide me with step by step process? 

Desired output should look something similar to the one in the attachment.


- Thanks in Advance

MFGF

Quote from: Reddy on 28 Aug 2014 12:40:12 PM
I'm trying to create an Active report, which contains various crosstabs - and these crosstabs are different from each other and uses different queries. I want to display each crosstab on different tab using a tab control(NOT Data tab). And all these crosstabs needs to be filtered based on the selections made on the two Data drop down lists(cascading).

I'm able to achieve the above functionality only when I include the data items that are being filtered on Data dropdown list, in the crosstab. But, I don't want to show them on the report output. Also, hiding them (using Box type: none) makes the look and feel of the crosstab, a bit weird.

The other way I'm trying to achieve this is by adding a Data Deck. I'm unable to associate the two Data drop down lists(cascading) with Tab control and/or Data deck.

Can someone can please guide me with step by step process? 

Desired output should look something similar to the one in the attachment.


- Thanks in Advance

Hi,

You can keep your existing tab control (with one tab for each crosstab)
Next drag a data deck onto the first tab along with the crosstab
Populate the data deck with the data items you want to filter on
Drag the crosstab inside the data deck
Add the items you want to filter on to the query of the crosstab
Link the crosstab to the data deck using a master/detail relationship - based on both data items (which should now be in both queries)
Set up a link from your first data drop down list to the data deck - this should SELECT the data deck based on the item in the list.
Set up a link from your second data drop down list to the data deck - this should SELECT the data deck based on the item in the list

Your first tab is now complete. Repeat this process for each of your other tabs.

Cheers!

MF.
Meep!

Khagender


sukanya

Hi MFGF,

I tried the above way and was able to filter the dynamic map chart using 3 data drop down lists. used default card to initially land on All option page. But when I chose my first item in the list, the map gets filtered by default value of data drop down list2 and list3. I want the dynamic map be filtered by list1 item and then when user selects list2 item then only the map should be filtered. Kindly help.

Regards