If you know the device locations and their corresponding state options, I would do the following: - create a parameterized report that will accept $P{location}. In that report, create another parameter called $P{state_select_sql}. Create a definition for $P{state_select_sql} to build your A.device_state IN clause. For example --
$P{location} == 'UK' ? "('Test', 'Maintenance'...)" : ($P{location} == 'ITALY' ? "do this" : keep going until you get them all)
Insert $P!{state_select_sql} into your query in the WHERE clause. Then you'll have a report that can work for any location.
Next, create an outer "wrapper" report. Create 6 detail bands and add your parameterized report to each detail band. Pass in the location to each as a parameter. The outer wrapper report will run the parameterized report for each location in one final report.
