Hi,

if you go to the advanced tab the XML represents the entire report content.

You can do a copy and replace in your notepad of choice and then paste it back, the only gotcha to watch out for is line wrapping in the wrong place which can make the XML invalid, but I have done this previously for a similar problem and provided you get the syntax totally correct and do not introduce any other corruptions in edit then it will work.

Back up what you have first and good luck!

For future reference you can also create a single union (presuming they are all variations on a theme) and then alter the sql directly to make the creation of the mass union less labour intensive, note you need to do this BEFORE applying any formatting because the minute you apply the sql you will destroy any work you have done on the formatting.