In reply to Rick.

Hi Rick,
We have multiple report APIs that may satisfy your needs. I'd like to take a look at this use case with a couple of colleagues. If possible, could you post this same question in the Developers Community? You can reference this blog post. If you need assistance in starting the thread in the community, let me know and I can assist.

We can work on solving it there and dialogue will be much easier to handle. Once we come to a resolution, we can report back here with a link to the thread.

Thanks,
Joe