Is it possible to build a report that shows data lists from multiple modules?
The "single page" report I've been asked to create is based at the global client account level. This is where they want a run-time filter to select various key accounts to look at multiple data sets for the multiple child accounts associated with this key account. They want groupings of rows and columns lists of all contacts, Won contracts, and Open contracts.
| Parent Account (run time filter) | ||
| Child account 1 | ||
| Contact 1 name, title, etc. | ||
| Contact 2 name, title, etc. | ||
| Contact 3 name, title, etc. | ||
| Child account 1 | ||
| Won Contract 1 Name, Team, etc. | ||
| Won Contract 2 Name, Team, etc. | ||
| Won Contract 3 Name, Team, etc. | ||
| Child account 1 | ||
| Open Contract 1 Name, Team, etc. | ||
| Open Contract 2 Name, Team, etc. | ||
| Open Contract 3 Name, Team, etc. | ||
| Child account 2 | ||
| Contact 1 name, title, etc. | ||
| Contact 2 name, title, etc. | ||
| Contact 3 name, title, etc. | ||
| Child account 2 | ||
| Won Contract 1 Name, Team, etc. | ||
| Won Contract 2 Name, Team, etc. | ||
| Won Contract 3 Name, Team, etc. | ||
| etc. |
Is this even possible without custom reporting programming?
