I have a report (A) which lists out x number of locations based on a variable (Always less than the 100 limit)
I created an agent based on this report A and wish for it to run another agent running report B using the location as a filter condition of location:
As far as I understand this should run the second agent x number of times, each time filtering by the separate location, this would mean I would receive x number of report B split up in x number of emails, split between Location.
Now the only issue I am finding is the "Invoke per Row" check box is unable to be selected:
Am I doing something incorrectly? Is what I am attempting to do not possible through OTBI?