Hi Phil and welcome to the forum.
Yes you can do something on that order that you want in Monarch.
First off is all your cost centers in one column? If so, is it possible to do what you want with a runtime parameter.
I would export out a list of unique cost centers in your report via the summary table to whatever you want, database, spreadsheet or text.
I would set up a runtime parameter calculated field with the same format as your cost center column.
Next I would set up a filter where the cost center field is equal to your runtime parameter.
Then I would set up a script to do all the work and to read each of your cost centers one at a time from your table you just created and apply it to your runtime parameter. Then apply your filter and export it out.
All this can be done via scripts. Check out the [url="http://www.datawatch.com/pdf/products/monarch/Monarch_8_Programmers_Guide.pdf"]Programmers Guide[/url] for VB help in scripting or the Help files in Monarch for command line help.
Hi there Ralph,
Thanks very much for your advice (I thought it must be possible). As per your note, I have created the runtime parameter calculated field and a filter that equals the runtime parameter but then get stuck (ie: no black belt). Can you spell it out in more detail please how I run these steps.
Also I don't use VB regularly and would prefer to do the whole exercise in Monarch. I think you are saying that the only way to automate this task is to use some scripting outside of Monarch (ie: to string the steps together)?
Let me know if you need my specific files to look over.
Thanks again, Phil
I sent you a private message outlining some of the steps.
I hope I didn't make it too confusing or sound too difficult.
Ralph /b[/quote]Since this is exactly the same problem I'm trying to solve, I was wondering whether you could post the solution you sent privately here for all of us other "noobs" to review?