One report to filter another dataset

[LukeL]

Hi all,

I have somehow a dumb question, but understand if what we need to obtain is somehow feasible or not.

We have some tables Y1..Yn that all have in common a certain ID (possibly not unique) and a table X that hase the ID associated informations.

What we need/would like to obtain is this:

in one report, prepare a lot of objects that act as filters to identify some IDs (the filters come from all the tables Yn, and do not filter by ID, they just identify some IDs).

in another report (or page) having a table objects that show the ID from the X table filtered for just the IDs (possibly hundres of) identified by the "filter report".

Is this obtainable in some way? Actually we have mange to filter the second table just by mapping the two tables by all the columns we use to filter, but se last table does not have them all, since they would cause duplications on data...

Thanks for any support!!! 🙂

[FredrikE]

Which version of VA are you using?
You should be able to do this eiter with report linking or using parameters.

[LukeL]

Hi, we've tried with both 7.5 and 8.4, but with no luck... In all the version it expect that data source linking is build on columns available in the report object from witch you make the link on the other... At least as far as we have been able to see

[FredrikE]

Hm, you might need to prepare the tables, add the attributes to each if them..