I'm using Cr2008 with an Oracle db as my data source. I need to create an application tracking report by country. EU is both a region and a country in the database, so there are applications that list EU as a country. Most applications are at the country level, so you have multiple countries assigned to a single application. My problem is my client wants to see EU applications appear under each member state. How do I replace the EU country field with all EU member countries, so that an EU application will appear under all EU member countries??
EU
App 1
App 2
App 3
France
App 4
App 5
Germany
App 6
App 7
Using the example above, I want apps 1, 2, and 3 appearing under both France and Germany, along with the rest of the EU member countries. Any ideas??
EU
App 1
App 2
App 3
France
App 4
App 5
Germany
App 6
App 7
Using the example above, I want apps 1, 2, and 3 appearing under both France and Germany, along with the rest of the EU member countries. Any ideas??