Creating Reports from Services

[MargaretM]

I have a Site Inspections Web Map with an editable feature service that my users (City Inspectors) are updating using the Collector App.  We'd like to consume the service to create a nice looking report to be turned into Management or VDOT.  We have SSRS but I don't know of an obvious way to do this in it.  Right now my data is hosted via ArcGIS Online but am able to host it locally, if that makes any difference.  Is anybody doing this or know of a relatively painless way to do this?

Thank you!

Margaret

[MargaretM]

Ok - I was able to use ESRI Reports to consume the service and make a report.  However, I don't see a way to add any of the attachments that were uploaded using Collector to my report. The only fix I'm seeing is to make a local copy of the data and then export the attachments.  Which, unfortunately, is not an acceptable solution for this project. Am I missing something?