10-31-2017 07:44 AM
When using a Header Table (situated at the report level) to drive any number of detail tables within various sections I find it most confusing as to how VA (7.4) determines the mapping on the various fields. I also have the same key fields throughout all the tables with the expectation that it is meant to map on these fields. I have read the VAUG and still not any the wiser.
Urgently looking for more detailed information on how the mapping of data sources happens please.
11-02-2017 11:46 PM
There are two ways you can map the two tables ..
1. through interaction .. once you will define interaction between two objects from different data sources, the mapping window will pop up and you need to provide mapping columns ..
2. If not interaction, you can use parameters to be set as filters ..
for example drop-down1 based on table1 is assigned column1, you can create a parameter and assign it as parameter for the same drop-down1. Once you choose a value from the drop-down1, the parameter will hold that value and say you have bar-chart1 based on table2's column1 .. you can filter the bar-chart1 where column1='parameter1'p ...
hope it helps ..
11-03-2017 03:30 AM
11-03-2017 04:50 AM
Parameters are available regardless of the selected table thus they are available throughout the report and doesnt require interaction and thus no mapping is done ..
But if you use interaction between two objects one from table1 and the other from table2, a pop up window will ask you to map the two sources using the key or a combination .. if you are using any such interaction where two objects have two different data sources .. check the interaction and edit it .. at the pop up screen you will find the mappings right below the interaction options ..