HOW-TO: Bulk Update Result Set in Individual Reports (AM7)
I've just this second figured out how to do this and it has saved me an unbelievable amount of time, so I thought I'd share my (annoyingly simple, when I consider how many hours I've put in to doing this manually!) method.
With your template open, you need to enter VB Design Mode in Word. I'm using 2007, and it's on the developer tab, under controls. In older versions of Word, if my memory serves me, you have to open up the Macro toolbox (it'll be in the View > Toolbar menu I think).
What should now happen is that where previously you had descriptions of all of the aspects and result sets used, you will now see a lot more detail, including a section in each detailing the result set and it's SIMS ID.
For example, I have a result set called "2010/11 Sweep 1" with an ID of "8". In Word Design Mode, this shows as (no quotes) "|^2010/11 Sweep 1^|^8^|"
It's now just a simple case of performing a find & replace to update the result set! You can find the result set's ID (you want the external ID) by opening it up in assessment manager, it'll be in the detail panel.
NOTE 1: One thing to note is that as "^" is a special character in Word find & replace, you'll have to type it twice to escape it i.e. "^2010/11 Sweep 1^|^8^" becomes "^^2010/11 Sweep 1^^|^^8^^".
NOTE 2: You may also want to update the first part of the string, the description. It won't affect the output, but it'll help you later on to identify which result sets you are using.
NOTE 3: ALWAYS back up your templates before you mess with them like this!
