NS6 environment
What I want is to create one Report (Showing all incidents of last month for one department) with a parameter "Department" with some SQL-logic behind it.
First I created a report with inter-active parameters and this went well.
When this gave me the correct results I removed the SQL-logic around report-Department-parameter and left it behind as a basic parameter withour user-interferance. This SQL-logic I call [SQL-Department] for here.

Now I wanted to create just one Notification Policy [NP] that would get all departments and run the report for every department it finds...
Sort of "For every Department you find, run this report".  Am I asking to much?

I tried to enter [SQL-Department] in the query part of [NP] and tried whatever possible... did not work
I tried to enter {SELECT 1} in query and enter [SQL-Department] as a "query-parameter" and tried whatever possible, gave me a real error!
Anybody there to get this done? Or am I asking to much?

So, now I will create one [NP] for every department and hard-code the Department as a [NP] parameter. This does run correctly...
But not what I wanted as I will have much more [NP] as I asked for...

Guido