I'm trying to find a way to merge or combine severl different reports based on the results of a filter. For example, lets say I have 4 tables:
Tables A, B, C, D
Each table contains different information and has multiple records. The primary key field for each table is the same. Each table also has a report that is attached to it (i.e., Report A, B, C, D).
I would like to be able to run a filter, based on the primary key, and then generate a single report that combines the four reports. Here's the catch, when the filter is run, only some of the tables may contains matching information.
For example, I have Tables A, B, C, D with their associated reports A, B, C, D. When I run my filter, the filter only locates matching records in table A, C and D. How do I, or is it possible, to create a single report, created by merging or combining Reports A, C and D that only contains the information from these tables?
Clear as mud? I've searched the forums and haven't really seen any other posts that go along these lines.
Thanks folks!!!!
Tables A, B, C, D
Each table contains different information and has multiple records. The primary key field for each table is the same. Each table also has a report that is attached to it (i.e., Report A, B, C, D).
I would like to be able to run a filter, based on the primary key, and then generate a single report that combines the four reports. Here's the catch, when the filter is run, only some of the tables may contains matching information.
For example, I have Tables A, B, C, D with their associated reports A, B, C, D. When I run my filter, the filter only locates matching records in table A, C and D. How do I, or is it possible, to create a single report, created by merging or combining Reports A, C and D that only contains the information from these tables?
Clear as mud? I've searched the forums and haven't really seen any other posts that go along these lines.
Thanks folks!!!!
