This is becoming more urgent with every passing day. Having hundreds of review definitions and reports going along with them, it becomes unmanageable. So I want to create a report "template" that would take workflow job variables and expand them to their values.
For example, we might have a report giving a detailed information on currently running review (we have between 15-30 reviews running at any given time. Don't ask. :-) ). so the only thing changing in the review is the results review name.
So, I want to have an escalation running every week, for example, from within results review that will run such a report. So if the review definition is "Supervisor Career Change Review", the review result would be "Supervisor Career Change Review-1", and so on (1, 2, 3, 4, and so forth). Currently it can be handled with "LIKE" clause but I want to avoid it (each review result would run the same report, in essence). I want to drill down to "Supervisor Career Change Review-1" and that's where workflow job variable comes in.
Is there a way for me to pass it to a report definition (e.g. :VAR in a report)? If not, I can run query directly in the workflow but how would I dump it to a CSV as I believe, you do not provide access to file system, correct? I want to stay away from java here.
Any ideas, direction would be greatly appreciated.